Connecting information from columns from excel (contact list) to answer options. | XM Community
Skip to main content
Question

Connecting information from columns from excel (contact list) to answer options.

  • January 21, 2024
  • 3 replies
  • 94 views

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

Hello again,

I have an excel sheet with numerical information. I need to be able to connect information from the excel sheet to the answer options. The question is a slider type, and there will be three questions to which I would need to be able to connect information from one particular row from excel. The participant will then evaluate if they agree on scale 1-10.

  1. “Cats should eat X times a day Y times a week”
  2. ”On average cats live Z years”​​​​​​
  3. “Q people out of 100 have cats”

The excel sheet would have then columns with names ID, X, Y, Z, Q and there would be about 1000 rows with different values. How can I connect the information from rows to the question. So that there would be eventually “cats should eat 3 times a day 5 times a week” etc? I uploaded the excel as a contact list. I also should be able to record the ID to know from which row the information taken. Is there any way that the Qualtrics would assign a random number top the responded, this is not that serious how the ID number would be generated, just that there would be a possibility to know from which row the information is generated.

 

I hope I could explain my problem clearly. I am pretty new to Qualtrics.

 

Thank you so much in advance. 

 

 

 

3 replies

Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+34
  • Level 8 ●●●●●●●●
  • 654 replies
  • January 21, 2024

Assign id between number 100-1000 in the file and upload to contact list. In survey use random number pipe text feature to generate a random number between 100-1000. Use this number in authenticator to get values X, Y, Z and Q.


Forum|alt.badge.img+1
  • Author
  • Level 1 ●
  • 2 replies
  • January 29, 2024

Hi and thank you.

I tried this I can not make it work. I have the uploaded contact list with the id numbers and did the random number pipe text. I still cannot not figure out how to use this in the authenticator. I would like to hide the authenticator from the respondent.

Do you have any tips how to go forward with this problem?

 


Shashi
Level 8 ●●●●●●●●
Forum|alt.badge.img+34
  • Level 8 ●●●●●●●●
  • 654 replies
  • January 29, 2024

Hi and thank you.

I tried this I can not make it work. I have the uploaded contact list with the id numbers and did the random number pipe text. I still cannot not figure out how to use this in the authenticator. I would like to hide the authenticator from the respondent.

Do you have any tips how to go forward with this problem?

 

Please check this option to hide authenticator and authenticate.