Survey123 Name field displaying instead of label field in my data

303
4
Jump to solution
05-05-2021 07:29 AM
SummerlynBingaman
New Contributor II

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.

SummerlynBingaman_0-1620224761966.png

Below picture: (name column is in the middle and the label column is to the right)

SummerlynBingaman_1-1620224856033.png

 

Anything helps, thanks!

 

1 Solution

Accepted Solutions
IsmaelChivite
Esri Frequent Contributor

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:

IsmaelChivite_0-1620230011552.png

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.

View solution in original post

4 Replies
AllisonHollier
New Contributor II

Can't wait to hear the answer to this.  I'm following!  I've had the same issue when pulling feature reports.  I'm pulling the absolute value ($clsegname) in the title of my form and of course, I'm getting the name (variable) and not the label.  But that's not what I want, I want the nice little list item label.

0 Kudos
IsmaelChivite
Esri Frequent Contributor

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:

IsmaelChivite_0-1620230011552.png

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.

View solution in original post

SummerlynBingaman
New Contributor II

Thank you Ismael!!!

0 Kudos
AllisonHollier
New Contributor II

Most helpful, thank you!

 

0 Kudos