Help

Dependent Drop Down Lists / Limiting Lists

10817 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Ivan_Ke
4 - Data Explorer
4 - Data Explorer

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!

10 Replies 10

Hi Alivia,

Can you please describe your solution in more detail? It would be really much appreciated.