topic Issues exporting multiple choices questions label to excel in ArcGIS Survey123 Questions

Issues exporting multiple choices questions label to excel

Marie-JoëlleDesgagné — Tue, 12 Oct 2021 17:17:06 GMT

Hi,

I am trying to export my data from Arcgis survey123 to Excel. When I export my file, the select one question's labels will appear but only the code name is displayed when it is a select multiple question. How could I avoid this?

Thank you in advance !

Re: Issues exporting multiple choices questions label to excel

DeonLengton — Wed, 13 Oct 2021 09:30:45 GMT

Hi Marie

You could create a hidden field with a comma separated list of the code descriptions...

I know its a work-around. Not sure if there is a setting to export the code descriptions though

Re: Issues exporting multiple choices questions label to excel

lourymello1 — Fri, 22 Jul 2022 16:31:02 GMT

Hi!!

@DeonLengton and @Marie-JoëlleDesgagné how you use the commas?

I am trying do it but that is not doing ideal. I am using this function:

jr:choice-name(selected-at(${cultura_cobertura}, 0), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 1), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 2), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 3), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 4), '${cultura_cobertura}')+ (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 5), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 6), '${cultura_cobertura}') + (', ') + jr:choice-name(selected-at(${cultura_cobertura}, 7), '${cultura_cobertura}')

But with this function the commas shows as default on answer. I coudn't found another way to insert the commas. I wish you did!! 🙂

Thanks!