My organization conducts a survey twice a year (January and July). We would like to be able to pipe in the respondents' prior answers to see if there have been changes. For example.
"In January, you answered your CEO made $123456 a year as of January 1, 2020. What does the CEO make as of July 1, 2020?"
"In January, you answered your CFO made $78901 a year as of January 1, 2020. What does the CFO make as of July 1, 2020?"
Where 123456 and 78901 are piped text or values from an Excel sheet (which itself was generated by the January answers).
Is there a way to do this?
Thanks!
Piping in answers from prior survey responses
Userlevel 7
+30
Hi KIS_Analyst ,
Yes, this can be done by downloading the data from the January survey and merging it with your contact list for the July survey. Then add Embedded Data fields in the Survey Flow of the July survey for each column you want to pipe into your questions. Finally, for each questions you're piping data into, use the Pipe Text feature in call the appropriate Embedded Data field.
Userlevel 7
+38
For future surveys where you want such features, consider looking at the Contact List Trigger feature (to create the external Excel sheet you are referring to).
MatthewM has the right approach for a survey that wasn't set up this way. You may find this help page useful for setting up the necessary Embedded Data fields. But I more strongly recommend this section on creating Embedded data fields from a contact list, it should save you time and avoid human error of mistyping a variable name. If you will need to compare fields, make sure they are the right type (defaults to text but your examples suggest you may want your numeric variables so you can create logic that says if salary increased/decreased).
Leave a Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.