idea Survey123 - Multiple choice selections as separate entries not comma separated list in ArcGIS Survey123 Ideas

Survey123 - Multiple choice selections as separate entries not comma separated list

JessicaRouns — Mon, 31 Jan 2022 00:24:34 GMT

Currently, if a user selects multiple options in a multiple choice list, this will result in a comma separated list of all selected options. This does not work well when presenting the results in a dashboard. Preferably, all the selected options would be added separately and therefore present more cleanly in a dashboard.

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

DougBrowning — Wed, 02 Feb 2022 16:41:40 GMT

You can either have 1 field with comma separated values or use a repeat and have multiple rows. Where would the data go otherwise in the database schema?

Data Expressions should be able to do what you want. This one has a example just like you want https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/introducing-data-expressions-in-arcgis-dashboards/

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

ZoevdbAT — Wed, 02 Feb 2022 15:59:42 GMT

If you're working with a dashboard i'm sure it's possible to use an Arcade expression with something like a split function to return the seperated data as you need.

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

IsmaelChivite — Thu, 03 Feb 2022 16:20:49 GMT

Idea: In your Survey123 design, you can add hidden fields (one for each option in your list) to keep track of which choices were selected. The technique is described in this blog:

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-xlsform-functions/ba-p/893567

Check the selected(question, value) section

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

JessicaRouns — Fri, 04 Feb 2022 01:47:26 GMT

@ZoevdbAT You can do this with Survey123 Connect, but not with the web app. Unfortunately we do not have access to Connect.

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

JessicaRouns — Fri, 04 Feb 2022 01:52:09 GMT

@IsmaelChivite Thanks Ismael, unfortunately though I don 't have access to Connect. I was hoping something similar could be an option for the web version of Survey123.

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

ZoevdbAT — Mon, 07 Feb 2022 09:00:56 GMT

@JessicaRouns I'm sorry I meant define the expression in the ArcGIS Dashboard itself. If you load in data you can use a data expression which uses Arcade.

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

Engineertechnical — Sat, 01 Jul 2023 15:19:18 GMT

I have a problem with using data expression. Actually I do not have experience with coding

I have copied the code that mentioned in this post "https://www.esri.com/arcgis-blog/products/ops-dashboard/announcements/introducing-data-expressions-i... "

But it gives error

I have modified the 'Report_road_condition' with name of my multiple choice question. but I am not sure what to use instead of 'd10b9e8dbd7f4cccbd0a938a06c586e9'.

Thanks in advance

// Reference layer using the FeatureSetByPortalItem() function.
var fs = FeatureSetByPortalItem(Portal('https://www.arcgis.com'), 'd10b9e8dbd7f4cccbd0a938a06c586e9' , 0, ['Report_road_condition'], false);

Re: Survey123 - Multiple choice selections as separate entries not comma separated list

DougBrowning — Wed, 05 Jul 2023 14:14:53 GMT

The 'd10b9e8dbd7f4cccbd0a938a06c586e9 part should be whatever the ItemID is of your service in AGOL. Just go to the page of the service in AGOL then at the top in the URL you will see your ItemID. It is a universal number to find things in AGOL.

Hope that makes sense.