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 "Editor" 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.
miscEye icon 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)

 

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.

 

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)

 

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
  • 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

 

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.
Was this article helpful?
3 out of 5 found this helpful