Collating answers from 'Other' selection to another attribute field

dwold

I tried following this post but have not found success with what I am trying to accomplish. What I am trying to get my survey to do is when a user selects Other and types in their response, I would like for that  'Other'response to be populated in the Indicator field rather than in IndicatorOther field. Is this possible? I have attached my table.

Is it possible to populate the IndicatorOther to Indicator?

 

@CarmelConnolly 

@IsmaelChivite 

@JamesTedrick

@DougBrowning 

 

CLSS Indicator Survey.xlsx

MK13_1-1726591906893.png

ClayDonaldsonSWCA

Here is how I would handle this scenario:

1. Change name of the select_one question to "Indicator_Holding"
2. Set the bind::esri:fieldType to "null". This tells survey123 to not submit data in this row.
3. Change "IndicatorCollated" to "Indicator"
4. Update any instances of ${Indicator} to ${Indicator_Holding}
5. Results - Indicator field contains either the indicator holding or the indicator other value. no extra columns needed in the db.

You could also set IndicatorOther esri field type to null, to further clean up the database.