Halloo! I need to search for the biggest number among the values in a field in Airtable.
For example, in Table A, there’s a field called “Quantity,” and Table A contains three records, with values 2, 6, and 4, my query would return 6.
The Airtable action Find Record with something like “MAX({fieldname})” in the search formula seems like the ticket, but I don’t know the correct syntax. I would love more documentation about how to use <TriggerValue>.
What else I’ve found so far is this reference to Webhooks by Zapier, but I prefer not to upgrade to Premium at the moment. And the “Learn More” link on the Zapier action is to this suggestion about Multi-Step Zaps, but that article is about a lot of needs other than mine. Maybe looping…?
Thanks for thinking about this!