Visit https://www.workato.com/integrations/quickbase for information about our Quickbase pricing plans, customer stories, examples of recipes and to sign-up for our Quickbase webinar.
Comparing values within a table (between multiple records) is useful when trying to find a particular record with certain criteria.
The first step should return an array of all the records you want to compare. You can do this by creating a field (checkbox) in Quickbase and check all the records which contain the values you would like to compare.
In the 2nd step, choose Utilities as the app and Log Message. In the message, click the toggle for "formula mode" at the end of the field. Choose the "records" array pill (demarcated by the array icon) and use the .pluck formula.
You should pluck the value in the specific field you want, and put in the record ID of that field behind "f_". This effectively creates an array of all the values that you want to compare. You may do other functions such as ".min" and ".max" to compare numerical values.
See this recipe for an example of how this can be used: https://www.workato.com/recipes/283949-copy-of-new-record-in-quickbase-will-search-records-in-a-quickbase-table