Hi
Please consider the following scenario for Survey 123 Cascading Selects.
Question 1
Category with 2 options A, B
Question 2
Group with 4 options 1, 2, 3, 4
If the user selects A for question 1 then the valid options are 1, 2, 3 for Question 2
If the user selects B for question 1 then the valid options are 2, 3, 4 for Question 2
I know this can be done with cascading selects but the "entries" for 2 and 3 have to be duplicated like this
| list_name | name | label | category |
|---|
category | A | A | |
| category | B | B | |
| group | 1 | 1 | A |
| group | 2 | 2 | A |
| group | 3 | 3 | A |
| group | 2 | 2 | B |
| group | 3 | 3 | B |
| group | 4 | 4 | B |
It would be nice if this could be achieved without having to duplicate the options for the group question? i.e. Normalised. Is this possible?
E.G.
| list_name | name | label | category |
|---|
| category | A | A | |
| category | B | B | |
| group | 1 | 1 | A |
| group | 2 | 2 | A,B |
| group | 3 | 3 | A,B |
| group | 4 | 4 | B |
How do we allow the options for the group to be allowed in 2 (or more) categories?
cheers
Callum