Advanced filtering by a field

Advanced filtering allows you to create and combine condition groups to precisely display the rows that match your specific criteria.

In this article, we will cover how to create condition groups within the filtering, row coloring, and conditional form fields.

Baserow advanced filtering

Understanding condition groups

A condition group is a combination of conditions connected using “AND” or “OR” logic, enabling you to build complex filters tailored to your exact needs.

AND Logic: When conditions are combined with “AND” logic, all conditions within the group must be met for a row to be displayed. This results in a stricter filter. For instance, you could create a rule to “Show tasks that are in progress AND have a high priority”. In this case, only tasks meeting both criteria will be displayed.

OR Logic: When conditions are combined with “OR” logic, a row will be displayed if any of the conditions within the group are met. This allows for a more permissive filter. For example, you could set a rule to “Show tasks where the release date is within this month OR have a high priority”. In this scenario, tasks meeting either of these criteria will be displayed.

Create a condition group

To create a condition group,

  1. Open a table in Baserow and navigate to the filtering options.

  2. Add conditions to the filter. These conditions represent the criteria that rows must meet. For example, add conditions like “Priority is High” or “Release Date is within this month.”

  3. Create multiple condition groups with “AND” or “OR” logic. For example, set a rule to “Show tasks that are in progress, AND have a high priority, OR show tasks where the release date is within this month”.

    • “AND” logic: Rows must meet all conditions within the group.
    • “OR” logic: Rows must meet at least one condition within the group.

  4. After setting up the condition groups, apply the filter. Baserow will display only the rows that meet your specified criteria.

Using advanced filtering

Filtering: Advanced filtering can be used within the standard row filtering, which allows you to filter data based on the specified conditions.

Row coloring: Apply advanced filters to determine the color of rows based on the conditions you define. This helps visually distinguish between different subsets of data.

Conditional form fields: This allows you to dynamically adjust form fields based on the conditions.

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.

   Ask the Baserow community

   Contact support for questions about Baserow or help with your account.