About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Airtable - select multiple records in view

  • 8 June 2021
  • 4 replies
  • 803 views
L
Userlevel 1
Badge

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

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

XRay Tech
Badge +4

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 👍🤓

L
Userlevel 1
Badge

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

Troy Tessalone
Userlevel 7
Badge +14

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
L
Userlevel 1
Badge

@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