Filter rows in Baserow

Filters in Baserow transform overwhelming datasets into focused views, letting you find exactly what you need in seconds by hiding irrelevant rows and highlighting the data that matters to your current task.

This guide explains how to filter table data by field values using conditions, operators, and AND/OR logic to display only the rows that meet your criteria.

Overview

Filters refine your table views by displaying only rows that match specific conditions you define. Instead of scrolling through thousands of records, filters instantly show you relevant data based on field values, dates, text content, or numeric ranges.

Each view maintains its own independent filter configuration, allowing you to create specialized views for different purposes. You can apply simple single-condition filters for quick searches or combine multiple conditions with AND/OR logic to create sophisticated data queries without writing code.

Enterprise permissions note: In Enterprise plans, users with Editor role and lower can create personal filters in collaborative views that only they can see. These filters don’t affect other collaborators’ views.

For complex multi-condition filtering strategies, see our advanced filtering guide.

Multistep date filters image

When to use filters

Finding specific records: Quickly locate customers from a particular region, projects assigned to a specific team member, or invoices from last month.

Data analysis: Isolate high-value transactions, identify overdue tasks, or view only incomplete items to understand trends and patterns.

Workflow management: Display only rows requiring your attention, such as items awaiting approval or tasks due this week.

Reporting: Create filtered views showing data subsets for specific reports, presentations, or stakeholder updates.

Quality control: Identify records with missing information, duplicate entries, or values outside expected ranges.

Filter operators by field type

Different field types support different filter operators. Here are the most common operators:

Operator category Operators Works with
Text matching Is, Is not, Contains, Doesn’t contain, Contains word, Doesn’t contain word, Length is lower than, Is empty, Is not empty Text fields
Numeric comparison Higher than, Higher than or equal, Lower than, Lower than or equal, Is even and whole Number fields
Date filtering Is, Is not, Is before, Is on or before, Is after, Is on or after, Is within, Day of month is, Contains, Doesn’t contain, Is empty, Is not empty Date fields
Relationship Has, Doesn’t have, Contains, Doesn’t contain, Is empty, Is not empty Link to table fields
Boolean Is, Is empty, Is not empty Checkbox fields
Length Length is lower than, Length is higher than Text fields
Select Contains, Doesn’t contain, Contains word, Doesn’t contain word, Is, Is not, Is any of, Is none of, Is empty, Is not empty, Has any of, Doesn’t have any of Single and Multiple select fields

How to add a filter

Create filters by selecting a field, choosing an operator, and defining the value to match.

To add a filter:

  1. Click the Filter button in the view toolbar at the top-right of your table
  2. Click + Add Filter in the filter panel
  3. Select the field you want to filter by from the dropdown
  4. Choose a condition operator based on your needs (contains, equals, higher than, etc.)
  5. Enter the value to match (specific text, number, date, or status)

The table updates immediately to show only rows matching your filter. The filter panel shows how many rows match your criteria.

Adding a filter in Baserow

To remove a filter: Click the trash icon next to any filter in the filter panel to delete it and restore all rows to the view.

How to combine multiple filters

Apply multiple filters simultaneously using AND or OR logic to create precise data queries.

AND logic

AND logic displays rows that meet all filter conditions simultaneously. Use AND when you need records that satisfy every requirement.

Example: Show projects where Status = “In Progress” AND Priority = “High” AND Team = “Engineering”

This displays only engineering projects that are both in progress and high priority, rows must match all three conditions.

OR logic

OR logic displays rows that meet any of your filter conditions. Use OR when you need records that satisfy at least one requirement.

Example: Show projects where Status = “Blocked” OR Status = “At Risk” OR Status = “Overdue”

This displays projects in any of these three states, rows only need to match one condition.

To add multiple filter conditions:

  1. Add your first filter as described above
  2. Click Add Filter to add additional conditions
  3. Choose And or Or logic from the dropdown between filters
  4. Continue adding filters as needed

You can mix AND and OR logic within the same view by creating filter groups. Learn more in our advanced filtering guide.

Filter logic comparison

Logic type Behavior Best for Example
AND All conditions must be true Narrow, specific queries High-priority items assigned to you that are due this week
OR Any condition can be true Broader searches Items in “Draft” OR “Review” OR “Pending” status

How to enable or disable filters

Temporarily disable filters without deleting them to compare filtered and unfiltered views.

To disable all filters:

  1. Open the filter panel
  2. Click the toggle at the top of the filter panel
  3. All filters remain configured but stop applying to the view

To re-enable filters: Click the toggle again to restore all active filters.

Disabling filters doesn’t delete your filter configuration, it simply shows the unfiltered table temporarily. This is useful for verifying that your filters capture the correct data.

Footer aggregations (sum, average, count) automatically adjust to reflect only the visible filtered rows, helping you analyze your filtered dataset.

Frequently asked questions

Can I save different filter configurations for the same table?

Yes, create multiple views of the same table with different filter configurations. Each view maintains its own independent filters, allowing you to quickly switch between filtered perspectives on your data.

Do filters affect other users viewing the same table?

For collaborative views, yes, filter changes affect all users viewing that shared view. In Enterprise plans, Editor-level users can create personal filters visible only to them. To avoid affecting others, create a personal view with your own filters.

How many filters can I apply to a single view?

There’s no fixed limit on the number of filters per view. However, for performance and clarity, consider consolidating related conditions and keeping filter sets focused on your specific use case.

Can I filter by fields that are hidden in my view?

Yes, filters work on all table fields regardless of visibility. You can filter by hidden fields, and the results will display correctly even though the filtered field doesn’t appear as a column in your view.

Do filters work with formula fields?

Yes, you can filter by formula field results. The filter evaluates the calculated output of the formula, not the formula itself. This allows powerful filtering based on computed values.

What happens to filtered-out rows?

Filtered-out rows remain in your table; they’re simply hidden from view. Removing the filter or adjusting conditions immediately restores the rows. Filters never delete data; they only control visibility.

Related content

Still need help? If you’re looking for something else, please feel free to make recommendations or ask us questions; we’re ready to assist you.