This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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.
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.
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!!!
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! :slightly_smiling_face:
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.
Could you elaborate on how you find to return multiple records with Integromat, please?
I’m trying to understand how Integromat works, I have a hard time with building steps so far. Still, I can clearly see the potential of this service compared to Zapier (A perfect mix would have been the UX + catalog of apps supported by Zapier combined to the automation power of Integromat) and will work on it over the next weeks to understand how Integromat works.
I’ve also had a look on your blog but I didn’t find a post about this.
Thanks for your help!
It’s simply a matter of using a Search Records Airtable option in Integromat - if this returns more than one record (you can set a maximum) then every succeeding step will process for each record found.
You can set search criteria in the Formula field.
Hope this helps.
What If you don’t know what the maximum is? I am trying to use this in a way where it loops until there are no more records matching that criteria.
Also, If the record already exists. I wouldn’t want to duplicate it and return them again.
Do you have a solution for this?
I have the same idea with the Birthday emails. However, running a Zap once a day and send an email to the person whose birthday it is on that day, will only send one email per day, even if multiple birthdays are in the database.
I think if a control flag with the current date would be set on the returned record after the email is sent, and this would be included in the search criteria, then the zap could run multiple times a day, and would each time return another record:
This search would return another record or none, every 5 minutes. Not very efficient, but this could work.
This saved me a lot of frustration today. Thank you for this recommendation!