Hi, I am looking for a way to retain both the text name of a field select_one choice, as well as the geopoint information for the choice.
I'm using the 'Calculations on Geopoints' method in my xlsform, which uses geopoints in the name column.
The fields in the xlsform look like the below:
My choices list for the fields look like this:
I am wanting to have my survey output datasheet include the label somehow, so that I can make charts on the Dashboard using the text label names (e.g. Site A, Building 1 etc). However obviously since the name column is what is shown in the output datasheet, all I see in the datasheet is the geopoint information.
Is there a way to set up a separate hidden field somehow to pull the labels rather than the name?