Using 'jr:choice-name' for multiple selections

Question

Hello all,

Is there any syntax using 'jr:choice-name' for all/ any selections in multiple choices? I hope to get labels in the attributes no matter how many answers are selected. I am aware that 'at' can be used to pull out the value in the specific order, but not sure how I can apply it to the entire answers.

leo_SwissGIS · Answer

Hi ! I suggested a solution using Excel TEXTJOIN function and javascript that prevents the pain with larger lists or the need deal with extra separators, and allows to keep the choice order.

You can find the details in this thread:

Re: How to return all labels from a select multipl... - Esri Community

Hope it helps and saves some time !

Léo

daeronicus · Answer

I revived this only to provide a more simple solution for this.

You only need one hidden field using concat formula parameterized like this:

concat(jr:choice-name(selected-at(${your_question},0), '${your_question}'), ', ', jr:choice-name(selected-at(${your_question},1), '${your_question}'),', ', jr:choice-name(selected-at(${your_question},n), '${your_question}'))

You will have to increase n as many times as answers you want to capture.

This expression will generate a list like this

selection 1, selection 2, selection n, ....

Of course you can replace ', ' with any character you want to use for separate the choices, you could use ' | ', or ' - ', etc

The XLSForm will look  like this

typenamelabelcalculationhiddenyour_field_nameThe label you want to useconcat(jr:choice-name(selected-at(${your_field_name},0), '${your_field_name}'), ', ', jr:choice-name(selected-at(${your_field_name},1), '${your_field_name}'),', ',jr:choice-name(selected-at(${your_field_name},2), '${your_field_name}'))

The column bind::esri:fieldType will be esriFieldTypeString and bind::esri:fieldLength can be 1000 length.

Later you can filter this on a dashboard with a filter applied to your hidden field using the contains parameter with the choice you want to show.

Hope this helps.

BenjaminAu · Answer

Hi Brett/Kerry, I am totally new to GIS domain. So happens I came across this website with the extensive methods to invoke within XLS for Survey123 Connect. Within the PDF there is a section describing the jr:choice() for multiple choice questions. Below is the example used to select exactly three colors: Table 1: Survey typenamelabelhintconstraintconstraint_messageselect_ multiple colorscolor_prefsWhat colors do you like?Select threecount-selected(.)=3Select exactly three. Table 2: Choices list_namenamelabelcolorsredRedcolorsblueBluecolorsyellowYellowcolorsgreenGreencolorsorangeOrangecolorspurplePurple Table 3: Survey with jr:choice() typenamelabelhintcalculationselect_multiple colorscolor_prefsWhat colors do you like?Select three. calculatecolor_0 jr:choice-name( selected-at(${ color_prefs}, 0), ’${color_prefs}’)calculatecolor_1 jr:choice-name( selected-at(${ color_prefs}, 1), ’${color_prefs}’)calculatecolor_2 jr:choice-name( selected-at(${ color_prefs}, 2), ’${color_prefs}’)notecolor_noteSelected colors:${color_0}
${color_1}
${color_2} Snapshots from the PDF are attached here for your reference. Pardon for the resolution, it is snipped based on the PDF. For more information you can visit this link and download the PDF for its full information: https://docs.getodk.org/ I was able to use such concept on my form to produce the expected output. Hopefully it helps! jr choice image 1.PNG jr choice image 2.PNG