Skip to main content

New Filter Options for Linked Records


Forum|alt.badge.img+4

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 replies

ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8772 replies
  • June 23, 2022

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


Kamille_Parks11
Forum|alt.badge.img+25

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!


Forum|alt.badge.img+9

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


Forum|alt.badge.img+14
  • Inspiring
  • 63 replies
  • June 23, 2022

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


Ben_Young1
Forum|alt.badge.img+20
  • Brainy
  • 520 replies
  • June 23, 2022

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.


Forum|alt.badge.img+15
  • Inspiring
  • 75 replies
  • June 23, 2022

Loving the cadence of updates lately!


Karlstens
Forum|alt.badge.img+20
  • Inspiring
  • 601 replies
  • June 23, 2022

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.


Forum|alt.badge.img+5
  • Participating Frequently
  • 9 replies
  • June 23, 2022
Ben_Young1 wrote:

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.


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


Hannah_Wiginton
Forum|alt.badge.img+18

This is great, Scott! Thank you!


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 3 replies
  • June 23, 2022
Ben_Young1 wrote:

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.


This has been fixed!


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8772 replies
  • June 23, 2022

@Scott_White and @Tim_Deng

Thank you for making linked records even more powerful in our bases! 😃 

And now for the big feature request that would take linked records to the highest level of all: Can you please give us dynamic linked record options based on the value in another field?

This is currently available in Fillout’s advanced forms for Airtable, but it is not natively available in Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), and so much more.

2025 Update: This feature is now available in Airtable, although it was implemented in a weak way, so it’s still more powerful in Fillout than it is in Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


Forum|alt.badge.img+18

Very nice, good work! :muscle: :raised_hands:


Databaser
Forum|alt.badge.img+19
  • Inspiring
  • 866 replies
  • June 24, 2022
ScottWorld wrote:

@Scott_White and @Tim_Deng

Thank you for making linked records even more powerful in our bases! 😃 

And now for the big feature request that would take linked records to the highest level of all: Can you please give us dynamic linked record options based on the value in another field?

This is currently available in Fillout’s advanced forms for Airtable, but it is not natively available in Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), and so much more.

2025 Update: This feature is now available in Airtable, although it was implemented in a weak way, so it’s still more powerful in Fillout than it is in Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


+1

For the new feature, I’ll just leave these here:

:partying_face: :partying_face: :partying_face: :partying_face: :partying_face: :partying_face: :partying_face:


Databaser
Forum|alt.badge.img+19
  • Inspiring
  • 866 replies
  • June 24, 2022

Will “has all of” become a filteroption for other types of filters to?


Forum|alt.badge.img+17

Airtable seem to be in overdrive at the moment. Some nice new features being released!

(Please let us add weekday to a date field soon though!)
Andrew


Forum|alt.badge.img+15
  • Inspiring
  • 75 replies
  • June 24, 2022

Was excited to apply this to a specific, messy workaround I’m using, before realising it doesn’t apply to linked records in a lookup. Possibility of implementing this in the future?


Karlstens
Forum|alt.badge.img+20
  • Inspiring
  • 601 replies
  • June 24, 2022
ScottWorld wrote:

@Scott_White and @Tim_Deng

Thank you for making linked records even more powerful in our bases! 😃 

And now for the big feature request that would take linked records to the highest level of all: Can you please give us dynamic linked record options based on the value in another field?

This is currently available in Fillout’s advanced forms for Airtable, but it is not natively available in Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), and so much more.

2025 Update: This feature is now available in Airtable, although it was implemented in a weak way, so it’s still more powerful in Fillout than it is in Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


Admittedly, this is exactly why I visited this thread, hoping that this workflow had now opened up to us.

From my poking about, this much needed feature of interdependent linked records is still lacking. :sleepy:

@Scott_White and @Tim_Deng regarding this excellent filter work - one thing that’s bugged me from time to time, is that an “empty” option is missing from “has any of” / “has none of”, as often I need to filter my terms along with empty records. Would it be possible to patch this into filters?


Forum|alt.badge.img+15
ScottWorld wrote:

@Scott_White and @Tim_Deng

Thank you for making linked records even more powerful in our bases! 😃 

And now for the big feature request that would take linked records to the highest level of all: Can you please give us dynamic linked record options based on the value in another field?

This is currently available in Fillout’s advanced forms for Airtable, but it is not natively available in Airtable.

Fillout is 100% free and offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachments), and so much more.

2025 Update: This feature is now available in Airtable, although it was implemented in a weak way, so it’s still more powerful in Fillout than it is in Airtable.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 


I moved to coda a few months ago because of this missing functionality. My first post to the community forum was this ask. After years of hawking the forum and scripted email responses, Airtable and I are beginning to part ways.

PS thanks for the warm community welcome @ScottWorld


ScottWorld
Forum|alt.badge.img+33
  • Brainy
  • 8772 replies
  • June 25, 2022
Allen_Moldovan wrote:

I moved to coda a few months ago because of this missing functionality. My first post to the community forum was this ask. After years of hawking the forum and scripted email responses, Airtable and I are beginning to part ways.

PS thanks for the warm community welcome @ScottWorld


How are you enjoying Coda?


Forum|alt.badge.img+15
ScottWorld wrote:

How are you enjoying Coda?


I don’t want to speak too much about it, I think it violates community policy.

I think airtable is great… it’s a lot more friendly out of the box… that said, I’ve reached its limits and my Java script sucks. Within one week of learning the coda language, I’ve managed to accomplish pretty much all things I wish existed in airtable.

Where airtable gets you 80 percent of the way there without scripting/external applications. I’ve found coda gets you 95 percent of the way there with a decent understanding of the formula language.

I think airtable is a better back end and has more third party Webb app/front end stuff like softr. That said, if I ever wanted a snappy scalable backend, I would go xano. For a front end I would go bubble.


Forum|alt.badge.img+18
Allen_Moldovan wrote:

I don’t want to speak too much about it, I think it violates community policy.

I think airtable is great… it’s a lot more friendly out of the box… that said, I’ve reached its limits and my Java script sucks. Within one week of learning the coda language, I’ve managed to accomplish pretty much all things I wish existed in airtable.

Where airtable gets you 80 percent of the way there without scripting/external applications. I’ve found coda gets you 95 percent of the way there with a decent understanding of the formula language.

I think airtable is a better back end and has more third party Webb app/front end stuff like softr. That said, if I ever wanted a snappy scalable backend, I would go xano. For a front end I would go bubble.


Btw, Airtable has not released their metadata API and doesn’t yet support oauth2 among other things. Therefore limiting their ability to become PREFERRED nocode backend.

But my company has been Airtable customer for 3 years and the change to other apps is quite difficult. I do hope that Airtable improve their updates and improvement cadence and more engagement in the forum just like…


Forum|alt.badge.img+5
  • Participating Frequently
  • 9 replies
  • June 28, 2022
Jack_Manuel wrote:

Was excited to apply this to a specific, messy workaround I’m using, before realising it doesn’t apply to linked records in a lookup. Possibility of implementing this in the future?


This will be out very soon!


Karlstens
Forum|alt.badge.img+20
  • Inspiring
  • 601 replies
  • June 28, 2022
Tim_Deng wrote:

This will be out very soon!


Hey, that’s exciting! Can’t wait to explore this.


Forum|alt.badge.img+15
  • Inspiring
  • 75 replies
  • June 28, 2022
Tim_Deng wrote:

This will be out very soon!


Tremendous news, thanks!


Forum|alt.badge.img+14

I have been waiting for this feature for…years…and years. FINALLY!!! :partying_face:


Reply