Aug 07, 2024 07:43 PM
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?
Aug 07, 2024 10:19 PM
What 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.
Aug 07, 2024 10:44 PM
Hmm 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
Aug 07, 2024 11:04 PM
Thanks that's exactly what I'm trying to achieve.