Survey 123 Multiple Choice Field Results for Narrative Use

Idea created by asxantos on Apr 23, 2019
    New
    Score90
    • katie.baskett@dc.gov_dcgis
    • rberry58
    • tracy.cahill_DOH
    • ting.ma_DDOT
    • estern
    • johncodd
    • asxantos
    • DCGISgroup
    • Joanne2
    I am suggesting a better approach to how survey results deals with multiple choice questions in feature layers hosted in ArcGIS Online. The display issue with Survey123 is how it handles multiple-choice questions. Survey123 uses XLSforms and creates set coded valuesEach answer choice is appended as comma separated values within the attribution. It does not allow special characters and therefore uses underscores (rather than 'space'). This is by design for Survey123 dashboard analysis, but it presents an issue when trying to use the attributes as a narrative in other ArcGIS template apps. Example, if I want to display {multiplechoicefield} in a details panel of Operations Dashboard. Or display {multiplechoicefield} in a story map. See image example of survey multiple choice > schema > table result. The name column specifies value; label is just the field alias. I realize I could do a one-time field calculation, or repeated manual, but can I automate? I do not know. There is a work-around but it is really a round-about way to get this: Calculate Hidden Fields to Remove Underscores. Again, I am asking for a better solution to how survey results could provide an additional "narrative/label" field for multiple choice questions.