• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home App Resources Quickbase

Quickbase: How to compare values within a table

Modified on: Wed, Aug 10, 2016 at 3:37 PM

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

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2020   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato