Hi @robertandrews!

The first thing to point out is that the Find Record search action for Airtable will only return one record, it wont return all records that match the search. That means that the search step can’t return all records that match the criteria. 

If you only need one record, then for this kind of search you’d want to use the Search Formula field. In there, you can add a search formula that’s formatted in the way that Airtable uses search formulas to find the record that you’re looking for. 

Airtable has a guide to getting started with formula here: Help crafting an Airtable search formula 

If I’m creating a search formula for a Zap, I start by testing it out in Airtable first, that way you can quickly test and edit the formula to make sure that it’s finding the record that you expect. 

Hi @robertandrews!

I just wanted to check in with you to see if you’d managed to get things working with the Airtable search formula, or whether you could still use some help here. Please let us know :)