You can filter most fields in your table to display only records that match a specific rule. Filtering options depend on the type of field you are using.
Permissions
Only the owner of a table or users with the "Editor" role can edit and create filters. Learn more about permissions in Zapier Tables.
Filter records
To filter records, you must select a field to filter by, a filter rule, and the value the filter will evaluate for. After you filter, your table will only show records that match your filter value.
- Click the Filter icon.
- On the dialog box, click Add filter.
- Click the first dropdown menu and select the field to filter by. Other fields will appear depending on the field type.
- Click the next dropdown menu to select the rule the filter will use to evaluate the field value.
- Depending on the operation, a text field will appear. Enter a value in the field, or select an option from the dropdown menu.
- Click Apply filters.
Filter icon.When you filter a table, the number of filters in use will appear at the top of the table.
Note- If you add multiple filters, the table will display only records that match all the filters.
- If you create a filter in a view, it will only affect records in that view. Learn more about views in Zapier Tables.
Remove filters
- Click the Filter icon.
- Click the Remove filter icon beside the filter you want to remove.
beside the filter you want to remove.Remove all filters
You can remove all filters by clicking the icon that appears beside the number of filters on the table.
icon that appears beside the number of filters on the table.
Filter rules
Each field type offers different filter rules. In the tables below you can see examples of how each rule works. In each example, you will see:
- Rule: the filter rule we’ve set.
- Value: what we’re checking against.
- Examples: the content in a cell and what would be filtered and not filtered.
Rules for text-based fields
These rules apply to the following field types:
- Text
- Dropdown
- Phone number
- Link (text)
- Link (link)
- Linked Record
| Rule | Value | Example that would be displayed | Example that wouldn't be displayed |
| Is exactly | Apples | Apples |
|
| Contains (case-sensitive) | Apples and bananas | Apples and bananas | apples and bananas (not uppercase) |
| Contains | Apples and bananas |
|
Strawberries and apples |
| Is one of |
|
|
|
| Is empty | Only accepts True (field is empty) or False (field is not empty) | ||
| Starts with | App |
|
|
Filters for the Dropdown field can only use existing values.
Rules for number-based fields
These rules apply to the following field types:
- Number
- Currency
| Rule | Value | Example that would be displayed | Example that wouldn't be displayed |
| Is exactly | 100 | 100 | 150 |
| Is greater than or equal to | 100 |
|
99 |
| Is greater than | 100 |
|
|
| Is less than or equal to | 200 |
|
205 |
| Is less than | 200 |
|
|
| Is between |
|
|
|
| Is one of |
|
3000 |
|
| Is empty | Only accepts True (field is empty) or False (field is not empty) | ||
Rules for the Date field type
| Rule | Value | Example that would be displayed | Example that would be filtered |
| Is exactly | 12/31/2022 1:00 | 12/31/2022 1:00 |
|
| Is on or after | 12/31/2022 1:00 |
|
12/30/2017 |
| Is after | 12/31/2018 1:00 |
|
12/31/2017 |
| Is empty | Only accepts True (field is empty) or False (field is not empty) | ||
| Is before | 12/31/2022 3:00 |
|
12/31/2022 1:00 |
| Is on or before | 12/31/2022 1:00 |
|
01/01/2023 |
| Is between |
|
|
08/28/2022 |
Rule for the Checkbox field type
The Checkbox field only accepts True or False as a filter:
- True: checkbox is selected.
- False: checkbox is not selected.
Fields that cannot be filtered
You cannot use filters with these field types:
- Dropdown fields that use another table as a source.
- Button fields.
- JSON fields.
- AI Fields.