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!

9 Likes
Dependent Columns w/ Relevant Answers
#2

I’m looking for this exact same feature!

1 Like
#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.

2 Likes
#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.

#6

Been trying to figure this out myself. For a “database” tool, this should be a no brainer. I recommended Airtable in to a few friends, and this is a deal breaker. I can do it in Excel with some scripting, but trying to avoid this.

1 Like
#7

I have the same problem. I don’t know why there isn’t some way to do this. Hierarchical classification is a generic requirement.
I have to classify organisations by the RFCD (Research Field Course Discipline) schema. The unique field is a Subject Code. That is the value that has to go in the name (uniquely identifying), and shown as the linked attribute value. But there are hundreds. So they are grouped into disciplines, which are then grouped into Divisions. The user should be able to select a Division, then select the Disciplines in that Division then select the Subject in that Discipline.
Airtable seems to require that I hard code just one grouping/filter - which is useless.
Going the other way is not better. Even though I can group the RFCD codes usefully with expand-contract arrows, I would then have to give the user hundreds of organisations to choose from.

I am at a loss.

1 Like