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