New Feature: Advanced Filtering

Showing results for 
Search instead for 
Did you mean: 
Airtable Alumni (Retired)

We are excited to announce that as of today, advanced filters are available in Airtable!

What are advanced filters?

Advanced filters allow Airtable users to reflect both ‘AND’ and “OR” conditions in a single filter configuration. This provides more flexibility and customizability to filter the information in your views.

You can get started with advanced filters today, we can’t wait to hear what you think!

Related resources:

Common questions:

Where are advanced filters currently integrated within the Product?

You can currently access advanced filtering in many areas where filtering is available within the product:

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

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

What are best practices in 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, above a price point of $3,500 per unit, that 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:


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

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


7 - App Architect
7 - App Architect

Super cool! That’s another one off the list :grinning_face_with_big_eyes:

11 - Venus
11 - Venus

Whoa, what’s this?! :partying_face: OMG, THIS IS LIKE CHRISTMAS :partying_face: (except that I’m an adult and not 5 years old) Amazing! Thank you!

13 - Mars
13 - Mars

¡Finally! I can now stop creating “ghost formulas” just to filter two OR conditions :clap:

PD: Every time I saw that Notion had this, I was confussed :grinning_face_with_sweat:

9 - Sun
9 - Sun

Greeeaaattt ! :clap: :clap: :clap:

You rock !

Don’t stop this now !


6 - Interface Innovator
6 - Interface Innovator

This is incredibly fantastic news! Thank you for addressing one of the most frustrating issues with Airtable usability!!

6 - Interface Innovator
6 - Interface Innovator
  1. This is excellent.
  2. When’s it coming to automations…? :winking_face:
6 - Interface Innovator
6 - Interface Innovator

Ok, this is perfect, great job you guys! I love, love, LOVE conditional logic. It makes everything better :smiling_face_with_three_hearts:

10 - Mercury
10 - Mercury

This is really cool! I do love it - Just wanted to flag a few issues I have found while using it across different clients.

The main issue that I am coming up against is that field names and values are being cropped significantly, which make them hard to set-up, and read. Would there be any chance of fixing this pleeeeeeease? :pray: It’s reduced the usability significantly for me, as I really like to see what I’m doing. when I’m doing it.

(Edit - A halfway option would be to put the field type icon in the view - At least that way you don’t need to go into the field name to see what you are filtering by - But to remove that, and make the field name opaque has basically left me pretty frustrated this past week)

saastronomical-screenshot 2021-10-13 at 21.53.21.png

The second issue, which I’m sure you’re aware of is that if a field is part of a filter, and you change the field type, it breaks the whole base, and crashes Airtable.

Airtable Alumni (Retired)

@andywingrave the team is going to follow up with you directly to get more information! Thank you for flagging :pray:

4 - Data Explorer
4 - Data Explorer

Super cool. This is very helpful!

Lots of +1s on this Dynamic filter based on collaborator field ("Me" view) - #37 by Ian_G @Jordan_Scott1

Anything in your roadmap for any Adavnced Filtering based on the collaborator? :crossed_fingers: :crossed_fingers: :crossed_fingers: