topic Re: Survey 123 Cascading Selects - Normalise Options in ArcGIS Survey123 Questions

Survey 123 Cascading Selects - Normalise Options

CallumSmith2 — Wed, 31 May 2017 03:51:59 GMT

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

Re: Survey 123 Cascading Selects - Normalise Options

JamesTedrick — Wed, 31 May 2017 16:18:08 GMT

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.

Re: Survey 123 Cascading Selects - Normalise Options

CallumSmith2 — Wed, 31 May 2017 19:33:17 GMT

Thanks James

Re: Survey 123 Cascading Selects - Normalise Options

DavidRebot — Thu, 27 Jul 2017 20:07:54 GMT

Any update on this?

Re: Survey 123 Cascading Selects - Normalise Options

JamesTedrick — Tue, 01 Aug 2017 20:31:15 GMT

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

Re: Survey 123 Cascading Selects - Normalise Options

AndrewHansford — Thu, 01 Feb 2018 02:30:06 GMT

Hi there,

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

Cheers

Andrew

Re: Survey 123 Cascading Selects - Normalise Options

JamesTedrick — Thu, 01 Feb 2018 02:56:24 GMT

Hi Andrew,

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

Re: Survey 123 Cascading Selects - Normalise Options

AndrewHansford — Thu, 01 Feb 2018 03:00:33 GMT

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

Re: Survey 123 Cascading Selects - Normalise Options

JamesTedrick — Thu, 01 Feb 2018 03:08:07 GMT

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.

Re: Survey 123 Cascading Selects - Normalise Options

AndrewHansford — Thu, 01 Feb 2018 03:15:02 GMT

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

Re: Survey 123 Cascading Selects - Normalise Options

JamesTedrick — Thu, 01 Feb 2018 03:17:07 GMT

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.

Re: Survey 123 Cascading Selects - Normalise Options

AndrewHansford — Thu, 01 Feb 2018 03:20:29 GMT

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