[Zapier] How to do searches of multiple fields?


#1

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

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”