nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Display a select_one label in a Report template

Trippetoe

Greetings. In my survey i have a select_one question where the answers are populated via 'autocomplete search()' functionality. The 'name' value, that is the 'id' of the selected answer, is being stored in the survey's feature class as the actual answer to the question. The 'label' value of the selected answer is stored in the Survey as a calculated field but its esri:fieldType is 'null' so i think it's value is not kept when the survey is submitted.

Is there a way to get that 'label' value for display in the survey Report template. The 'id' value won't mean anything to Report readers; only the 'label' will.

Thank you

Vind meer berichten getagd met

Accepted answers

All comments

Neal_t_k

@Trippetoe Is your id field in your feature layer have a coded domain? I wonder if jr:choice-name() would work, it couldn't hurt to try? Then you would just have to update the label for the domain in your feature layer

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-xlsform-functions/ba-p/893567

or maybe if you just setup a domain for that field, this appears to say it pulls in the label instead of the name unless specified.

https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereport-choice.htm

Neal_t_k

If you are doing python and stored your label, you could just set a script to periodically iterate trough your id column and update your label column based on your master list.

Trippetoe

Thanks for the link. I've been looking for something like that.

There are a couple hundred sites so that may not be an efficient approach for this problem. I'm looking at other programmatic python based pdf report generators now. The Survey123 Report generator just may not be the right tool for this situation.

Neal_t_k

In that case you might be able to employ some conditional statements in the report to accomplish what you want, but that may cause similar headaches to the ones you mention above depending on the size of your list in that you would still have to update the template when labels change.

https://doc.arcgis.com/en/survey123/browser/analyze-results/featurereport-conditionalelements.htm

Trippetoe

Hey @Neal_t_k Thanks for your super fast response.

Agreed that just storing the label value is the easiest for reporting. The reason it's not my preferred approach is that currently i am storing the 'id' value which can never change whereas the 'label' value can and does change. The data is the 'location' where the work was done - its id value wont/cant change based on company 'business rules'. However the name of the site can change. It doesn't happen often, but it does happen. In those cases, i'd have to go back thru all the previously submitted records and change the location label value. So, it's a classic data maintenance and QA/QC reason for not storing the 'label'

Neal_t_k

Any reason why you can't just store the label value, and pull that into the report? That is probably your easiest solution.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.