topic Re: Survey123 Select Multiple Default in ArcGIS Survey123 Questions

Survey123 Select Multiple Default

JordanHolt — Fri, 05 Aug 2022 21:02:21 GMT

I have a select multiple list of possible "Pole Issues" , one of the options being "NO_ISSUE". I want to default this to "NO ISSUE" but after any other option is selected the default to be removed. Is this possible?

Re: Survey123 Select Multiple Default

ChristopherCounsell — Mon, 08 Aug 2022 04:37:17 GMT

You can apply a constraint on the the combination of 'no issue' and other answers. This would require the user to unselect the 'no issues' choice before proceeding. The constraint message can also be added to help guide the user.

Have not tested it but a sample constraint could be something like the below (constraint is not having more than one selection if 'no issues' is selected).

not(selected(., 'no_issues') and count-selected(${issues})>1)

https://support.esri.com/en/technical-article/000020969

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_8979CBF8B7354DA9A4FE0F6B6D61E1A0

An alternate approach to this scenario is to have two questions and add relevancy:

Are there one or more issues?
Issues (relevant to issue = yes)

Please don't forget the kudos 🙂

Re: Survey123 Select Multiple Default

JordanHolt — Mon, 08 Aug 2022 14:21:46 GMT

I appreciate the response! I am trying to eliminate clicks and make it as easy as possible for the guys in the field. This did work but its adding clicks. I went ahead and just removed "NO_ISSUE" from the choices list and will just know moving forward if blank it will indicate "NO_ISSUE".

Re: Survey123 Select Multiple Default

LaurenceTait — Wed, 10 Aug 2022 02:56:56 GMT

You can do this fairly easily using javascript.

The script itself is three part process. First convert the answer to a string, then check if the string contains any answers other than "no issue". If there are other answers, delete the "no issues" response and keep the rest.

I've attached an example. The modified answer is currently visible so that you can see the workings of the script. For the final version the "held_condition" field should be set to hidden. The initial question should also be set to "null" so that only the modified answer is saved.

Because this site won't allow the upload of js files, you'll have to copy the contents of the .txt document into a js function called "Replacefunctions.js".

Re: Survey123 Select Multiple Default

Katie_Clark — Wed, 10 Aug 2022 13:55:51 GMT

That's an awesome idea, @LaurenceTait , thank you for sharing your wisdom! 🙂

Re: Survey123 Select Multiple Default

JordanHolt — Wed, 10 Aug 2022 23:54:02 GMT

I appreciate all your help! I am still working on making this all make sense. Below is what I have currently and its no working right now. If you see anything thats wrong please let me know! If you need anything further from me or have any follow up questions please let me know!! I really appreciate it!

Re: Survey123 Select Multiple Default

LaurenceTait — Thu, 11 Aug 2022 00:35:30 GMT

There is a minor glitch in your code at Line 10. Should be const issuesString = issues.join (', '); and you have const issuesString = issues.join ('', ' '); But that won't stop it from working.

What do you mean when you say it's not working? Are you getting an error message in the script compiler, or when you save the xlsx sheet, or something else"

What happens when you test your code? Click the "fx" button on the scripts page, then copy in one or two of your choices from the worksheet, separated by a comma ",". Then click the execute button ">".

I've tried to replicate the sheet and code that you are using, and it works fine. I've attached the files below. Try those and see if you can get them to work, then you can use that as the basis for your own suvey.

If you upload your xlsx sheet and your js code, I'll try it at my end and see if it works. That might be the fastest option.

Cheers.

Re: Survey123 Select Multiple Default

JordanHolt — Thu, 11 Aug 2022 14:19:56 GMT

Sorry for the confusion, when I say its not working - When I go to my Pole Issues list and click another from the select multiple, it is not unselecting the "No Issue" that is defaulted. Hope this clears up what I mean. I attached the xlsx and .js below.

Re: Survey123 Select Multiple Default

LaurenceTait — Fri, 12 Aug 2022 00:59:37 GMT

Two minor problems.

You have the [relevant] field for [held_condition] set to “false". Any field that is not relevant has the value set to null, so the held condition field can never store any values.

The other problem is that you have only added the first 4 of your 11 issues to your javascript finction, so the function will only work if you select one of those 4. Add all 11 to the function and it will work fine.

Re: Survey123 Select Multiple Default

JordanHolt — Fri, 12 Aug 2022 18:44:45 GMT

So what I am seeing is that the "held_condition" is being updated when I select from my "Pole_issues" list. In your initial response you were saying the "held_condition" needed to be hidden and the initial question should be set to "null". What I am not seeing is the initial question with the default set to "no issue" unselecting when I select another issue on the list. I was hoping to default the question to "no issue" so if they crew doesn't find anything they question is already filled out for them, but if they do find an issue and select "hand_hole_cover_missing" it would unselect "no_issue" and only have one of the boxes checked. Sorry for all the questions and confusion on this. I think I am misunderstanding what the script is completing.

Re: Survey123 Select Multiple Default

LaurenceTait — Sun, 14 Aug 2022 23:13:47 GMT

Because Survey123 evaluates all fields simultaneously, you can't select a default and not select it simultaneously. It has to be one or the other.

What this does is return a value of either no option or another option. It doesn't matter if the no option choice is selected because it is isn't returned. If the user is puzzled by the "no issue" choice being selected, they can remove it manually. If they aren't concerned by it, then it appears visible but isn't returned.

Re: Survey123 Select Multiple Default

survey123_solutions — Thu, 22 Sep 2022 12:58:20 GMT

Hi All
Hoping that this can help me with my current objective- not exactly like this, but I think I can use the js for this purpose with a bit of your help.
I have a multiple select and when user selects their choices, they're stored as comma delimited values.
How to go in there and separate them so that they may be used as individual fields for reporting purposes?

Also- how do i make the select multiple default to "all of them selected" -- usually the user will need to select all of them-
Thanks so much.

Re: Survey123 Select Multiple Default

LaurenceTait — Mon, 26 Sep 2022 02:12:35 GMT

Unless you have a huge number of choices, if you want to split the answers in the survey then the easiest way is just to to create fields for each possible answer and populate the field if the answer is selected.

Setting the response to all selected is done exactly the same way as setting the fault to a single answer, but with commas between the answers.

Re: Survey123 Select Multiple Default

survey123_solutions — Mon, 26 Sep 2022 10:28:08 GMT

Thanks so much!!