# Find the records that match a condition

> Find the records that match a condition: 4 companies fully do it, 4 with a limit, 10 carry the tag. Every listing in Spreadsheets & operational tables with the reason and a source.

- Canonical: https://www.anchorterminal.com/niches/spreadsheets.filter-records/
- Markdown: https://www.anchorterminal.com/niches/spreadsheets.filter-records/index.md (~1,150 tokens)
- Slim: https://www.anchorterminal.com/niches/spreadsheets.filter-records/index.min.md (~280 tokens, same facts, less prose, for token-sensitive contexts)
- JSON: https://www.anchorterminal.com/niches/spreadsheets.filter-records/index.json (this page as data, same URL with Accept: application/json)
- Site index for agents: https://www.anchorterminal.com/llms.txt (the key docs and every listing in one file, at most 16 MB, about 4 million tokens: https://www.anchorterminal.com/llms-full.txt)
- API: https://www.anchorterminal.com/api/v1/index.json
- MCP: https://www.anchorterminal.com/mcp (the whole catalogue as tools, no key)
- DNS: dig +short TXT <slug>.grade.anchorterminal.com (the grade as a DNS TXT record, for a sandbox with no HTTP where names still resolve; also top., best.<category>. and <a>.vs.<b>. under the zone, and the same under grade.letme.dev)
- Licence: CC BY 4.0, credit Anchor Terminal and link this page (https://www.anchorterminal.com/terms/#data)
- Updated: 2026-11-15

Four or more companies' docs show a full fit.

| Companies, full fit | With a limit | Carry the tag | Share of the category's work | First-hand accounts |
| --- | --- | --- | --- | --- |
| 4 | 4 | 10 | 11 | 4 |

## What counts as done

Only the matching records returned by a server-side filter in one call per page.

Measured, for our own tests: the count agrees with the same filter in the product's own view.

How agents ask for it: which deals are still open; show the rows where checked is true; find customers in Berlin; list tasks due this week

## Does the job

The docs show it meets the test above, and nothing we read says otherwise.

- **Airtable (Formagrid Inc (doing business as Airtable))**: filterByFormula filters on the server and pages with offset; a view parameter applies a saved view's filter, and POST /listRecords carries long formulas.
- **Baserow (Baserow B.V.)**: List rows takes filter__{field}__{type} with filter_type AND or OR, a JSON filters tree, or view_id to apply a saved view, server-side and paged.
- **SeaTable (SeaTable GmbH)**: POST /sql/ runs SELECT with WHERE, sort, group and join on the server with ? placeholders, across normal and big-data storage; List Rows with view_name applies a saved view's filter.
- **Teable (Teable AI, Inc.)**: List records takes a filter object of field, operator and value (or filterByTql), enforced on the server and paged, and /aggregation/row-count takes the same filter to check the count.

## Does the job, with a limit

It does the job, but something in the docs or a user's account will get in an agent's way. The limit is named in each row.

- **Coda (Superhuman Docs) (Superhuman Platform Inc. (parent of Coda Project LLC))**: List rows takes query as one column:value equality, filtered on the server and paged. Ranges, dates such as due this week, and several conditions cannot be expressed, so those need a pre-filtered view or client-side filtering.
- **Grist (Grist Labs Inc.)**: The filter parameter maps a column to a list of allowed values, enforced on the server. Ranges such as due this week need the SQL endpoint instead, which loses the records shape.
- **NocoDB (NocoDB Inc (doing business as NocoDB))**: where takes field conditions joined by and or or, with whereTz for dates and a /count endpoint to check. acc-16 (open) reports the filter ignored and every row returned after 2026.10.1.
- **Smartsheet API + MCP (Smartsheet Inc.)**: GET /sheets/{id} takes filterId for a filter already saved on the sheet and rowsModifiedSince, and /search/sheets/{id} does text search. An ad hoc condition cannot be sent, so a new filter needs to exist in the sheet first.

- not this job: Google Sheets API (Google LLC): Reads take A1 ranges or data filters on grid ranges and developer metadata, not conditions on cell values, so the agent reads the range and filters itself; the map names this blocker.
- not this job: Microsoft Excel (Microsoft Graph workbook API) (Microsoft Corporation): Listing rows supports $top and $skip paging; no server-side condition on cell values returns only matching rows, so the agent reads the table and filters itself.

## What stops agents finishing

- filter silently ignored and every row returned
- no query on the API, only A1 ranges (Google Sheets)

## Around it

Before: spreadsheets.read-table. After: spreadsheets.update-in-place, email.send.

## Where this comes from

Weight 11 of 100 in Spreadsheets & operational tables: 4 of 35 accounts: NocoDB checkbox filter ignored, Grist paging, Teable linked fields, Grist with n8n; Google Sheets has no server-side filter at all

As data: https://www.anchorterminal.com/api/v1/use-cases/spreadsheets.filter-records.json, or the MCP tool get_use_case with id spreadsheets.filter-records. Draft, read 2026-11-15 from public docs and first-hand accounts, not yet reviewed by a person.

---

Query this catalogue directly over MCP: https://www.anchorterminal.com/mcp (Streamable HTTP, no key). How: https://www.anchorterminal.com/agents/#mcp
