Dynamic Drop down dependent on another dropdown

[Paul_La_Vigna]

Helllo,
New to the Airtable platform.
I am wondering if this is possible.

I am developing a manufacturing schedule and in the schedule you have a Phase and multiple (different) steps in each phase.

Ideally I would like a (2) drop-downs side by side and the second one becomes dependent on what you chose in the first.

So if i Choose Phase 3 the second column would only show steps associated with Phase 3 not all the others.

Thanks

[Jeremy_Oglesby]

It’s not possible currently.

Here are some #feature-requests and #support questions that address something similar/related:

[SOLVED] Add Conditional Logic to Form Views Product Suggestions

Being able to hide/show fields in the form view based on the values of fields higher up in the form could be extremely valuable. For instance, if using Airtable to keep track of leads, one might have a Single Select field with the following options: Relationship No Relationship Met at a conference Contacted through website If “Met at a conference” is selected, it would be valuable to collect information about that conference in a conference field, but it wouldn’t make sense to capture that …

Conditional 2nd Lvl Single Select Ask the community

Hi, Pretty new to airtable but I’ve seen this function is possible in google sheets. I want to have 2 single select lists. The second single selects options should be dictated depending on what is put in the first single select list. Is there any way to do this? I.e: “Single Select 1st Lvl = Pizza” "Single Select “2nd Lvl = Pepperoni, Pineapple, Ham” But if i were to switch “Single Select 1st Lvl = Hamburger” “Single Select 2nd Lvl = Meat, Vegan” This would be very useful for us when rep…

Hierarchical Single/Multi Select fields Product Suggestions

Would there be anyway you’d consider adding hierarchical single select columns that show different options depending on what is selected in a prior column? For example in one column imagine that you have a list of car manufacturers labelled ‘Make’ Some options in here could be: Audi BMW Ford Volkswagen Then you could have a second single select column called ‘Model’. It would be great if this only showed options related to the first column. So for example if Audi is selected in the first …

Automatically change single select based on date Views

I’m building a task tracking dashboard. For a given task row I have a single select field with various status levels included “Scheduled” and “Today.” I also have a Date field called “Scheduled for” where I forecast the date I want to do that task. When I create a task I want to schedule out I choose Scheduled for the Status field and enter a date in the Scheduled for. I would love it if the base would automatically update the Status field to “Today” when the "Scheduled for date matched today’…

[Shannon_Johlic]

Looks like I’ll have to abandon Airtable. This is a much needed (and VERY much requested feature/capability) and yet no one from support offers any real help. EVERY client I have been trying to use Airtable with needs this functionality (for instance - selecting a “PRODUCT FAMILY” and then having “PRODUCT SUBFAMILY” options populate related only to “PRODUCT FAMILY”).

Really wish they would offer some kind of support for this.

[Mary_Alderdice]

I, too, am frustrated by the lack of support for this in the various database-alike services online.

Does anyone have a recommendation for a solution for this? (Either SaaS or an application (Mac and/or iOS support necessary).)

meri

[W_Vann_Hall]

While this functionality still does not exist using conditional single selects — that is, where the list of possible choices for a {Subcategory} selection depends upon an earlier choice made in a {Category} selection — it is now possible for linked records, where {Category}, {Subcategory}, and, if you wish {Subsubcategory}, {Subsubsubcategory}, and so on are presented in the form of a linked record.

There are limitations; to quote from my original announcement

First, the caveats:

1. This version of the routines requires all selections be made in the form of linked records. While variations are possible where only the final, limited selection be presented as a linked record, they impose other limitations: namely, that each record of the main table be linked to a single record in the [Control] table for conditional logic to work. The version discussed here and in the referenced base requires only category and subcategory tables to be linked to [Control] ; records may be added to the main table without any such preliminary housekeeping.
2. Currently, there is no way to limit user choice to already-existing linked records; a user may create a new linked record at any selection level. While there are ways to generate an alert should such a thing happen, there is, to my knowledge, no way to prevent it. (Yes, a user entering data from an Airtable form cannot create a new linked record — but see the next entry.)
3. Perhaps most disappointingly, because of the way Airtable creates records entered from a form view, these routines do not work with forms.

The original announcement can be found here. It contains a description of the process, screenshots, and links to two example bases, one demonstrating Category → Subcategory conditional links, the other Category → Subcategory → SubSubcategory.

(Note this capability is only possible because of a recent enhancement made to Airtable.)

[Edwin_Brito]

Any idea when this functionality is going to be available?

It seems like a must do when managing data :-?

[Alec_Fotsch1]

I would also really appreciate the ability to have single select with a family followed by a subfamily where the sub family is dependent on the family selected.

[YoDee]

SWITCH() statement does it perfectly well for me

=SWITCH({DERIVED FIELD},"SOURCE VALUE 1", "DERIVED VALUE 1", "SOURCE VALUE 2", "DERIVED VALUE 2", "SOURCE VALUE 3", "DERIVED VALUE 3", "SOURCE VALUE 4", "DERIVED VALUE 4", "SOURCE VALUE 5", "DERIVED VALUE 6", "SOURCE VALUE 6", "DERIVED VALUE 6", "SOURCE VALUE 7", "DERIVED VALUE 7", "SOURCE VALUE 8", "DERIVED VALUE 8")

[Lapulapu]

Thank you for this! Hopefully they’ll build this functionality in seamlessly. I too need it for the work I’m doing.

[Gespion]

Hello guys, so I’ve also been looking for a way to do this conditional selection with categories and sub-categories. Here’s my take on it which is working but might be hard to main if you have a lot of cat/sub-cat:

1. Create your form with a Category Field (CF) having a single select type and add your categories list.
   

2. Create as many tables as you have categories (in each table, add a single column then add your sub-categories list)
   

3. In your form, add a new field to be used as your dynamic Sub-Category Field (SCF). Then link your SCF to your CF.
   

4. Select the option Show field only when conditions are met. Then select your CF name and one of the categories in the list like below.
   

5. Repeat steps 3 and 4 for each category on your category list.
   

Hope it will help some of you while Airtable add this as a native feature.