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 · Accepted solution]

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-fu...

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

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

Hope that helps