Zapier - Find to return Multiple Records


#1

I have been using Zapier successfully to implement Airtable to Airtable automations (creating records for multiple customers etc) for a client and I have come across a case where it would be fantastic if there were a Find Records (Plural) which would return a comma separated string of record IDs (or even better an array of objects) which could be used in subsequent Zapier steps to do some process on all records.

Mentioning the Array of Objects above, I have had to write Javascript in Zapier to convert the strings you return from linked fields into these - it would neat to have an option for the step to return these as arrays of objects instead to remove the need for this in some cases.


#2

Has anyone found a solution to this? I’m not a dev, so javascript is probably beyond my capabilities here. I have a database I’m using Zapier to query to tell me if a record is still valid (is “now” between the “start time” and “end time” for a record). More than one record could be valid, however Zapier is only returning one. I need all of them.


#3

Has this feature been enabled? I want Zapier to send out birthday emailers to all those who have birthday on that particular day. However, Zapier finds only 1 record and sends him the birthday emailer.


#4

Hi Nishant

It has not - however there is another way - Integromat is a similar product to Zapier but it handles multiple returned records inherently and has much superior logic capabilities.

The only downside is that while building the logic there are occasionally some hiccups with Airtable preventing access to it’s API (this only happens with Airtable and is due to AT I believe). I am very keen for this to be solved and we need AT to step up and sort this with Integromat!!!

Julian


#5

Thanks Julian! I appreciate you replying to my query. However, I read a few blogs and it says you can write a piece of code in Zapier to create a loop, to find multiple records. I haven’t tried that yet though. Thanks for suggesting Integromat. I’ll give it a try! :slight_smile:


#6

Hi Nishant

I have written several blog posts about looping through records in Zapier - but it requires Javascript (which I hate personally) and requires that all records are returned in an array (basically a single field with all the linked records you want to process). You can’t set up a Zap to query the database to retrieve multiple records and then process through them. This is inherent in Integromat. Also, Zapier can’t do branching logic.

Don’t get me wrong, there are many good reasons to choose Zapier (the sheer number of connections available being the main one) but at the moment Integromat is much more powerful in terms of logic, looping etc.

Julian