Helllllo, dear amazing community members
So recently I have been working on a new project and I have had to filter options based on the choice of previous answer, well, it isn’t as simple as I’m explaning, but let me eleborate.
I have the question 1, " Q1 - Select the camp or cc " with options : Op1, Op2 … Op6.
In the next question, I have " Q2 -Select the camp letter " with the options ," A, B, C , … X"
No, I want the second question’s options to be filtered based on the Q1 answer, knowing that some of the options of Q1 may have the same options of Q2. Ex:
The Op1 and Op2 and Op3 and Op4 from the Q1 should see the options “A, B, C, D” from Q2.
So I couldn’t use the normal filter, because I want each option from Q1 to so see specific options from Q2…
As you can see in this pic, if the option Op1 from cctype list had been selected I want the filter Op1 to apply to the list “csector_letter”, if the Op2 is the one been selected in cctype I want the filter list Op2 to show up in the list “csector_letter”
I’m attaching the document so it easier to check.
maseterlist_test - Kopya.xlsx (15.9 KB)
Best wishes