topic Re: Assigning Values to Choices for Select_Multiple Questions in ArcGIS Survey123 Questions

Assigning Values to Choices for Select_Multiple Questions

JasmineSnowsill — Thu, 03 Feb 2022 02:26:17 GMT

I am working on connect, attempting to create a survey to be used for entering stream health data / variables of which many are to be given a score depending on the level of quality they indicate.
Thus far I have been able to give values to 'select_one' choices by naming the choices the value that coincides with that choice (as shown below).

I have tried to use this method (above) for the select multiple questions but it did not produce any 'score'

I have also tried the method (below) with ‘if’ statements such as “if(selected(${TrueFlies},Mosquito),3,0)”.
I thought this would equate to if mosquito is selected from the list of true flies then give it a score of 3, if this is false (meaning it is not selected) then value it at 0. However I think this function is possibly not for this type of use.
No score was automatically calculated in the row where I attempted to add all the values and divide it by the number of choices that were actually selected. It's very likely that I am using the wrong methods but I couldn't find anything else that may work.

I am rather new to using survey123 and survey123 connect so I hope my question and aim makes sense.

Thanks

Re: Assigning Values to Choices for Select_Multiple Questions

SayedWali — Thu, 03 Feb 2022 10:16:27 GMT

Hi @JasmineSnowsill

what I have noticed if(selected(${TrueFlies},Mosquito),3,0) is not correct. Please put the Mosquito inside single quotes as this: if(selected(${TrueFlies},'Mosquito'),3,0) and follow this with all other strings in your calculations.

To answer the rest of your questions, could you upload your XLS file to evaluate the questions?

Re: Assigning Values to Choices for Select_Multiple Questions

JasmineSnowsill — Thu, 03 Feb 2022 21:35:15 GMT

Hi @SayedWali

Thank you, I updated my strings and that has helped as it is now showing me an output. Unfortunately the output should be a number between 1 and 10, so something is definitely wrong in my calculations (see below).

I have attached my XLS file.

Thanks for your help 🙂

Re: Assigning Values to Choices for Select_Multiple Questions

SayedWali — Tue, 08 Feb 2022 11:55:03 GMT

Hi @JasmineSnowsill

sorry for late as it's busy days for me.

I have modified little bit your XLS form and set int for the bind and changed esri bind into decimal for InvertScore then changed the type to Calculate. Also created another field name Invertebrate Scores to Round the total Score.

Have the attachment and the screenshot

Seems to be working!

Cheers

Re: Assigning Values to Choices for Select_Multiple Questions

JasmineSnowsill — Tue, 08 Feb 2022 20:06:56 GMT

Hi @SayedWali

No worries.

Thank-you for your explanation and help, I really appreciate it!

Cheers 🙂

Re: Assigning Values to Choices for Select_Multiple Questions

JeetzPatel — Wed, 18 May 2022 01:37:26 GMT

Thanks both for this workflow, I needed to do something similar for one of my projects and it's worked perfectly! I stuck the round into the calculate for the overall score which is the only difference I had.