Populate a field based on a previous Select_one

DaveK

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!

dougbrowning

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