- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 20, 2018 10:29 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jun 30, 2020 02:29 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 02, 2020 03:22 PM
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. : )
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 03, 2020 09:34 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 17, 2021 05:25 PM
That’s a great work around… I just replied because I see it’s a french airtable… glad to see that here, hahaha!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 14, 2021 06:24 AM
Merci beaucoup !! :ok_hand: :thumbs_up:
C’est ce que je cherchais… :winking_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2021 08:32 AM
De rien @Bart_Junior Ravi d’avoir pu aider :winking_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 15, 2021 08:33 AM
Thanks @Adriel_Pahati :slightly_smiling_face:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 13, 2021 06:58 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 04, 2022 12:31 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Apr 19, 2022 07:04 AM
Yes, pretty frustrating