Mailed support and didnt get a reply. So Im trying here instead.
I understand one can have a conditional dropdown that adds all the values from a linked table. But what if I want to select between the values?
Lets say I have TABs called “Company” “Office” and “Employee”. Now I would want to add an Office to an employee - but only the offices linked to a specific company. How would one do that? Im guessing using IF statements - but would it work for string values?
You could limit your linked record field to a filtered view(company specific). A far more dynamic option would be this missing feature
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 the conditions.