Make un-selected choices from first multiple question disappeared in the second single choice question.

[Reuben]

hi ArcGIS Survey 123 Users,

I am looking for an appropriate syntax I could use to hide unselected choices from a previous question (select multiple choice question) so that only, the selected choices appeared in the follow-up question?  

Example:

Question 1: List the problems faced by the community (Select Multiple Choice Question)

A list of problems will be selected from the existing Excel sheet.

Question 2: What is the priority #1 Problems (Select Single Choice Question)

Only the selected problems in Question 1 should appear here (not the entire list)

Appreciate your comments

[Jim-Moore · Accepted solution]

Hi @Reuben 

Check out the Choice Filters and Cascading Selects sample in Survey123 Connect for some useful ideas on filtering choice lists. In particular, the Rank example group shows how to achieve what you're after using the selected() function in the choice_filter column. Here's an example:

Survey worksheet:

Choices worksheet:

In the form:

Hope this helps! Jim

[Reuben]

hi Jim-Moore,

Thanks alot