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]

Hi Callum,

Thanks for the problem description.  The main issue is that at this time, the choice_filter currently doesn't support functions, which would be able to accomplish this.  I've added this comment to the enhancement request to address that.

[CallumSmith2]

Thanks James

[DavidRebot]

Any update on this?

[JamesTedrick]

Hi David,

As of yet, there's no update for the mobile app.  The new webform does support functions within choice lists, if your survey is appropriate for the web.

james

[AndrewHansford]

Hi there,

With the latest updates to Survey123, is this now possible?

Cheers

Andrew

[JamesTedrick]

Hi Andrew,

No this feature has not yet been implemented into the Survey123 app.

[AndrewHansford]

JTedrick-esristaff‌ Thats a real shame. do you know of a decent work around? Thanks

[JamesTedrick]

Hi Andrew,

Take a look at or_other and choice_filter and https://community.esri.com/thread/208453-xlsform-issue  - both of these show how a choice_filter can support a value that can be filtered by more than one previous choice.

[AndrewHansford]

Hi JTedrick-esristaff‌ just wondering is this only usable with select one not multiple? Thanks