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.

Hi

 

I am trying to explore Airtable now to see if it can do what I was able to do with Google 

sheets ..hopefully better.

 

There does not seem to be a way to select multiple records and then search through those records.

 

For example in the following example I want to select all the records that match Utah. Of those 3 records I want to find the record with the lowest number in the Monthly Leads to date column.

 

 

Any advice would be appreciated.

 

Thanks

 

Galen

Hi @leadrouter,

Right now there is no way to select multiple records in an airtable view with zapier. Unfortunatly it will only allow you to select one at a time. 

I would recommend using Integromat specifically for this function. They allow for the functionality you are looking for and looping of multiple found records in airtable.

Hope this helps!

Happy Zapping 👍🤓

Thanks @XRay Tech uggh… I was hoping to not have to learn another system.

 

I was able to search for and return an array of records. Do you happen to know the approach to selecting the one with the lowest number in the Monthly Leads to date.

 

I am looking at adding a filter between 2 Airtable but I don't think that is the method

Hi @leadrouter 

Airtable has APIs which can be used for your use case of retrieving multiple records: https://support.airtable.com/hc/en-us/articles/203313985-Public-REST-API

App APIs can be used in Zap steps with the Webhooks action: https://zapier.com/apps/webhook/integrations#triggers-and-actions

 

Also, Code steps can be used to do more advanced data handling: https://zapier.com/apps/code/help

@XRay Tech Ignore my last message. I spent so much time looking for weird workarounds to simple task that I ignored the obvious. Sort asc..duh!

Terms & Conditions