Hi Support and Everyone,
I’m looking at creating dependent drop down lists and limiting the options for people to add other options, like how excel does it, but it seems I can’t do it in Airtable.
A/ Dependent Drop Down Lists
1/ Example of a dependent drop down list
A drop down list of Fruit => Select Apples => Drop down list = Granny Smith, Gala, Fuji, etc.
2/ Excel Way
Using the INDIRECT Function, we create lists with associated lists.
3/ Airtable Way?
Is there a simpler way to do this on air table?
B/ Limiting Drop Down Lists
1/ Example of a dependent drop down list
A drop down list of Fruit => Select Apples => Cannot add anything else in the drop down list
2/ Excel Way
Obviously this is a function that already is the weakness of excel, and the strength of Airtable, but I need to force other people to obey a few rules.
3/ Airtable Way?
Is there a way to do this on air table?
If you can offer any advice, that would be great. Thanks!