Skip to main content

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:


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


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!


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


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


Greeeaaattt ! 👏 👏 👏


You rock !


Don’t stop this now !


olπ


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



  1. This is excellent.

  2. When’s it coming to automations…? :winking_face:


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


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? 🙏 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.


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? 🙏 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.


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


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:


Airtable has neglected the mobile experience for years, which makes no sense since the vast majority of people use mobile devices to access the Internet.


People have been begging Airtable to fix this particular problem for ages, but Airtable ignores most user requests.


Will the experience of filters and searches be introduced in mobile or not?


People need this function urgently.


Please don’t give us a default answer.


Airtable has neglected the mobile experience for years, which makes no sense since the vast majority of people use mobile devices to access the Internet.


People have been begging Airtable to fix this particular problem for ages, but Airtable ignores most user requests.


Will the experience of filters and searches be introduced in mobile or not?


People need this function urgently.


Please don’t give us a default answer.


Hi @DIGINAUTAS,


Welcome to the community! You can find our guidelines and FAQ’s here.


The advanced filtering feature is slowly being rolled out on mobile. Our apologies that it isn’t available to all users just yet, but you can expect that this feature will be fully supported on both iOS and Android apps at some point down the road. Our support article on mobile filtering calls this out.


Hope this information helps you have confidence that we are listening and have a core group of folks who are always working to improve the mobile experience.


Hi @DIGINAUTAS,


Welcome to the community! You can find our guidelines and FAQ’s here.


The advanced filtering feature is slowly being rolled out on mobile. Our apologies that it isn’t available to all users just yet, but you can expect that this feature will be fully supported on both iOS and Android apps at some point down the road. Our support article on mobile filtering calls this out.


Hope this information helps you have confidence that we are listening and have a core group of folks who are always working to improve the mobile experience.


Hi @Adam_Minich


Airtable Community has been given a new lease on life since the arrival of @Jordan_Scott1 , @Aron , more recently @Albrey_Bristo-Brown and their Contributors like @Rose_K and you!

No Community Members are not left behind by the staff and today even less than ever.

Airtable Support recently helped me a big lot too !

It’s a good idea I think to have a layer of staff between the Developers and us because while I had a lot of interest in talking directly with one and then the other Developer at the launch of Scripting App on February 20, 2020 and during the following months, I don’t feel it’s the best idea to take them away from their ongoing development to converse directly with us.

But having an interface between them and us seems very beneficial: I have never discovered as many new features that improve my airtable workflow as I have recently.

I also regret not being able to use Airtable as an Author/Creator from my Mobile, but I prefer that the deeper layers of the product continue to evolve as quickly and as relevantly.


oLπ


Thank you! I reworked our workflow with this new feature in several areas. This greatly improved our productivity.


pleasee give us relative filters for dates and logged in users 🙌


if date = Today, week, month, year, yesterday etc

if colaborator = logged in user


pleasee give us relative filters for dates and logged in users 🙌


if date = Today, week, month, year, yesterday etc

if colaborator = logged in user


I hope that doing regular basic filtering of XYZ for example is not this complicated. And that this complexity is only for combinatorial type of filters


This is great functionality, except for one detail: the logic of “and” and “or” is sometimes reversed in a very bizarre way.


In the provided example of the customer looking for one of two options, the nested condition should be “and” based on what the customer is looking for (must be wood AND must be above $3,500 AND must be in stock). I’m really struggling to wrap my head around this.


pleasee give us relative filters for dates and logged in users 🙌


if date = Today, week, month, year, yesterday etc

if colaborator = logged in user


100% this. Filters needed (that aren’t relative to Today() but rather the active month/year),



  • This Month

  • This Year

  • Last Month

  • Last Year

  • Next Month

  • Next Year


Icing on the cake would be;



  • (number of) months ago (relative to the active month)

  • (number of) years ago (relative to the active year)


And being able to filter/select/inverse select in between the two.


These would save me having to add extra formula fields in all of my bases that need these filters (that I honestly believe should be a given in such a product as Airtable)


Reply