topic Re: Adding integers for a select One from list type question giving error in ArcGIS Survey123 Questions

Adding integers for a select One from list type question giving error

RachelS — Tue, 11 Jul 2023 11:06:22 GMT

Hi,

I have 6 select from one list type question where the possible answer is +1 or -1. I then want to add the answers from these. But rather than adding the integers in a calculation it just adds a 1 into the sum box. e.g. -1111.

If I try setting the bindType field to Int then it says Error converting XLS form.

I'd appreciate any help.

Thanks

Rachel

Re: Adding integers for a select One from list type question giving error

MobiusSnake — Tue, 11 Jul 2023 12:01:59 GMT

Your calculate line is missing a few dollar signs. You've got them for the first couple variables but they're missing after that. I just tried bringing your XLSX into S123 Connect, set the binding on that last question to Integer and inserted the dollar signs and it looks all good.

Re: Adding integers for a select One from list type question giving error

RachelS — Tue, 11 Jul 2023 12:40:07 GMT

Ah thanks @MobiusSnake , I'd updated the dollar signs but didn't update the xls sheet.

I've attached the xls with the updates you mentioned but the calculation still doesn't work for me.

I'm on version 3.18.123.

Here's what I get below.

Re: Adding integers for a select One from list type question giving error

PanGIS — Tue, 11 Jul 2023 14:16:34 GMT

Hi @RachelS

I noticed the missing dollars and I added myself.

the calculation works for me, I just added the dollars.

( I have forgotten to upgrade 😅 and I am using connect 3.16.110)

Re: Adding integers for a select One from list type question giving error

MobiusSnake — Tue, 11 Jul 2023 14:57:33 GMT

From what I can see, it looks like issues will occur if any of the questions aren't completed, but as long as all six questions are completed, the value comes out okay. One option would be to change your calculation to this:

number(${stonefly1})+number(${mayfly1})+number(${caddisfly1})+number(${snail1})+number(${leech1})+number(${waterlouse1})

This will result in the calculation failing (and showing nothing) until all six questions are completed, since the number() function will fail on missing values.

If these questions are all mandatory that should work, if they're optional then I think you'll need to include some if() functions.

Re: Adding integers for a select One from list type question giving error

RachelS — Mon, 17 Jul 2023 08:37:00 GMT

Hi @MobiusSnake ,

Thanks for that, I'm just going to force the user to complete all the questions.

Regards

Rachel