Survey 123 Cascading Selects - Normalise Options

[CallumSmith2]

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

[JamesTedrick]

Yes, it won't work with select_multiples as you would need separate out the choice.  You might be able to extend this with some calculate fields to separate out the choices into hidden fields for evaluations, but that would start being a really complicated work-around.

[AndrewHansford]

Hi JTedrick-esristaff‌ Thanks for this, I will tinker around but dont want to spend to much time on a work around, what you have provided me in the first instance should work. Cheers