topic Re: Assign score based on Select one question type, can only score 2 of three answers in ArcGIS Survey123 Questions

Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 15:41:24 GMT

We are trying to create a survey in Survey123 Connect where a score is assigned based on user choice for a select_one type question in an integer type following the question. The issue we are having is that we are only to generate scores for 2 of the questions depending on the calculation formatting. See screenshots below as well as the calculation used in the integer type. Any suggestions would be greatly appreciated

if(${a2o_1}="yes",${c2},${c1}) or if(${a2o_1}="yhi",${c3},${c1}) or if(${a2o_1}='no',${c1},${c1})

Re: Assign score based on Select one question type, can only score 2 of three answers

DougBrowning — Mon, 20 Mar 2023 15:55:59 GMT

You cannot use or inbetween if statements like that. You need to use the else in the if. Looking at your options I think this would work and be simpler.

if(${a2o_1}="yes",${c2}, if(${a2o_1}="yhi", ${c3}, ${c1}))

This assumes it will never be blank.

Hope that helps

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 16:03:05 GMT

That did the trick, thanks Doug!

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 16:48:14 GMT

so, if I wanted to sum the results from multiple questions, what would be the proper syntax for that?

${a2o_1}+${a2o_2}...

Re: Assign score based on Select one question type, can only score 2 of three answers

DougBrowning — Mon, 20 Mar 2023 18:06:21 GMT

Yes typically that is what I do. One line for each sum then one master that sums them all up. Set the bind type field to int so you get a number and not a string. Can also set the temp fields bind esri type to null and they will stay out of the feature service.

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 18:35:47 GMT

hmm, I must be doing something wrong. Getting an empty output with the following. Same empty output with parenthesis around the calculation

Re: Assign score based on Select one question type, can only score 2 of three answers

DougBrowning — Mon, 20 Mar 2023 18:43:24 GMT

Are those 3 fields set to bind int?

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 18:48:13 GMT

I believe so, yes

Re: Assign score based on Select one question type, can only score 2 of three answers

DougBrowning — Mon, 20 Mar 2023 19:22:50 GMT

Yes that looks right. At this point just post the form or just guessing.

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 20:07:53 GMT

Good call, see attached, thanks

Re: Assign score based on Select one question type, can only score 2 of three answers

DanielChelist — Mon, 20 Mar 2023 20:23:51 GMT

Oop, I see what I did there, i was pointing to the questions not the the integer