Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Hmmm… this still works for me. Does the original linked record field still exist in your table?

Rebecca_Elam
9 - Sun
9 - Sun

Screen Shot 2022-07-11 at 10.46.45 AM

ScottWorld
18 - Pluto
18 - Pluto

OMG! Lol. Luckily, I’m not seeing that on my end. I would definitely contact support@airtable.com.

Rebecca_Elam
9 - Sun
9 - Sun

ok i still think all those things about everyone using a different version of the product but also… that was a lookup field not a linked record field. i was working very fast. so I’m sorry for yelling before I did all the investigation. lol I see now I just got a sneak peek at future filtering potential.

ScottWorld
18 - Pluto
18 - Pluto

This is very exciting that this is coming soon for lookup fields! :grinning_face_with_big_eyes:

Karlstens
10 - Mercury
10 - Mercury

Wait, what? Am I reading that correctly? Filtered look up fields? :eyes:

Scott_White
6 - Interface Innovator
6 - Interface Innovator

Very timely discussion! New filter options for lookup fields are rolling out today!

Databaser
11 - Venus
11 - Venus

Is it correct to expect that “is” as a filter only shows records whose field exactly matches the filer input?

eg:

image

“artikel 2, artikel 3”

  • is artikel 2” shouldn’t give any result

  • contains artikel 2” should give a result

ScottWorld
18 - Pluto
18 - Pluto

Hmmm… my filtering choices for linked record fields & lookup fields says “is exactly” (not “is”), and it works as expected.

Databaser
11 - Venus
11 - Venus

Aha. I’ll give it some more time then :slightly_smiling_face: