Find records
Filter record lists by field, combine conditions and sort by columns. Lists the operators available for each field type.
Narrow a record list with filters and change its order. Use this to find overdue invoices, customers in one city, or orders above a value.
Filter a list
- Open a record type's list.
- Above the table, pick a field in the first drop-down (Filter field).
- Pick an operator in the second drop-down (Filter operator).
- Enter or choose a value (Filter value). Press
Enteror click Add filter.
The filter appears as a chip such as Status = overdue and the table updates. The list goes back to page 1.

- Add as many filters as you like. By default all of them must match.
- To match either of two filters, click the small and between their chips so it reads or. Chips joined by or form a group where any one may match; groups still have to match together. Example:
City = PuneorCity = Mumbai, andStatus = active. Click or again to switch back. - Click the small x on a chip to remove that filter.
- Click Clear all to remove every filter.
- If nothing matches the table says "No matching records".
Tip: Links from other apps can open a list already filtered, for example the overdue invoices on the Invoices & Payments overview. The filters show as chips. Remove them to see everything.
Operators by field type
| Field type | Operators | Value input |
|---|---|---|
string, text, email, url |
contains, =, ≠ | Text box. contains matches part of the text. |
select |
=, ≠ | Drop-down of the field's options |
number, currency |
=, ≠, >, ≥, <, ≤ | Text box with a number. For currency the filter compares the amount only. |
date, datetime |
=, >, ≥, <, ≤ | Date picker (a whole day) |
bool |
= | Yes or No |
ref (link to one record) |
is | Pick the record, for example one customer |
refs, multiselect (lists) |
includes | Pick one record or one option; a record matches when its list holds it |
Fields of type file are not in the Filter field list.
Fields your role hides do not appear in the Filter field list and cannot be sorted on.
Sort a list
Click a column heading to sort by it. Click again to reverse the order. Without a sort, the newest records come first. You can sort by any column shown in the list and by Created. To show other fields, use Columns — see Saved views and columns.
Keep a filter for next time
Save the filters, sort and columns you set as a view, so you or your team can pick them again from the view drop-down above the list. See Saved views and columns.
Pages
Lists show 50 records per page. Use the pager at the bottom to move between pages.
Search by typing
The list has no free-text search box. To find a word, use a contains filter on a text field. Link fields do search as you type, in their picker. See Links and line items.
Troubleshooting
Records could not be loaded Click Retry. If it keeps failing, a saved link may carry a filter on a field your role cannot read. Click Clear all.
The filter I need is missing Only the types in the table above can be filtered. For anything else, export to CSV or edit in Sheets.
Related
- Create and edit records
- Saved views and columns
- Export records exports exactly the filtered list