topic return a boolean value (0 or 1) different than label in ArcGIS Survey123 Questions

return a boolean value (0 or 1) different than label

GregoireCatineau — Mon, 20 Dec 2021 10:43:02 GMT

Hello,

I would like to return a boolean value : 0 or 1 for a 'yes' or 'no' request.

I use text field type because apparently there are no boolean field type.

how to return a value different than the label field ?

0 for no

1 for yes

Re: return a boolean value (0 or 1) different than label

JavierCMartínezPrieto — Mon, 20 Dec 2021 13:17:07 GMT

Good,

if you use conditional expressions, the value becomes boolean.

greetings

url:https://doc.arcgis.com/es/survey123/desktop/create-surveys/xlsformformulas.htm

Re: return a boolean value (0 or 1) different than label

FrankOuyang — Mon, 20 Dec 2021 22:16:23 GMT

You can edit this in Survey123 Connect xlsx spreadsheet:

1. In you choice sheet, set the name for your yes label as 1 and no label's name as 0.

2. In the survey sheet, when people select yes, the record will be 1 and no will be 0. But these two fields are stored as text. What you can do is that, in the calculation field, set "number(${question})" which will then convert the submission into number.

Please let me know if this works and any further questions.

Re: return a boolean value (0 or 1) different than label

GregoireCatineau — Tue, 25 Jan 2022 11:19:50 GMT

Ok, thank you.