topic Re: Select one cascade choice filter - make some choices relevant to more than one previous choice in ArcGIS Survey123 Questions

Select one cascade choice filter - make some choices relevant to more than one previous choice

JulietK — Sun, 22 Nov 2020 22:21:09 GMT

Hi, I am looking for ways to make the choice list of the child select_one choice be relevant to more than one options selected in the parent select_one choice.

For example, I have the choice list of Site to be filtered by Location.

However, I would like to have the choices in Site to be filtered by more than one Location choice, example below:

So that 'Tomato' would be shown on the list when A is selected, and also show when C is selected. I've tried separating the parent choices with a comma as above but it doesn't work, and I've also tried separating with OR (e.g. A OR C) which did not work either. With both comma and OR, the choices list for Site was not displayed at all or the dropdown arrow was not offered (for autocomplete appearance).

Is this type of choice filter possible at all, and if so, how should I separate the parent choices? I've done google searches and community searches but haven't been able to find any mentions of anything similar.

Thank you!

Re: Select one cascade choice filter - make some choices relevant to more than one previous choice

jcarlson — Sun, 22 Nov 2020 23:06:05 GMT

It's actually quite simple! Just add duplicate rows for the additional choices you'd like to include. Using the example you gave, it would look like this:

List Name	Name	Label	Location
Site	1	Tomato	A
Site	1	Tomato	C

To share a real-world example we use Surevy123 for an inter-departmental document workflow, and there are various combinations of choices in other questions that will depend on the status field. For instance, if the status is set to "Assessor Review", the review result field will only allow for the choices "Combination", "Good Legal", "Not GIS Relevant", or "Split", and will only allow the department field to be set to "assr".

Re: Select one cascade choice filter - make some choices relevant to more than one previous choice

JulietK — Sun, 22 Nov 2020 23:29:59 GMT

Hi Josh, thank you for the response! That is very helpful 🙂

Re: Select one cascade choice filter - make some choices relevant to more than one previous choice

AshleyPeters — Wed, 29 Sep 2021 18:02:26 GMT

I'm trying to create something similar to this, but I do not have a Location column in my choices tab. Is that a custom column?

Re: Select one cascade choice filter - make some choices relevant to more than one previous choice

JulietK — Wed, 29 Sep 2021 19:14:59 GMT

Hi yes its a custom column, you can just name the column yourself and make sure the choice filter column for the relevant field refers to it correctly 🙂 e.g. columnname=${fieldnamewithchoices}

Re: Select one cascade choice filter - make some choices relevant to more than one previous choice

AshleyPeters — Wed, 29 Sep 2021 19:32:39 GMT

Thank you!