Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

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!

Hi @BaseFace, welcome to the Community! 👋

Ah, as it’s a search formula the Zap is expecting here, that may be why “MAX(values)” isn’t working.

Rather than using a webhook, you could create a separate Table in Airtable with a single record. Then add a Rollup field to link that record to the ones you want to summarize and use MAX(VALUES) as the formula for it. Then you can use the Zap to search for that table’s record so that it always finds the highest quantity.

If you’ve not worked with Airtable’s Rollup fields before you can find out more about them here: Rollup field overview

I couldn’t find any more documentation on using Airtable’s search formulas than this Advanced tips and tricks one, which you may have already come across? But in order to use <TriggerValue>, you’d need to wrap it around field that’s been selected.

For example:
c61d80a83196f72c63ec068365dd5852.png

Hope that helps to point you in the right direction, keen to know how you get on here!

Thank you, @SamB! I had tried the rollup field, but I wasn’t sure how in Airtable to automatically include every record from the other table. I will post that question in the Airtable community, but if anyone here knows, I’d be grateful for the further pointer!

You’re welcome, @BaseFace! 

You could potentially use Airtable’s built in Automations to automatically link the records. They’ve got a guide on how to do that here: Linking existing records using automations
 
Please do keep us in the loop on how that goes! 🙂

Ah that’s superpower @SamB! That did the trick, and I never would have thought it would require that kind of workaround. Thanks a ton!

YAY! That’s fantastic news @BaseFace. I’m so pleased you were able to get it sorted! 😁🎉

Happy Zapping! ⚡️

Terms & Conditions