Skip to main content

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!