Collating answers from 'Other' selection to another attribute field

594
3
Jump to solution
03-28-2023 08:01 AM
dwold
by
Occasional Contributor II

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.

pic1.pngpic2.png

Is it possible to populate the IndicatorOther to Indicator?

 

@CarmelConnolly 

@IsmaelChivite 

@JamesTedrick

@DougBrowning 

 

1 Solution

Accepted Solutions
ClayDonaldsonSWCA
Occasional Contributor II

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.

ClayDonaldsonSWCA_1-1680017352920.png

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

 

View solution in original post

3 Replies
ClayDonaldsonSWCA
Occasional Contributor II

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.

ClayDonaldsonSWCA_1-1680017352920.png

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

 

dwold
by
Occasional Contributor II

@ZacharySutherby you helped me on my last post, any suggestions here? 😃

0 Kudos
DougBrowning
MVP Esteemed Contributor

The 3 fields trick posted above is the way to do it.