Populate a text field from choices list

746
2
Jump to solution
01-09-2023 06:22 PM
AlexSteiner
New Contributor II

Hello,

Is it possible to automatically populate a text field from an item on a list on the choices tab, based on an earlier selection?
I can utilize the choice filter to yield only one option, but the user still has to select that option.
I would like to have that one option entered into a text field.

I could use a calculation, but the choice list is long and therefore the calculation formula would become quite long, and updating the formula would be one more step when adding or deleting items from that list, and would introduce more opportunity for error.

Automatically entering the choice into a text field is the cleanest and most efficient way to accomplish what is needed in the form.

Thank you for your help!

 

0 Kudos
1 Solution

Accepted Solutions
ChristopherCounsell
MVP Regular Contributor

Assume you have something like if selected value is A, return '1' in the new row? then B returns 2?

You can create a csv table and have the value pull the data from the matching value in the csv table. This is known as pulldata.

https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata/ba...

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F35...

The CSV can be published with the survey via the media folder and updated the same way.
Or you can publish the CSV to ArcGIS Online as a csv item and then connect it to the survey (useful if your values change frequently and you want to update the csv without republishing the survey).

 

View solution in original post

0 Kudos
2 Replies
ChristopherCounsell
MVP Regular Contributor

Assume you have something like if selected value is A, return '1' in the new row? then B returns 2?

You can create a csv table and have the value pull the data from the matching value in the csv table. This is known as pulldata.

https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata/ba...

https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F35...

The CSV can be published with the survey via the media folder and updated the same way.
Or you can publish the CSV to ArcGIS Online as a csv item and then connect it to the survey (useful if your values change frequently and you want to update the csv without republishing the survey).

 

0 Kudos
AlexSteiner
New Contributor II

Thank you for your reply and pointing me to the pulldata functionality. Not only did this resolve the original challenge I was having, about which I posted, but external tables also opened up my surveys' flexibility to address a number of other challenges. Those articles were extremely  helpful. Thank you!!!

0 Kudos