Filter records on Zapier Tables

You can filter most fields in your table to display only relevant records. The filtering options will depend on the type of field you are using.

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.

Permissions for filters

Only the owner of a table or users with the "Builder" role can edit and create filters. Learn more about permissions in Zapier Tables.

Filter records

1. In the sidebar, click the Filters  icon to open sidebar.
2. Click Add filter.
3. Click to expand the Field dropdown menu, then select the field to filter by.
4. Click to expand the Filter Options dropdown menu, then select the operation to perform.
5. Depending on the operation, enter a value in the Text field, or select an option from the dropdown menu.

Note

If you add multiple filters, the table will display only records that match all the filters, as it uses AND logic. 

Remove a filter

• Click the Remove filter icon.
• Remove all filters by clicking the Remove all button.

Filter rules

Each field type has different filter rules. In this table, you can see which fields would pass a given rule. 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
• Email
• Phone number
• Link (text)
• Link (link)

Note

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

Rules for the Date field type

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.