Skip to main content

Filter views

Narrow down the records of a view with filters, combine several filters with And, and find a record with search.

Written by Leo

A filter keeps only the records that match a condition, such as "Status is In progress". Filters are meant to help you focus on the records you need right now without changing the data.

You can use filters for many things, including:

  • Showing only the tasks assigned to you.

  • Listing properties that were added in the past month.

The filter menu with two filters, the first starting with Where and the second with And, and the Add filter button

Note:

  • Filters only hide records in the view. Nothing is deleted.

  • A changed filter stays unsaved until you save the view. The view shows Unsaved view. Learn more about saving views →

  • You can only filter by fields you can see. A saved filter on a field you have no access to shows No access, still applies, and can only be removed.

Who can filter views?

  • Filters and search are available on all plans: Free, Plus, and Premium.

  • Everyone who can open a view can filter it for themselves. To save a filter into a team view, you need Full access or Can share. Learn more about creating and managing views →

Add a filter

  1. Open a view and select the filter button in the toolbar (its tooltip reads Filter).

  2. Choose a field. Type under Search for a field… to find it.

  3. Choose how to compare, for example Is or Contains.

  4. Enter or choose a value.

Selecting Filter, choosing the field Investment stage, and choosing the value Renovation

The Filter button shows how many filters are active and how many of all records match, for example "1 filter / 12 of 48".

Comparisons by field type

The comparisons depend on the field:

  • Text fields: Is, Is not, Contains, Does not contain, Starts with, Ends with, Is empty, and Is not empty.

  • Single select, single relation, and single member fields: Is, Is not, Is any of, Is none of, Is empty, and Is not empty.

  • Multiple select, relation, and member fields that allow more than one value: Is any of, Has all of, Is exactly, Has none of, Is empty, and Is not empty.

  • Status fields: Is, Is not, Is any of, Is none of, Is completed, Is incomplete, Is empty, and Is not empty.

  • Number fields: =, ≠, <, >, ≤, ≥, Is empty, and Is not empty.

  • Date fields: Is, Is not, Is within, Is before, Is on or before, Is after, Is on or after, Day of week, Month of year, Quarter of year, Is empty, and Is not empty. As the value, choose Specific date, Specific date range, or a relative date such as Current date, The current week, The next number of days, or Number of days ago.

The comparisons of a single select field: Is, Is not, Is any of, Is none of, Is empty, and Is not empty

Filter by yourself

For member fields, choose Myself under the dynamic values. It changes according to the person who is looking at the view, so everyone sees their own records in a team view.

The value list of a member filter with Myself under Dynamic and the members of the app

Combine filters

Add more filters with Add filter in the filter menu. Tape adds a row with the field of the last filter. Select the field name to choose another one. The first filter starts with Where, every further filter with And. A record shows in the view only if it matches all filters.

In a view, you can't combine filters with Or or build filter groups. To see records that match one of several values of the same field, use a comparison such as Is any of.

Two filters in the filter menu, the second one starting with And

Remove a filter

Click the remove icon next to a filter, or click the icon with the tooltip Clear filter on the filter button to remove all of them.

A filtered table view with 1 filter / 2 of 8 on the Filter button and the icon to clear the filter next to it

Search in a view

Click the search icon in the toolbar (its tooltip reads Search) and type under Type to search…. Tape shows the records of the view that match. Click the icon with the tooltip Clear search to see all records again.

Selecting Search in the toolbar and typing Duplex, which shows the two matching records

New records in a filtered view

When you create a record in a view that has filters, Tape can fill in values from the filters, so that the new record doesn't disappear from the view right away. Learn more about creating a record →

FAQs

Can I filter by more than one field?

Yes. Add as many filters as you need with Add filter. A record has to match all of them to show in the view.

Can I filter by the current date?

Yes. For date fields, choose a relative date such as Current date, Tomorrow, or The past week instead of a fixed day.

Does a filter stay when I leave the view?

Only if you save it. Select Save to keep the filter in the view.

Why can't I filter by a certain field?

Fields you have no access to aren't offered. Learn more about field access →

Is there a filter on the board view?

Yes. The board toolbar has Filter and Search like the other views. Learn more about the board view →

Where can I find an overview of views?

In Views, filters, sorts & groups →. It explains Table, Board, and List layouts, team and private views, and how filters, sorts, and groups fit in.

Still have more questions? Find answers and get help from community experts in the Tape community →.

Did this answer your question?