Search & filters

Every table has a search box that narrows its records as you build a query — by free text or by specific fields.

Build a query

1. Type any text to match across the table. It matches the names of the records a table links to as well: type a customer's name to find their invoices.
2. Or pick a field, a matcher (is, contains, before, after…), and a value. Add more conditions to narrow further. Numbers are written the way your language writes them: amount:>15,000 is more than fifteen thousand.
3. Pick several values for one field to match any of them; conditions on different fields must all match.
4. A record you pick from a linked field's list — customer: then a name — shows in the box with its name, like Customer: Acme. Its × takes it out, and so does Backspace at the start of the box.
5. The list follows what you type, once you pause. Enter or Search runs it right away — on the Calendar and the Map, that's how it runs.
6. The × at the end of the box clears the search and shows every record.

Can't find a record?

Under the search box, at the right, the table says how many records it shows: 36 records when that's all of them, or 5 of 36 when a search or a view narrows them — the main view the table opens on included. If a record doesn't show, check the search: clear it with the × at the end of the box to see the whole table.

Inside a collection

A collection field (a table of rows inside a record, like line items) is filtered by one of its columns: pick the field — it reads line_items. — then the column, then a matcher and a value, so the query says line_items.title:hammer or line_items.qty:>10. A record matches when any of its rows does. Text columns suggest their values as you type; number, money and date columns take the same comparisons and ranges as a plain field.

Dates

When the value is a date, the menu shows a calendar. Click a day, or just keep typing — the calendar follows what you write and jumps to 2026-03 as you type it. For is between, pick the first day and then the last: due:2026-03-01..2026-03-15. From the keyboard, the down arrow steps into the days, the arrows move between them, and Enter picks one.

Date filters also understand relative words like today, this week, or last month — written in your own language.

For a whole month or year, write just that much of the date: due:2026-03 is every day of March 2026, and due:2026 the whole year. They work in comparisons and ranges too: due:>=2026-03 or due:2026-01..2026-03.

A person field filters by who it names: pick someone from the list, or @me for whoever is looking — assigned_to:@me is your own to-do list, and a view saved with it shows each person theirs.

Deleted records

If you can edit the table, Deleted in the field menu — deleted:* — searches its deleted records instead of the live ones. Add a date to narrow it, like deleted:last_week. See records for restoring them.

Sort

Click a column's name to sort the list by it, and again to reverse it. An Options column sorts in the order the field lists its options, not alphabetically; a record with several sorts by the one listed first. Records with none sort with the empty ones.

Save a query as a view

The bookmark beside the search box, Save view, keeps the query — together with the columns you show and the sort order — as a named view, just for you or, if you manage the table, for everyone. Or save it as the table's main view, so the table opens on it. See views for saving and sharing them, and records for working with the results.