Zapier Search Formula

[Stephen_Sulliva]

I am trying to create a ‘Find Record’ Airtable Task in Zapier that finds a row based on the values in two columns, {USER ID} and {TAGGED RX}.

The USER ID should match the value in a previous step and the TAGGED RX should equal 0. This is the formula I am using, but it is creating an error:

{USER ID}="{{29838037__user__user_id}}"&"{Tagged Rx}=“0”

Is there a mistake in my code?

Thanks you!

[Julian_Kirkness]

You should read the following article - particularly the section about search formula and the use of :

Airtable - Support

Using Zapier's Multi-Step Zaps to find and update records

Zapier is a third-party service that connects Airtable to many other apps and services. This article is specifically designed to teach you how to design Multi-Step Zaps for the purpose of creating ...

[Stephen_Sulliva]

Thank you. I read that, but the search code that I using to find the row
must have a syntax error. I have the example in that article, but it is
not close enough to what I am trying to do for me to debug my search
formula.

[Julian_Kirkness]

Hi

Could you share a screenshot of the search formula within the Zap - so we can see it in context?

[Stephen_Sulliva]

Here is a screenshot of the code that I have: https://www.dermacare.com/wp-content/uploads/2017/12/Zapier-Airtable.jpg

Thanks for your help!

[Julian_Kirkness]

Hi Stephen

Here’s an example of a working formula in Zapier:

Note that Airtable uses the AND() function not the ampersand - and I’m not sure whether the 's are required when you’re comparing to a littereral (0).

Alternatively, you could also use an Airtable view to filter the records for {Tagged RX} = 0 - and then use the Limit To View option in Zapier.

[Stephen_Sulliva]

Julian! Thank you very much for your help.

It worked!

[Andrew_Andrievi]

Hi Julian,
Thank you for this formula, it’s great!

But by using this formula I can get just one matching result (row).
How I can get all matching results (rows)?

[Julian_Kirkness]

Hi Andrew

mmm - Zapier isn’t very good at dealing with multiple records in the same Zap (unless you want to write Javascript in a code action that is).

If you want to be able to query a table and process through all the records that are returned by the query, I think I would recommend using Integromat instead - when it retrieves multiple records, then all following steps are processed to each which is so simple.

I strongly recommend Integromat - but if you use it with Airtable you need to be patient sometimes when building the processes because it times out and you have to wait 5 minutes. This is a limitation of Airtable’s API and a) should be FIXED and b) doesn’t effect live running.

[openside]

another option for handling multiple records in Zapier is our On2Air: Actions product