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

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. 

 

 

 

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.

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?

 

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.

Leave a Reply


Terms & Conditions