Is there a way to auto-populate in Survey123?

[RobCahalan]

I have a question for a bird species common name. I want to populate the scientific name based on the common name. I have a choices table (image below). In my survey I have a question for common name which returns the spp_comm label. I want to have the spp_sci label returned in a subsequent question.

I was able to use the choice filter which returns a single choice but I would rather return a value than have to click a single choice.

[IsmaelChivite · Accepted solution]

Hi. At first sight, it looks to me like a good approach would be to use the pulldata function. To learn more about pulldata I recommend you read this blog post: https://community.esri.com/groups/survey123/blog/2016/10/27/the-pulldata-function-access-external-da...   Essentially, pulldata allows you to do a lookup table search so when someone selects a species by its common name, you can lookup the scientific name and display it in a Note or Text question.

[IsmaelChivite]

I created an example to illustrate how this could work for you. I have attached a couple of files to this message. You can use them as follows:

1. Open Survey123 Connect for ArcGIS and create a new survey from the attached PullDataExample.xlsx file
2. Once you can preview the survey in Connect, copy all the contents of the attached media.zip file into the media folder of your survey's directory
3. Refresh the preview so your survey picks up the lookup table and  images within the media folder.

Here what you should get:

If you would like to add your own list of species, all you need to do is to edit the lookup CSV table in the media folder. Looking at the XLS file you will realize that adding your own images is pretty easy as well. All you need to do is to add images in the media folder and reference them from the choices worksheet.

[RobCahalan]

Thanks for the fast response Ismael! This works perfect!!