I need to find all Airtable records whose field “Record ID” starts with “rec”.
How can I do that using the Search Value and Search Formula fields?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+12- Zapier Staff
- 3731 replies
Hi
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.
+11- Zapier Staff
- 2115 replies
Hi
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 :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.