How to add survey #1 response ID generated by Qualtrics ({"ImportId":"_recordId"}) to survey #2 data? | XM Community
Skip to main content
Question

How to add survey #1 response ID generated by Qualtrics ({"ImportId":"_recordId"}) to survey #2 data?


Forum|alt.badge.img+2
  • Level 1 ●
  • 3 replies

Question 1: Is the response ID generated by Qualtrics ({"ImportId":"_recordId"}) a unique ID?

Question 2: For a longitudinal study, Survey #1 was designed to obtain consent and collect first/last names, e-mail addresses, phone numbers, workplace names. The actual survey begins in survey #2. We do not want to move the personally identifiable data between surveys. We would rather either create a unique ID or use the response ID generated by Qualtrics (["ImportId":"_recordId") for survey #1 and move it to survey #2 as a new column. Is that possible?

14 replies

Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 12, 2023

Hi @Foruz , 
The ResponseID is an unique ID and is generated once the survey is completed. If there is a ResponseID against any person and then you upload that data into another survey then it would generate a new ResponseID. 


Forum|alt.badge.img+2
  • Author
  • Level 1 ●
  • 3 replies
  • July 12, 2023

Hi @Naman_Savla , Thank you for your response. We understand that the survey #2 will generate its own response ID. But the main question is if we can move survey # 1 response ID to survey #2 as a new data labelled “Unique ID”  in order to identify who took survey #2.

 

Also, if that doesn’t work, is there a way to create a unique ID which is not the personally identifiable data that connect two surveys?


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 12, 2023
  • If you use the Response ID from Survey 1 and then store it as a another field to use in second survey then how would you distribute the survey? Because how would we know that who is the person for whom the correct Response ID should be used?

    If you are distributing the survey by email then you can use the unique id in the link parameter for each individual so that you have the details of unique id as well as the survey response. 

Forum|alt.badge.img+2
  • Author
  • Level 1 ●
  • 3 replies
  • July 12, 2023

The public will receive the anonymous link for survey #1, which will redirect them to survey #2. 


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 12, 2023

This is the solution which can be done :- 

  • Anonymous link of Survey 1 is sent
  • The person fill the survey and Response ID can be stored in a new field or email can be used as an unique id
  • Then on Survey 1 you can create a XM directory workflow to distribute the survey and add the details like email and the new field of response id and select the second survey to distribute. To distribute this email address would be required. 
  • The person receives and email to take the second survey and once the person fills the survey the data of new field of response id would be stored with the response given by person

Please let me know if this helps.


Forum|alt.badge.img+2
  • Author
  • Level 1 ●
  • 3 replies
  • July 12, 2023

We appreciate you taking the time to provide us with a solution.

Unfortunately, this isn't suitable for our use case because we don't want to distribute survey #2 via email. Redirecting it immediately after survey #1 is the only way to avoid delays.


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 12, 2023

Hi @Foruz 

Another option could be:-

  • In survey 1 create an embedded data (ResponseID) at the start of the survey. 
  • After completion run a workflow with Task as Email Task
  • The email message should survey 2 url appended with response id of survey 1. 
  • Eg :- www.qualtrics.com/form/SV_12314414?uid=${e://Field/ResponseID}.
  • This will send survey 2 to that person.
  • In survey 2, you can create an embeddedd data “uid” which will capture the ResponseID from URL

Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 12, 2023

Hi @Foruz ,

You can use the survey 2 link in redirect:- 
Eg:-
http://www.qualtrics.com/form/SV_12314414?uid=${e://Field/ResponseID}

 

 


Mannila
Level 4 ●●●●
Forum|alt.badge.img+13
  • Level 4 ●●●●
  • 39 replies
  • July 12, 2023

@Naman_Savla - Hi, Will the solution #2 provided above still be sending an email to the participants with link to survey #2? 

 


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 13, 2023

Hi @Mannila , Yes if we follow the approach of solution 2 then it would send an email to participants.

If want to send survey through redirect URL then we would not need to use the approach 2.


Mannila
Level 4 ●●●●
Forum|alt.badge.img+13
  • Level 4 ●●●●
  • 39 replies
  • July 13, 2023

Yes, we do want to send the survey through redirect URL but unfortunately we are unable to find a way to send “response ID” from survey #1 to survey #2 while following this survey structure. Let us know otherwise.


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 13, 2023

@Mannila 
 You need to add an embedded data “uid”(or the parameter which you define in the redirect url) in the survey flow of Survey 2 which will capture the Response ID from the redirect survey url.


Mannila
Level 4 ●●●●
Forum|alt.badge.img+13
  • Level 4 ●●●●
  • 39 replies
  • July 13, 2023

Thank you very much. Would you be able to share any instructions or resources on how to accomplish this? That would be greatly appreciated.


Naman_Savla
QPN Level 4 ●●●●
Forum|alt.badge.img+9
  • QPN Level 4 ●●●●
  • 37 replies
  • July 13, 2023

@Mannila 

Here is the solution:- 

 

For redirect URL:-

  1. On Survey 1 add a redirect URL at the end of the survey. 
  2. The URL should contain the anonymous link and at the end of the link append the parameter. (eg. www.qualtrics.com/surveyid?uid=${e://Field/ResponseID}), where uid is a field which will be used in Survey 2 as an embedded to capture the ResponseID received from the response of Survey 1.
  3. In Survey 2 go to the workflow and at the very top before the questions block add the embedded data eg. “uid” as shown in below image.
  4. Then once the respondent takes the first survey he would automatically be redirected to the Survey 2 and the uid field will be populated with the ResponseID of Survey 1 which can be viewed in the data & analysis.

 

Please let me know if this helps. 

 


Leave a Reply