Filtering records using conditions

Prev Next
Plan AvailabilityAll plan types
Required permissionsOwner / Creator - Can add, delete, duplicate, rename, and customize fields
Platform(s)Web/Browser, Mac app, and Windows app (with some additional limited support on mobile)

Filtering in Airtable overview

Using filters in Airtable allows you to limit what collaborators can access, review, or edit.

  • Interfaces: Filters in interfaces allow builders to create a way for collaborators to interact with specific information that may only relate to individual teams, projects, or insights across visualizations on an interface page.

  • Views: View filters allow builders to filter out records from a view based on your conditions. When a record is filtered out based on a condition, it is not deleted—it's just hidden from the particular view you're using to look at your table.

  • Automations: Conditions in automations allow builder to apply logic so that the automation only runs or performs certain actions when particular conditions are met. The When record matches conditions trigger, conditional logic in groups of automation actions, and Find records action all leverage conditions to increase the precision of automation runs.

  • Forms: Visibility rules in forms allow builders to control when and whether form submitters can input information in form fields. One example of how to apply filters in forms is available here.

What is a condition and how can I use it in Airtable?

Conditions are rules that allow you to:

  • Records to be visible in a particular view or interface

  • Records to be found or watched in an automation run or for particular groups of automation actions to be run

  • Fields to be hidden in forms until some other field has been entered or entered in a particular way

Use conditions when you want to:

  • Find a record(s) that meet certain conditions quickly (e.g., records that have a due date after X date and before Y date).

  • Focus on records that meet certain conditions (e.g., the records that have been assigned to me AND have not been marked as completed).

  • Prevent collaborators from seeing certain records.

Conditions in Airtable

A condition reads much like a sentence. The example below reads: "Show me the records where the DRI is Jordan Peretz."

4409138365463singlecondition.png

  1. Field - Any field in your table. (The “DRI” field using the example above)

  2. Operator- After selecting a field, choose an operator from the pre-populated dropdown menu.

    • Which filter operators are available is determined by the field type. For example, text fields will have filter operators like "contains," "does not contain," "is empty," or "is not empty"; number fields will have filter operators like "is greater than" or "is less than."

    • Note that operators "is empty" and "is not empty" do not require you to input a value because the default value is empty.

    • Airtable also offers functionality that lets you filter by specific linked records by using filter operators such as "is exactly", "has any of", "has all of", or "has none of" along with a linked record field. This eliminates the need for complex string-matching filters.

  3. Value- This is the value you compare all of your records against using the field you specified earlier in the conditional statement.

Conjunctions in Airtable

Conjunctions are used to logically connect multiple conditions within filter groups, allowing you to create more complex and precise filtering rules. The two available conjunctions are "And" and "Or".

  • You can use "And" when you want all conditions in a group to be met.

  • Otherwise, you can use "Or" when you'd like any condition in a group to be met.

4409556140951stylizedconditiongroup.png

Using the “And” conjunction example:

In this example, will use the "And" conjunction to create a new condition group where records must meet all of our conditions. Let's get a little more complex with our rules: "We want to see all chairs with a unit cost of over $1,000".

We can break this down into two conditions:

  1. Where the "[Type] [is] [Chairs]", and

  2. The "[Unit cost] is [greater] than [$1,000]".

When adding a second condition, clicking the "Add Condition" button will add both a conjunction and a new condition to be filled in. The "And" conjunction is selected by default. Now we can add our second condition, and by using "And" as our conjunction, we ensure that all records must meet both conditions to be visible in the view.

Using the “Or” conjunction example

If you want any of your conditions to be met in a condition group, you can use the "Or" conjunction. In this example, we'll create a view where we want to see records either:

  1. Where the "[Type] [is] [Chairs]", or

  2. The "[Materials] [has any of] [Reclaimed wood]".

By clicking on the conjunction type, you can choose between "And" & "Or.”

Rearranging conditions

With the conditions menu open from any surface that supports filters, find the six-dot icon to the far right of the condition that you want to move. When hovering over that icon, you should see your cursor/mouse change to a hand. Click and drag the filtering condition to the appropriate ordering location of your choice. Keep in mind that conjunctions (And/Or) may be altered depending on how many conditions you have set or the position of the condition that you are moving.

Removing conditions

With the conditions menu open from any surface that supports filters, find and click the trash icon next to the condition or conditional group that you want to delete.

