Check if a value is in a list of records
I have two tables in a relationship and need to check if the value in a field in the entered in the parent table exists in a column in the child table. The use case, the parent table contains order ...
Forum Discussion
Johnny,
your logic works fine for the instances where the verification team is able to locate the auto generated ticket. However, that is not the issue. The issue involves orders that the verification team cannot find the auto generated ticket (mainly due to missing data in the order). In those cases there a manual ticket is created and there is no connection to the order, therefore the summary field will not return any results.
------------------------------
Paul Peterson
------------------------------
Hi Paul,
the GetFieldValues() function might work for this use case. They are a bit tricky to set up, and I don't have a ton of experience with it yet. Here is the QB documentation https://help.quickbase.com/user-assistance/formula_queries.html
Their samples only use the record id as the query but we have been able to use other unique fields as well.
------------------------------
Johnny Lundgren
------------------------------
the GetFieldValues() function might work for this use case. They are a bit tricky to set up, and I don't have a ton of experience with it yet. Here is the QB documentation https://help.quickbase.com/user-assistance/formula_queries.html
Their samples only use the record id as the query but we have been able to use other unique fields as well.
------------------------------
Johnny Lundgren
------------------------------