Filters

Filters limit the records shown in a database view. They affect only your view and do not change what other users see.

Filters are in the toolbar of each database.

Search records

Enter text in the search box at the left of the toolbar, or press / to focus it. Blue shows the records whose name contains the text. Search does not check upper or lower case or accents.

Use quick filter fields

A database can show up to three fields as quick filters to the left of Filters. Select a field button to add conditions for that field only. A field button with an active condition has a blue border.

To choose the quick filter fields, open Settings > Databases > Toolbar and select fields under Quick filter fields. The setting applies to that database only.

Add advanced filters

Use advanced filters to match the fields of the database.

1. Select Filters in the toolbar.
2. Select a field.
3. Select an operator, such as Is equal to, Is any of, Contains, or Is empty.
4. Enter or select the comparison value. Blue updates the records shown in the view.

You can filter these field types: Text, Email, Phone, URL, Number, Percent, Rating, Currency, Currency conversion, Checkbox, Date, Country, Location, Select (single), Select (multi), Assignee, Reference, Referenced By, Lookup, Rollup, and File.

Use relative date filters

Relative date filters move with the calendar. For example, This month always means the current calendar month when Blue loads records. It does not keep the month in which you created the filter.

Date fields support these calendar periods:

• This, Last, or Next day, week, month, quarter, or year
• In the last or In the next number of days, weeks, months, quarters, or years

Blue uses your timezone for interactive filters. This week also uses your selected first day of the week.

These filters work with Date fields and Lookup fields that return a date. A Date field with a start and an end date matches when its date span overlaps the selected period.

Select a specific date or custom range when the filter must remain fixed.

Combine conditions and groups

Use AND when all conditions must match. Use OR when any condition can match.

Select Add group to create another top-level group with its own AND or OR setting. You can also select AND or OR between groups. For example:

Status is Open AND (Assignee is Me OR Tags contains Urgent)

Filter groups are siblings. You cannot create a group inside another group.

Filter linked records

Advanced filters support Reference fields and Lookup fields:

• For a Reference field, select one or more linked records as the comparison value.
• For a Lookup field, filter the value that the field returns. Available operators depend on the field type of that value.

For example, to filter records by the tier of a linked customer, first create a Lookup field that returns the customer tier. Then filter that Lookup field for Enterprise.

Filter persistence

Filters stay active when you switch between Board, Table, Calendar, and Timeline in the same database. The Map view shows all records that have a location.

To reuse a filter configuration, create a saved view.