+11Im trying to use airtable record search in Make . . .I have a field called PostID. I want to search it for a number. I Cant find anywhere how a simple airtable syntax works for this .. is it {PostID}=”123456” or do i put search or someting in front of it?
+35
Make accepts normal Airtable formulas.
You can test your desired formula by creating a test formula field in Airtable, and type in the Airtable formula that you want to use.
If your formula results in a non-zero, non-empty, non-error value for any particular record, then Make will find that particular record in your search results.
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+11Thank you - i realised that make wouldnt run the text split in the same field as the airtable search . . made all the difference. Now to take your aadivce and slowly port a lot of workflows from zapier to make
+1The tip about testing your formula in an actual Airtable formula field first is genuinely useful and saves a lot of trial and error in Make. The syntax is exactly standard Airtable — {PostID}="123456" works fine, just make sure numeric fields get compared without quotes around the value. Moving workflows from Zapier to Make is worth the effort, the scenario structure gives you so much more control.
Try using an airtable formula directly. If PostID is a number field:
{PostID} = 123456
If it's a text field:
{PostID} = "123456"
No SEARCH() or other function is needed for an exact match. If it still doesn't return a record, double-check that the field name matches exactly and that you're using the Formula field in the Make module.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
