Help

Re: Dependant values for drop-down menu

450 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Pascal_Vallet
7 - App Architect
7 - App Architect

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?

3 Replies 3

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.


Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/

Hmm I'm not too sure I understand.  Does this look right?

Data setup:
Screenshot 2024-08-08 at 1.42.57 PM.png

Screenshot 2024-08-08 at 1.43.07 PM.png

Which would allow for:
Screenshot 2024-08-08 at 1.43.16 PM.png

Screenshot 2024-08-08 at 1.43.22 PM.png

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.