New Feature: Advanced Filtering

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 :clap:

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

Greeeaaattt ! :clap: :clap: :clap:

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? :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)

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 :pray:

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.

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 :raised_hands:

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.

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)