I have a field in my survey that is showing the information in the name column rather than the label column when the data is viewed in survey123 for ArcGIS, or exported from survey123 to AGOL.
There are other rows that are similar in the survey but are showing up correctly in the data tables when viewed in survey123 for ArcGIS.
Question 1. Does anyone know why this is happening?
Question 2. Is there a way to fix this problem?
Hi Garret
What question type are you using for the problem fields - are they select_one? If so, this is a known limitation.
It might be helpful if you share the survey and highlight the problem questions.
Thanks
John
Good morning Johnathan,
The question type is a “select one” question and directly below it in the survey is a similar question that displays properly.
Attached is the survey and the problem question (select_one dca_code) is highlighted in yellow. The problem is that when we view the submitted data in Survey123 for Arcgis or export it from there, that the column is populated with the information in the name column which is just a number, rather than the information in the label column which is the name of an insect or fungus.
Thanks for your help
Garret Dubois
Biological Science Technician
Forest Service
Alaska Region, S&PF Forest Health Protection
p: 907-374-3758
garretddubois@fs.fed.us<mailto:garretddubois@fs.fed.us>
3700 Airport Way
Fairbanks, AK 99709
www.fs.fed.us<http://www.fs.fed.us/>
<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>
Caring for the land and serving people
Hi Garret,
This is a known issue with select_one questions. The data itself is written as the name column and a domain is created to so that the labels seen in Survey123 will be seen in ArcGIS Online; in all but file geodatabase exports, ArcGIS Online provides the code (choice names) instead of labels. You can export the data with the labels via ArcGIS Desktop tools - see Problem: Coded value domain descriptions are not maintained after exporting data .
Hello,
Is there perhaps a fix for this by now? It is very vexing that some select_one questions (eg. Damage causing agent) show the value from the "name" column. Whilst most other select_one questions (eg. Host, Tree diameter, etc.) show the value from the "label" column. We want labels.
To make things even weirder, when I look at the individual response, "Damage causing agent" shows the path for the image that is in the choices list.
Any idea what is the cause and fix for these issues?
Thanks,
Lori
Hi Lorretta - can you share your survey?
I sent the .xls file via email because I couldn't figure out how to attach it here. But here are screen shot of what I mean. I thought I pasted them into the original email from earlier today, but now I notice they aren't there.
Here it is!
Thanks
Lori (Loretta) Winton, PhD
Forest Pathologist, SouthCentral & Interior Alaska
Forest Service
Forest Health Protection, R10 Alaska Region
p: 907-743-9460
f: 907-743-9479
lmwinton@fs.fed.us<mailto:lmwinton@fs.fed.us>
LTER
University of Alaska Fairbanks
193 Arctic Health Research Building
PO Box 756780
Fairbanks, AK 99775-6780
www.fs.usda.gov/main/r10/forest-grasslandhealth<http://www.fs.usda.gov/main/r10/forest-grasslandhealth>
www.fs.fed.us<http://www.fs.fed.us/>
<http://usda.gov/>[Forest Service Twitter]<https://twitter.com/forestservice>[USDA Facebook]<https://www.facebook.com/pages/US-Forest-Service/1431984283714112>
Caring for the land and serving people
Help! I also have this problem. It's not an issue of exporting, it is that when I look at the data in the hosted feature layer it is not showing the label. It is a select_one question, and it is not a cascading select. This is a huge problem for me - I had worked around it in a previous publishing of my Survey using a nested if, e.g. if(selected(${auditorid}, 'abcd1'),'Tom Jones', if(selected(${auditorid}, 'abcd2'),'Calvin Klein', if(selected(${auditorid}, 'abcd3'),'Tommy Hilfiger', if(selected(${auditorid}, 'abcd4'),'Peewee Herman',if(selected(${auditorid}, 'abcd5'),'Random Guy',if(selected(${auditorid}, 'abcd6'),'Strange Behavior','auditor name unknown')))))) .
That clumsy workaround made due for the initial publishing of my Survey, but now 40 auditors want to use it and even if I was willing to continue the workaround, Excel has a limit of 7 nested if functions. I'm supposed to add these new people next week... I didn't see an answer here in the conversation. If I'm missing it, apologies in advance.
Thanks, Shana
If this is of help to anyone else... when I upgraded Survey123 Connect and Survey123 field app to the latest version, it started saving the label again in my Feature Layer.