Survey123 Calculated Fields Different in Web and Device

Question

I have a TEXT field with a calculated value: The value is based on the selected value of a SELECT_ONE field named “structure_type”. The calculation is essentially serial string of if statements checking the selected value of “structure_type” and calculating the value of the TEXT field to some value.

if(selected(${structure_type}, "B-85"), "34 ft 7 in", "") or if(selected(${structure_type}, "B-85OP"), "34 ft 7 in", "") or if(selected(${structure_type}, "B-90"), "34 ft 7 in", "") or ...

In a device Survey123 the TEXT field is correctly calculated:

In the web Survey123, the TEXT field is incorrectly calculated:

Note that the web Survey123 treats the calculation as a Boolean, whereas the device Survey123 performs the desired calculation.

My question is: How can I perform the calculation correctly on both the device and the web?

TIA

dougbrowning · Accepted Answer

I have seen this posted.  It has to do with the calc having or in it - the app will auto concat all of these but the web will not.

All you results are the same so not sure what you want here.  Your statement is not written correctly either way really.  The app just let you cheat it.

If they are all the same result text then it should be written like

if(selected(${structure_type}, "B-85") or selected(${structure_type}, "B-85OP") or selected(${structure_type}, "B-90"), "34 ft 7 in", "")

If the values are diff you would use nested if statements.

if(selected(${structure_type}, "B-85"), "34 ft 7 in", if(selected(${structure_type}, "B-85OP"), "35 or something ft 7 in", if(selected(${structure_type}, "B-90"), "36 or something ft 7 in", etc)))

This would technically be more correct.

You could also try wrapping it all in a concat() but this may not work and give true/false since the way you wrote it that is what you are asking for.

Hope that helps.