Help

New Filter Options for Linked Records

cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_White
6 - Interface Innovator
6 - Interface Innovator

468bfe35153405ee4319e07edce530798f908ecc.jpeg

As we all know, linked records are a big part of what makes Airtable special. At the same time, we know they haven’t always been the easiest to use in the context of filters. Well, we have a new feature that’s been a long time coming!

Starting today, you have the option to choose specific linked records within your filters. You have access to 4 new operators:

  • “has any of…,”
  • “has all of…,”
  • “is exactly…,”
  • “has none of…“

These new operators are also available within automations when you create a conditional trigger, as well as in interface designer (in both dynamic filter elements & statically in the properties panel for an element that accepts a filter, such as grid, timeline, etc).

These updates are available for customers on all plan types and should be available later today, if you are not seeing these changes reflected, please try clearing your cache.

40 Comments
ScottWorld
18 - Pluto
18 - Pluto

THIS. IS. AWESOME. :partying_face: :sparkles: :tada: :raised_hands: :medal_military:

Kamille_Parks
16 - Uranus
16 - Uranus

Just did a test to confirm that making these selections ties to the record’s ID, not its name. That means you no longer have to worry about renaming a record and accidentally breaking your filters. Nice!

David_Smedberg
6 - Interface Innovator
6 - Interface Innovator

Thanks - this will help to cut down on bloat and cruft.

RnJ
8 - Airtable Astronomer
8 - Airtable Astronomer

This is GREAT! :tada:
Also, like your screen shot that displays the new layout for Data, Automations & Interfaces :slightly_smiling_face:

Ben_Young1
11 - Venus
11 - Venus

This is a great release on the quality of life front!
Kudos to the product team!


I did notice a few things @Scott_White.

If you are looking at another user’s personal view, you have the ability to add new linked records to the filter.
You are unable to remove any of the linked record filter conditions even if you are the user that added them.

Jack_Manuel
7 - App Architect
7 - App Architect

Loving the cadence of updates lately!

Karlstens
11 - Venus
11 - Venus

I’m wondering if this gives the ability to have field dependent selections available? Perhaps it brings us a step closer via a Script, I think it might be possible.

Very keen to read of how the community will utilise these improved linked field filters within their workflows.

Tim_Deng
Airtable Employee
Airtable Employee

Thanks for the bug report, @Ben.Young! Just fixed the personal & locked views problem :grinning_face_with_smiling_eyes:

Hannah_Wiginton
10 - Mercury
10 - Mercury

This is great, Scott! Thank you!

Scott_White
6 - Interface Innovator
6 - Interface Innovator

This has been fixed!