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
Solved! Go to 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.
Good,
if you use conditional expressions, the value becomes boolean.
greetings
url:https://doc.arcgis.com/es/survey123/desktop/create-surveys/xlsformformulas.htm
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.
Ok, thank you.