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}="luke@skywalker.com"
Formula: AND({Email}="luke@skywalker.com", DATETIME_DIFF({Date},TODAY(), "day")>=0)
If you need more complex formulas, go to — Formula Field Reference
