airtable-filters

Pass a filters object to Airtable MCP tools that list records, with each condition containing an operator and an operands array whose first element is a field ID. Multiple conditions combine with AND by default, or with an explicit top-level operator like or.

Single select filters require choice IDs such as selABCDEFGHIJKLM, not display names. Look up the table schema to find choice IDs, then use operators like =, isAnyOf, or isNoneOf with an array of choice IDs.

Yes, nest a filter object as one of the operands to mix AND and OR logic. Each nested filter has its own operator and operands, enabling patterns like Bucket = Scripted AND (Status = Writing OR Status = Pre-Production).

Use the isWithin operator with a date range object such as {"mode": "pastWeek", "timeZone": "America/New_York"}. Direct date comparisons use a date value object instead of a raw string, and a timeZone must always be included.

Filtering by a collaborator group ID matches the literal group, not its members. Set operatorOptions with matchGroupsByMembership set to true so operators like hasAnyOf match individual members of the group.