How to get the option "label" instead of the "name" in submissions sheet

Support
1

1. What is the issue? Please be detailed.
Is it possible to get the options chosen in select type questions to be submitted as the "labels" instead of the "name".

Example: What is the property use? "Tertiary Institution" (the label) is chosen when filling the form but in the submissions spreadsheet the name "tertiary_institution" is used.

Is there anyway i can get the label in the submissions sheet

4. Upload any test forms or screenshots below.

odk
odk1096×502 27.2 KB

2

See the section in the docs on jr:choice-name() within form operators and functions.

You can use it with a calculate type question to get the label of the selected option: choice-name-example.xlsx (9.8 KB)

1 Like