Find Records by Formula

The Find Records by Formula action passes a formula directly to Airtable and returns the field objects for records where the formula is truthy.

Inputs

Input	Type	Required	Description
Third-party account	Airtable account	Yes	Account with record-read access.
Base ID	String	Yes	Airtable base ID.
Table Name or ID	String	Yes	Table name or ID.
Filter Formula	String	Yes	Airtable formula used as `filterByFormula`.
Sort Field	String	No	Field used to order matches.
Sort Direction	`asc` or `desc`	No	Sort direction. Defaults to `asc`; used with Sort Field.

Example:

AND({Status} = "Open", {Amount} > 1000)

Output	Type	Description
Records	List of objects	Fields for matching records.
Count	Number	Number of matches returned.

The action requests at most 1,000 matches and omits Airtable record IDs from each output object.

Airtable rejects the formula

Test it in Airtable first. Field names with spaces need braces, text needs quotes, and function names must follow Airtable formula syntax.