About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.
Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.
Have a question? Let's get you an answer!
Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.
All of our best learning resources can be found here.
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.
Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.
Check out what is new and upcoming with Zapier with our regular product updates.
Early Access Program
Want to join Early Access? Learn more here.
Look as good as Zapier makes you feel with our new swag storefront.
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?
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.
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 :)
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.