Help

[Zapier] How to do searches of multiple fields?

2499 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Kahlil_Corazo
4 - Data Explorer
4 - Data Explorer

Hello,

I have a zap that checks for an email. I have two fields - primary and secondary emails.

The zap only searches for one field.

Is there a way to search multiple fields?

There’s this advanced formula https://support.airtable.com/hc/en-us/articles/218151657#formula

But I don’t know the syntax for something like search x AND y.

I tried this but it didn’t work:
{Email}OR{Email 2}="{{42033181__output}}"

Thanks,
Kahlil

2 Replies 2
Noel_Howell
6 - Interface Innovator
6 - Interface Innovator

I’m pretty sure the solution involves nested OR statements.
(OR({Search Result}={Email},{42033181__output},(OR({Search Result}={Email},“not found”)))

If it doesn’t find either, it will return “not found”

Support_IT
6 - Interface Innovator
6 - Interface Innovator

Hello,

Did you finally find a solution to search an email in 2 fiels (pro and personal for example) with the Zapier "Find record in Airtable" action ? 

Thanks to Gareth Pronovost Youtube channel, I found this : 

OR({Email_field_1}="<TriggerValue>Email-value-to-search-for<TriggerValue>",{Email_field_2}="<TriggerValue>Email-value-to-search-for<TriggerValue>")

Links : https://www.youtube.com/watch?v=_d-q0r8H_hI&t=272s

When building automation to support your Airtable databases, you'll likely encounter the need to FIND A RECORD in Airtable. This is one of the action steps that Zapier makes available with the Airtable integration. Finding a record is commonly used in situations when you need to update a record ...