Survey123 Name field displaying instead of label field in my data
Hi all,
When I submit a survey form, it seems that my name field is being displayed rather than the label field in my survey123 data. While this kind of makes sense, is there any way to change this? The drop downs in my survey displays the label however, when it submits and also goes to the web map, the data and pop-ups display the ugly name values.
The weird part is when I click the record in my data (shown in the first picture below), the panel to the right displays what I want. I can go in and manually change this however, so many records come in at once for me to be able to handle it all.
Below picture: (name column is in the middle and the label column is to the right)
Anything helps, thanks!
Accepted Solutions
Hi. If the Survey123 select_one question has an associated geodatabase domain, you will see the label in both the Survey123 website as well as in other ArcGIS apps. If there is no geodatabase domain associated to the question, then you will see the name, except if Survey123 renders the form.
Survey123 automatically creates a domain for select_one questions, except if you use a choice filter. For example:
For the country question you will see always labels because a domain will be created. The actual value stored in the database is the country code, but you will see the label because the domain does the mapping of values to labels across all ArcGIS apps.
The cities question is different, because it has a choice_filter. Select_one questions with choice filters typically have many choices, so Survey123 will not create a domain (large domains in ArcGIS can be problematic). For this reason, you will see the name rather than the label, except if you use the Survey123 web or field apps to display the data.
Understanding all the above, you can do the following to store the label:
1- Add a new calculate column and use the jr:choice-name function to extract the label
2- Optionally set the select_one field type to null so the code is not stored in the database
Attaching the XLSFile so you can see the whole thing.
Hi. If the Survey123 select_one question has an associated geodatabase domain, you will see the label in both the Survey123 website as well as in other ArcGIS apps. If there is no geodatabase domain associated to the question, then you will see the name, except if Survey123 renders the form.
Survey123 automatically creates a domain for select_one questions, except if you use a choice filter. For example:
For the country question you will see always labels because a domain will be created. The actual value stored in the database is the country code, but you will see the label because the domain does the mapping of values to labels across all ArcGIS apps.
The cities question is different, because it has a choice_filter. Select_one questions with choice filters typically have many choices, so Survey123 will not create a domain (large domains in ArcGIS can be problematic). For this reason, you will see the name rather than the label, except if you use the Survey123 web or field apps to display the data.
Understanding all the above, you can do the following to store the label:
1- Add a new calculate column and use the jr:choice-name function to extract the label
2- Optionally set the select_one field type to null so the code is not stored in the database
Attaching the XLSFile so you can see the whole thing.
