Survey123 with some unique pre-populated fields, send to specific emails

[AmberTobin]

I have a survey that I want to send to 900 people. I want to pre-populate some of the information shown on the survey with information I have stored about each individual in my database, similar to a mail merge. I don’t want the other 899 users to be able to see information about other people nor do I want a drop-down list of 900 options. Ideally, I would like to pulldata from the feature service but can create a csv file to do it.

Simple Example. I want to survey 5 ice cream stands.

Here is the information I have on each stand and the questions I want to ask:

Stand ID	Owner Name	Owner Email	Q1 How many ice creams did you sell	Q2 How much was your cost	Q3 How much was your profit
1	Bob	bob@domain.com
2	Mary	mary@domain.com
3	Chris	chris@domain.com
4	Lisa	lisa@domain.com
5	Amy	amy@domain.com

In my survey I want to pre-populate the Stand ID and Owner Name and then send the survey to each Owner Email. Is this possible? If so how would I go about doing it?

Some things to keep in mind:

The Owner doesn’t know their Stand ID as it is unique to my database that they can’t see. However, I do want it shown on my survey.

I don’t want the Owners to know who else is being surveyed.

I want the survey to display unique information about the person.

[ZacharySutherby · Accepted solution]

Hello Amber Tobin‌, 

Please check out our Early Adopter Community as we just posted some Beta builds that automate CSV updating and introduce a workflow for working with Feature Service data in Survey123 Surveys. 

I am not sure if you intend on your survey to be taken in the Field App or through the Webform, but if you are planning on using the Survey123 Website you can use the Webform URL Parameters to populate the stand information. Also if you don't want those folks to know what is being passed through the Webform URL Parameters you can also encode the URL parameters.

Thank you, 

Zach

[AmberTobin]

Zach this is amazing! Thank you so much! After I read the Web form URL parameters blog I was able to put together a prototype that we are testing with a mail merge and it is looking promising!