Using conditions outside of views in Airtable

Using conditions in interfaces:

  • Setting conditional filters for interface visualization layouts

  • Allowing users who have access to an interface visualization the ability to configure their own filters

  • Setting filters for dashboard layouts to gain specific insights into underlying data

  • Utilizing and configuring filter elements (Blank, Record Review, and Record summary layouts only) on interface pages

Conditions in automations:

  • Adding filters to automations allows you to prevent unexpected runs and only perform certain actions or groups of actions when conditions are met. This is important because narrowly-scoped automations are generally more trustworthy and will only update records when necessary.

Conditions in forms:

  • Hiding fields until other fields are entered

  • Limiting which form fields certain form submitters can see

  • Creating efficient form flows to save submitters time and ensure they only fill out absolutely necessary fields

Condition groups and advanced filtering

Nesting condition groups

Now let's expand on this concept of conditional filtering. You can use conjunctions to combine and connect condition groups nested within other condition groups.

Combining conditional groups allows you to start building more and more complex filters. For example, we can create a rule to “Show chairs, AND those chairs must be in stock OR show furniture made of reclaimed wood”:

4409564339479twoconditionalgroupssecondlevel.jpg

We strongly recommend playing with conditional groups as you read along. Advanced filtering is a feature with a delightfully mix-and-match feel that is best learned by doing.

Creating new condition groups

There are two ways to create a new condition group.

  1. The first way is from the first level condition group, by clicking on the Add condition group button. This will add an additional condition group nested within the first level condition group we’ve been using up to this point:4409564400407secondlevelnestedcondtiongroups.jpg

  2. The second way to create a new condition group is from within a second level nested condition group. Click the + button inside of the existing condition group and then click Add condition group. This will create a nested condition group on the third level. You can nest condition groups for a maximum depth of three levels:

    image.png

Some important things to note:

  • You cannot nest a group any deeper than the third level and the option to add a group will be grayed out

  • Though three levels are the maximum depth level possible, you can still achieve complex and precise filtering by combining conjunctions with multiple levels of condition groups:

    4409572792343multiplenestedconditiongroups.jpg

  • Each level of a condition group can have multiple conditions, but only a single conjunction. Meaning that each condition group can use either “And” or “Or,” but not both.

FAQs

Are there any special considerations to be aware of when changing filters in views?

Yes. When you change view filters we recommend turning off any automations that may be associated with the view that you are altering. This is because live changes to filters can often cause unintentional automation runs while you are modifying them.

Where are advanced/nested filters currently integrated within the product?

You can currently access advanced filtering within the view filtering menu, record coloring, conditional form fields, and interfaces. This functionality is not available in the Airtable Automations feature.

What if I try adding a condition to a nested condition group and make a mistake? Is there a way to revert to the original?

You can easily rearrange, add, or remove conditions from any of your condition groups. If you are in the process of building a new view and are playing around with filters, we recommend creating a duplicate view. Within your new duplicate view, you can change filtering without affecting any ongoing workflows or other collaborators.

What are the best practices for migrating my current filter configurations to advanced filter options?

Advanced filters will not change any of the filtering conditions you previously had set up in your views. However, you will be able to add new condition groups—the world is now your oyster!
Using our product example above, imagine a customer comes in asking for either a:

  1. A living room piece, OR alternatively,

  2. Something made of wood OR above a price point of $3,500 per unit AND is in stock now.

Advanced filters can help you quickly get to the data you need. Here is a visual for the scenario we just described:

4409573050007threelevelsofnestingnospotlight.jpg

Will I be able to copy view configurations that have advanced filters?

Yes, you can copy a configuration from one view to another within the same table. Either follow the procedure described in this article or click on the “Copy from another view” option at the bottom of the filter menu:

4409564814231copyfromanotherviewconditiongroups.png

This functionality does not exist across other areas of the product, just views. Additionally, there must be at least one other view in the table you are working from in order to see this option.

What is the maximum number of filter conditions per view?

There is a maximum of 49 filter conditions per view. This total is calculated by adding any standalone filter conditions, plus any filter conditions inside of filter condition groups.

What is the maximum number of nested conditional filter groups per view?

There is a maximum of 2 nested conditional filter groups. This means that there are 3 levels of filters possible:

  1. Standalone filter conditions

  2. A conditional filter group

  3. A conditional filter group inside of another conditional filter group

image.png