topic Populate a field based on a previous Select_one in ArcGIS Survey123 Questions

Populate a field based on a previous Select_one

DaveK — Wed, 31 Mar 2021 14:31:28 GMT

Hello!

I'm creating a survey which contains a field to select a member within our department. I would like the next field to automatically populate with the email of the member selected in the previous question. I have my names and emails in my choices sheet currently. Would a choice filter selected() need to be created or pulldata() be used? I'm not sure of the proper way to set this up.

Thanks!

Re: Populate a field based on a previous Select_one

DougBrowning — Wed, 31 Mar 2021 19:37:04 GMT

Yes pulldata would be the way to go.

See here for great instructions https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata-function/ba-p/896889

But basically just like this. Put the csv file in the media folder.

pulldata(<csvfile>, <returnColumn>, <lookupColumn>, <lookupValue>)

Hope that helps