- 12 Apr 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
Dynamic filtering in linked record fields
- Updated on 12 Apr 2024
- 3 Minutes to read
- Print
- DarkLight
- PDF
NOTE
We’re rolling out dynamic filtering in linked records throughout the weeks of 3/10 and 3/17. Thanks for your patience while we finish making it available to everyone on Team, Business, and Enterprise Scale plans.
Team, Business, and Enterprise Scale plans | |
| |
Platform(s) | Web/Browser, Mac app, and Windows app, iOS and Android apps*
|
Related reading | |
|
Dynamic filtering in linked record fields overview
Dynamic filtering in linked records supports static filtering on any field type and dynamic filtering on text, number, user, and linked record field types.
Fig 1.
In this configuration, the filter narrows down employee records—only detailing those individuals with the required skill(s).
Fig 2.
"Design" as the "Skill required " is selected in this configuration.
Using dynamic filtering in linked record fields
NOTE
Dynamic filtering in linked records supports static filtering on any field type and dynamic filtering on text, number, user, and linked record field types.
Supported column types include: text-based columns (single line text, phone, email, long text), number-based columns (number, rating, count, currency, percent, duration) checkbox, collaborations, and computer fields.
To use static and dynamic conditions in linked records:
NOTE
Filters can be stacked on top of each other— allowing you to use both static and dynamic filters simultaneously.
Visit your Airtable homepage.
Open your preferred base.
Locate your linked record field and click the ⌄ icon.
Select Edit field.
Toggle on Filter record selection by a condition.
Click Add condition.
Click the ⚙️ icon and select Static condition or Dynamic condition.
Using dynamic conditioning in text, number, user, and linked records
Dynamic conditioning in text, number, user, and linked records
The left and right operands must be the same field type, as dynamic filters don't support comparing different types. For example, comparing text fields to linked records, number fields to the text fields, etc., isn't supported.
Example: Dynamic conditioning in text, number, user, and linked records
In the example below, the "People" linked record field is filtered by the "Skills" linked record on the "People" table and the "Skills required" linked record on the "Task" table.
Filters can be applied anywhere in bases and interfaces where linked records can be selected.
Dynamic filtering in linked records limitations
The following features are limited when applying dynamic filtering in linked records:
Cross-field type comparison within individual filters
NOTE
Dynamic filtering in linked records doesn't support cross-field type comparison within individual filters.
Example: “Where <User field> has any of <Text field>”
The user field and text field are of different field types, so they cannot be compared using dynamic filtering.
Single select or multi-select fields
NOTE
Dynamic filtering in linked records doesn't support single select or multi-select fields.
Example:"Where <Select Field> is <Other Select Field>"
Select fields cannot be compared using dynamic filtering, but you could convert the select fields to linked record fields or convert them to text fields to be able to compare them using dynamic filtering.
Dynamic filters in forms
NOTE
Dynamic filters on computed fields in forms: Dynamic filters in which the column selected as the right operand is a computed field.
Example: Lookup or count fields are not applied to linked record selections within forms in interfaces and bases.
FAQs
What happens after downgrading a workspace to a Free plan?
After downgrading a workspace to a Free plan, dynamic filtering will continue working, but any applied filters cannot be modified.
Does dynamic filtering in linked records hide records that are already linked?
No, dynamic filtering only affects the selection of new records that can be linked in that specific view. It does not hide or alter the visibility of records that have already been linked or those records that will be linked in other views in the table moving forward. This means that:
Any records linked prior to the application of a dynamic filter will remain visible, regardless of whether they meet the filter criteria.
Any records linked in other views that do not have dynamic filtering will be visible in views that do have dynamic filtering conditions.