topic Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2 in ArcGIS Survey123 Questions

Selected choices from 'Select Multiple' in Question 1 to be used in question 2

Reuben — Sun, 10 Mar 2024 00:08:03 GMT

hi,

I am in a situation where I want the choices selection in Question 1 (only the selected choices) to be

re-used in Question 2. Any suggestion or hint would be greatly appreciated.

thanks

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

ChristopherCounsell — Sun, 10 Mar 2024 00:58:16 GMT

What is question 2? How do you want them to be re-used? Like, select again?

You could use a choice filter, maybe see if you can filter to the same list:

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-choice-filters/ba-p/894046

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

Reuben — Sun, 10 Mar 2024 01:01:59 GMT

Hi Chris,

Question 2 is a 'Select One" Question Type.

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

ChristopherCounsell — Sun, 10 Mar 2024 01:11:09 GMT

Try setting up a choice filter on the select_one question that's filtered by the same values. Typically you'd have a number of choices filtered but you can just have one-one. So if the value isn't selected in the select_multiple question, it won't appear.

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

Reuben — Sun, 10 Mar 2024 01:55:33 GMT

hi Chris,

I use this expression in the Choice Filter Column: selected-at(${C1_eco}, '${C1_eco}) where, I want to return Only the selected choices in Question 1. However, only one (the first selected choice) was returned. Others were not returned.

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

ChristopherCounsell — Sun, 10 Mar 2024 02:14:16 GMT

if C1_eco is the first question, the choice filter on question_2 should say

selected-at(${C1_eco}, filter)

Where filter is the name of the filter column you have added to your choices list. It can be a copy of the list.

e.g. here the filters are 'country' and 'region'. you could try the same but your filter would be 'city' and it'd be a direct copy of the list, a one to one match.

so add a column called 'eco_filter', copy the names from the list into it, then have your choice filter on the second question be selected-at(${C1_eco}, eco_filter)

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

JenniferAcunto — Mon, 11 Mar 2024 12:00:25 GMT

Set up your list so that each choice's name value also appears in a choice filter column.

Now we need to set up the actual choice filter for Question 2. Question 1 is a Select Multiple, which means the selected choices will be stored in a comma separated string such as red,yellow,blue. So the choice filter needs to be able to parse the stored answer to look for each choice's filter value.

contains(${q1}, cf)

If the Question 1 response contains our choice filter value it will display the value.

Re: Selected choices from 'Select Multiple' in Question 1 to be used in question 2

Reuben — Wed, 13 Mar 2024 02:59:53 GMT

hi Jennifer,

Thanks