I have a table where we can record incidents occurring at school and select an incident category (e.g., stealing). Once a teacher selects an incident, they can choose the logical consequences from another table. Each incident category has a list of specific consequences. Can you explain how I can create a dropdown menu in Airtable and Airtable forms so that the values available for logical consequences are filtered to show only those related to the selected incident category?
Dependant values for drop-down menu
+14
+20What you're specifically looking for isn't possible in Airtable alone. Though there are workarounds.
My suggestion is to create individual dropdown menus for each logical consequence. I'm unsure how complicated each logical step would be in your use case.
From there, make a formula to combine each field so we now have just one output. You can also convert this to output as a single select field to keep the **bleep** and colours which will also help automations and other formula things.
Otherwise, I'd start looking into third-party apps that can do what you're looking for.
+31Hmm I'm not too sure I understand. Does this look right?
Data setup:
Which would allow for:
If so, check out https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields
Adam, Airtable Consultant - thetimesaving.company
+14Hmm I'm not too sure I understand. Does this look right?
Data setup:
Which would allow for:
If so, check out https://support.airtable.com/docs/dynamic-filtering-in-linked-record-fields
Thanks that's exactly what I'm trying to achieve.
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.