Airtable search formula in Make.com
How to write an Airtable search formula on Make.com?
Start with some rules
Use the curly bracket to reference a Field (Column) in Airtable, for example:
{Order Status}
Do not use the Make.com equation function (the green = ), use typed
=
Remove all unnecessary spaces
Put strings into brackets
Examples
Formula: {email}="[email protected]"
Formula: AND({Email}="[email protected]", DATETIME_DIFF({Date},TODAY(), "day")>=0)
If you need more complex formulas, go to — Formula Field Reference