Dependent Drop Down Lists / Limiting Lists


#1

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!


Dependent Columns w/ Relevant Answers
#2

I’m looking for this exact same feature!


#3

Same here. The usability of any database and form requires the user to establish relationships between cascading fields to ensure data validity. It seems every system like this stops at delivering this critical capability and thus limits the potential to build “anything” with data business rules. It would be really great to see Airtable take this on and revolutionize the market for complex form data entry without the need to develop and a traditional application. Great stuff here… Airtable is so close to answering the system of my dreams.


#4

Wondering if there’s a way for columns to appear/disappear or gray out depending on a column selection. For example:

Capture

I’m creating an inventory of fountain pens and inks. Some columns are specific to other answers. In this sample, the # of cartridges column is only relevant when “Cartridge” is selected under the Type column. Is there a way to gray it out or have it automatically display an answer?


#5

I think you can’t do that, but you could create a View filtering by Type, and and show/hide the # Cartriges field.