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

[GrégoireCATINEAU]

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 

[JavierCMartínezPrieto]

Good,

if you use conditional expressions, the value becomes boolean.

greetings

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

[FrankOuyang · Accepted solution]

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. 

[GrégoireCATINEAU]

Ok, thank you.