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.
Page 1 / 2
THIS. IS. AWESOME. :partying_face: :medal_military:
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!
Thanks - this will help to cut down on bloat and cruft.
This is GREAT!
Also, like your screen shot that displays the new layout for Data, Automations & Interfaces
This is a great release on the quality of life front!
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.
Loving the cadence of updates lately!
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.
This is a great release on the quality of life front!
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?
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.
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?
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.
Will “has all of” become a filteroption for other types of filters to?
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
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?
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?
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.
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.
@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?
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?
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.
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
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?
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.
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…
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!
This will be out very soon!
Hey, that’s exciting! Can’t wait to explore this.
This will be out very soon!
Tremendous news, thanks!
I have been waiting for this feature for…years…and years. FINALLY!!! :partying_face: