Populate a field based on a previous Select_one

300
1
Jump to solution
03-31-2021 07:31 AM
DaveK
by
Occasional Contributor

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!

Tags (2)
1 Solution

Accepted Solutions
DougBrowning
MVP Notable Contributor

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

View solution in original post

1 Reply
DougBrowning
MVP Notable Contributor

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