Hi everyone, I’m Carla – a software engineer at Airtable and I am really happy to share that we’ve added the ability to dynamically filter results in linked record pickers! You can now limit the records that can be selected on a linked record field by configuring a filter based on the value from another field from the same record.
For example, when assigning People to a Task, instead of browsing through the full table of People, you can now filter the linked records available for selection based on another field on the Tasks table, in this case we can use the value of the Skills Required field to filter the list of People to only those that have the relevant Skills:
How to configure
- On a linked record field configuration, toggle on the option to Filter record selection by a condition.
- Select a linked record field from the linked table and click the cog on the right to switch to a Dynamic condition.
- Select a linked record field from the current table, and Save.
We’re rolling this update out over the course of this and next week; if you don’t see it reflected in your base just yet, hold tight, you will get the update very soon! This feature is available for Teams, Business, and Enterprise Scale plans.
Check out this Help Center article for more details and instructions on how to configure dynamic filters on your base.
Let us know your feedback in the comments!
14 Comments
