Submission form where option A determines option B

Ask for Help
1

Hello Everyone,

After a frustrating evening being sent in circles by Ai I was hoping a human may have a better understanding of what I hope to, but currently cannot, achieve.

I am looking to create a submission form for students to submit their extra curricular activities (they do this and get points and rewards).

There are 5 categories the students can submit under and each category has 5 sub areas. I wanted to create a form that when the students selected category A it would only show areas 1,2,3,4&5 and if they selected category B it would show only areas 6,7,8,9&10 etc.

My problem is I cannot seem to get them linked correctly. When I select category all of the options come up. I tried making a relations column in my tables that linked my categories to my area but no luck. Is there anyway I can make this work?

2

The canonical way to do this is to use screen values to filter the second choice component. But then it depends how your data is laid out. Ideally you should have a list of Categories and Sub-Categories in a single table (one column for each), with one row per Category/Sub Category combination.

1 Like