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
