Hi everyone, I am new to Airtable and I have been stuck on this for a while now, basically what I need is:
A Products table for thousands of products
These products can be grouped into 10 main categories
There are a few dozen sub-categories under each main categories
What I would like to achieve is, each time when I am adding a new product record, I can select the main categories drop down menu, and after that only those sub-categories related to that main categories will show in the sub-category drop down menu
What you are referring to is dynamic variable conditions for linked record fields.
Airtable rolled out “Dynamic Variables” to their automation “Find Records”. It enables you to set a condition as dynamic.
IF this were to be rolled out to the the linked record field type, you could accomplish this.
This functionality would look through values in the destination table and filter the linked record options for only those records which match those conditions on the table being worked on.