Filter records on Zapier Tables

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.

1. Click the Filter icon.
2. On the dialog box, click Add filter.
3. Click the first dropdown menu and select the field you want to filter by. Depending on the field type, other fields will appear.
4. Click the next dropdown menu to select the rule the filter will use to evaluate the field value.
5. Depending on the operation, a text field will appear.  Enter a value in the field, or select an option from the dropdown menu.
6. Click Apply filters.

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

1. Click the Filter icon.
2. Click the Remove filter icon 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.

Filter rules

Each field type offers different filter rules. The section below contains examples of how each rule works. Click the header for each field type to see its rules. In each example, you will see:

• Rule: the filter rule's name.
• Value: the value to be checked against the rule.
• Examples: the content in a cell and what would be filtered and not filtered. 

Text-based fields

Rules for text-based fields

These rules apply to the following field types:

• Text
• Dropdown
• Email
• Phone number
• Link (text)
• Link (link)
• Linked Record
• AI Field

Rule	Value	Example that would be displayed	Example that wouldn't be displayed
Is exactly	Apples	Apples	Apple (not plural)  apple (not uppercase)
Contains (case-sensitive)	Apples and bananas	Apples and bananas	apples and bananas (not uppercase)
Contains	Apples and bananas	Apples and bananas apples and bananas	Strawberries and apples
Is one of	Apples Bananas	Apples Bananas	Apples and bananas Bananas and strawberries
Is empty	Only accepts True (field is empty) or False (field is not empty)
Starts with	App	Apples Applesauce	Apricots Bananas

 

Note

Filters for the Dropdown field can only use existing values.

Number-based fields

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	100 150	99
Is greater than	100	120 101	100 99
Is less than or equal to	200	200 199	205
Is less than	200	199 150	200 220
Is between	100 200	120 135	95 215
Is one of	150 3000 80	3000	200 100
Is empty	Only accepts True (field is empty) or False (field is not empty)

Date field

Rules for Date fields

Rule	Value	Example that would be displayed	Example that would be filtered
Is exactly	12/31/2022 1:00	12/31/2022 1:00	12/31/2019  12/31/2018 00:00
Is on or after	12/31/2022 1:00	12/31/2022 1:00 12/31/2022 01:01	12/30/2017
Is after	12/31/2018 1:00	01/01/2019 12/31/2018 01:01	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 03/01/2016	12/31/2022 1:00
Is on or before	12/31/2022 1:00	12/31/2020 3:00 03/01/2016	01/01/2023
Is between	08/19/2022 08/25/2022	08/21/2022 08/23/2022	08/28/2022
Is within	Select an option from the time range dropdown menu

 

Dynamic date filters

If you select the rule "is within" to filter a Date field, instead of adding a specific date, you'll select from a dropdown menu of time ranges, such as "Last 7 days",  "This calendar year", or "Next 365 days". 

Note

• When you select options related to weekly ranges, such as "This past week" or "This calendar week," the week will always start on a Monday and end on a Sunday.
• For "Last 7 days" and other options related to a number of days, the date range will include the current day.

 

Checkbox field 

Rule for the Checkbox field 

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.