Hello!
The title of this is the general idea of what I want to do, but I understand that it isn’t very simple in Qualtrics. I have a 2x80 data set for rainfall levels by province in a country. The data set is a CSV organized by province name and a rainfall amount as a number. In the survey, respondents enter their province from a drop down list. Is it possible to have a question display the rainfall amount corresponding to the entered province without me having to enter the data by hand?
Best answer by Tom_1842
If I understand the question correctly, another approach you could take would be to use a Drilldown question type with 2 levels, hide the 2nd dropdown, and then add JavaScript to the question that will automatically select the top answer in the 2nd dropdown when a selection is made in the 1st. This will give you the province's corresponding rain amount for use in piping.
To give it a try, first create a CSV that has 2 columns: Province and Rainfall.
Then, create a Drilldown question and set the number of choices to 2. Click to add answers and then upload the CSV file to the question.
Next, add the below to the question's JavaScript in the OnReady section so that the 2nd dropdown automatically selects its 1st option when a selection is made in the 1st dropdown:
var qid = this.questionId;
var sel1 = document.getElementById('QR~'+qid+'~1');
var sel2 = document.getElementById('QR~'+qid+'~2');
jQuery(sel1).on('change', function() {
sel2.options[1].selected = true;
});Finally, add the below CSS to the Style section of the Look & Feel so that the 2nd dropdown is not displayed to the respondent.
div.Inner.BorderColor.DL > div > fieldset > div > table > tbody > tr:nth-child(2) {
display: none;
}Later in the survey, you can pipe in the 2nd dropdown selection/Rainfall amount by using the below, updating for your QID:
${q://QID1/ChoiceGroup/SelectedAnswers/2}
+20Hi
You can create the columns from the CSV file as embedded data in the survey flow in one SDS and later use API to send the data to the actual survey project and use the embedded data as pipe in in the questions.
Hello
+20Hi,
Yes let me tell you what I am doing in my project is
1)upload the CSV file having data in one SDS
2) Create Embedded data for all the columns
3) Created a workflow and call an API to transfer required columns from SDS to the survey project where I have all the questions defined
4) then use the column as pipe in in the survey questions.
Hope this resolves
+28If I understand the question correctly, another approach you could take would be to use a Drilldown question type with 2 levels, hide the 2nd dropdown, and then add JavaScript to the question that will automatically select the top answer in the 2nd dropdown when a selection is made in the 1st. This will give you the province's corresponding rain amount for use in piping.
To give it a try, first create a CSV that has 2 columns: Province and Rainfall.
Then, create a Drilldown question and set the number of choices to 2. Click to add answers and then upload the CSV file to the question.
Next, add the below to the question's JavaScript in the OnReady section so that the 2nd dropdown automatically selects its 1st option when a selection is made in the 1st dropdown:
var qid = this.questionId;
var sel1 = document.getElementById('QR~'+qid+'~1');
var sel2 = document.getElementById('QR~'+qid+'~2');
jQuery(sel1).on('change', function() {
sel2.options[1].selected = true;
});Finally, add the below CSS to the Style section of the Look & Feel so that the 2nd dropdown is not displayed to the respondent.
div.Inner.BorderColor.DL > div > fieldset > div > table > tbody > tr:nth-child(2) {
display: none;
}Later in the survey, you can pipe in the 2nd dropdown selection/Rainfall amount by using the below, updating for your QID:
${q://QID1/ChoiceGroup/SelectedAnswers/2}
Hi
+28Hi
var qid = this.questionId;
var sel1 = document.getElementById('QR~'+qid+'~1');
var sel2 = document.getElementById('QR~'+qid+'~2');
function getRndInteger(min, max) {
return Math.floor(Math.random() * (max - min + 1) ) + min;
}
var n = getRndInteger(1,80)
sel1.options[n].selected = true;
setTimeout(function () {
sel2.options[1].selected = true;
},500);
If I understand the question correctly, another approach you could take would be to use a Drilldown question type with 2 levels, hide the 2nd dropdown, and then add JavaScript to the question that will automatically select the top answer in the 2nd dropdown when a selection is made in the 1st. This will give you the province's corresponding rain amount for use in piping.
To give it a try, first create a CSV that has 2 columns: Province and Rainfall.
Then, create a Drilldown question and set the number of choices to 2. Click to add answers and then upload the CSV file to the question.
Next, add the below to the question's JavaScript in the OnReady section so that the 2nd dropdown automatically selects its 1st option when a selection is made in the 1st dropdown:
var qid = this.questionId;
var sel1 = document.getElementById('QR~'+qid+'~1');
var sel2 = document.getElementById('QR~'+qid+'~2');
jQuery(sel1).on('change', function() {
sel2.options[1].selected = true;
});Finally, add the below CSS to the Style section of the Look & Feel so that the 2nd dropdown is not displayed to the respondent.
div.Inner.BorderColor.DL > div > fieldset > div > table > tbody > tr:nth-child(2) {
display: none;
}Later in the survey, you can pipe in the 2nd dropdown selection/Rainfall amount by using the below, updating for your QID:
${q://QID1/ChoiceGroup/SelectedAnswers/2}
I am not sure what I might be doing wrong, but the drill down does not select sel2 variable. Is there somthing I am missing?
+28Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.