topic Re: Survey123 - Aggregating Multiple Selection Field Labels in ArcGIS Survey123 Questions

Survey123 - Aggregating Multiple Selection Field Labels

Anonymous User — Mon, 17 Dec 2018 21:36:03 GMT

Hi Community,
I am currently building a Fire Inspection Survey. I would like all of the selected entries labels (not the names)to be pushed into my remarks field. As you can see in the picture provided, I am able to pull the names selected in each one of the multiple selection fields but I would like to build the additional notes field with the labels, not the name. As you Survey123 developers know, the name field does not allow for spaces and it is not as intuitive as the label field.

If someone has figured this out, could you please provide the excel syntax you used.

Thanks,

Joseph

Re: Survey123 - Aggregating Multiple Selection Field Labels

MichaelAughenbaugh — Tue, 18 Dec 2018 14:13:10 GMT

The "name" field does allow for spaces, though spaces aren't typically recommended. The only character I can tell that is not allowed is a comma, as the choice lists (choices, external_selects, and any lookup table) are automatically set to a .csv format. I've tried to find ways to return the label text as the answer for formatting purposes such as what you're attempting to do, and currently there is no way to do that, that I'm aware of.

Re: Survey123 - Aggregating Multiple Selection Field Labels

Anonymous User — Wed, 19 Dec 2018 16:31:35 GMT

Thanks for the additional research

Re: Survey123 - Aggregating Multiple Selection Field Labels

IsmaelChivite — Wed, 19 Dec 2018 17:52:33 GMT

Hi. The jr-choice-name() function may be handy for this. Check https://community.esri.com/groups/survey123/blog/2018/12/02/survey123-tricks-of-the-trade-xlsform-functions-for-lists for details.