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

[Greg_Rochlin]

Thanks for that Gespion. This seems to be simpler than my current solution, which is based on submenu fields in combination with the above conditional entry. I have built a formula field which checks the correctness of the set of submenu fields. It is a whopping great formula :slightly_smiling_face: It does mean that the menu value can be entered directly into the table, and the validation field will give guidance if the result is inconsistent. I will check out your method. Cheers

[Hilary_Niles]

Hi Greg! I am interested in the whopping great formula you wrote. Would it be possible to share and maybe even explain a little bit here? So far, the solutions presented here and in other threads don’t match my needs. I’m hoping that either your formula would do the trick, or I could learn enough from it to be able to adapt …

In short, I am hoping to structure my base so that records can be linked to more than one category (from a category table), and then the relevant subcategories for each of the chosen categories would be available for the user as a multi-select field. That’s how I’m picturing it, anyway. However it’s structured, I just need to allow multiple categories AND multiple sub-categories, and I’d like to be able to filter the subcategories according to the selected categories.

Thanks so much in advance, if you have the time to respond. I realize this is an old thread. : )

[kuovonne]

I offer my clients a system of using linked records for categories and subcategories, so that only subcategories belonging to the chosen category are displayed.

• A record can have multiple categories
• A subcategory can belong to multiple categories
• It can be modified to allow a record to link to multiple sub-categories.

Here is a video demo of it in action.

[Adriel_Pahati]

That’s a great work around… I just replied because I see it’s a french airtable… glad to see that here, hahaha!

[Bart_Junior]

Merci beaucoup !! :ok_hand: :thumbs_up:
C’est ce que je cherchais… :winking_face:

[Gespion]

De rien @Bart_Junior Ravi d’avoir pu aider :winking_face:

[Gespion]

Thanks @Adriel_Pahati :slightly_smiling_face:

[Allen_Moldovan]

Hey Paul

Airtable rolled out “Dynamic Variables” to their automation “Find Records”. It enables you to set a condition as static or dynamic.

IF this were to be rolled out to the the linked record field type, you could accomplish this. This functionality would look through values in the destination table and filter the linked record options for only those records which match those conditions on the table being worked on.

IT would essentially give you a more robust version of a conditional & dynamic drop down.

please be sure to email this to support@airtable.com to push them on this scope expansion of Dynamic Conditions to the meat and bones of the platform.

Let us know if they hint to this functionality’s existence on the release road map.

[Patrick_Blattne]

This is a very creative solution, but still a workaround. Thanks for sharing! But I just don’t understand why they are taking so much time with this so basic feature, which definitely belongs in DB app. And even worse, the last time I asked, it rather felt like Airtable is not sure if this should be implemented at all.

[Allen_Moldovan]

Yes, pretty frustrating