Hey,
I have a question in which its rows will display based on whether a the sum total of the responses from two other questions adds up to less than 10 billion. Due to the fact that I have a complex Table of Contents, it will not allow be to add an embedded data field just before the block of this last question, which leads me to believe I need to use JavaScript in order to do this.
I have tried the following, but it doesn't work, as it doesn't update the embedded data field to the calculation.
Any help would be greatly appreciated - I have zero JavaScript knowledge!
Thanks,
Luke
Qualtrics.SurveyEngine.addOnload(function()
{
//Set new Active Module, hide buttons on empty page and automatically go to next page.
//This is because the embedded data works after the ToC creation, so needs a loading question to update it.
//REQUIRES a page break after this question.
//GATHER ALL VALUES INTO ONE PLACE
answerArrayOO4 = ["${q://QID4/ChoiceNumericEntryValue/1}"];
answerArrayOO5LEInt = ["${q://QID29/ChoiceNumericEntryValue/1/1}"];
answerArrayOO5LEExt = ["${q://QID29/ChoiceNumericEntryValue/28/1}"];
answerArrayOO5FIInt = ["${q://QID29/ChoiceNumericEntryValue/29/1}"];
answerArrayOO5FIExt = ["${q://QID29/ChoiceNumericEntryValue/30/1}"];
answerArrayOO5PEInt = ["${q://QID29/ChoiceNumericEntryValue/31/1}"];
answerArrayOO5PEExt = ["${q://QID29/ChoiceNumericEntryValue/32/1}"];
answerArrayOO5REInt = ["${q://QID29/ChoiceNumericEntryValue/33/1}"];
answerArrayOO5REExt = ["${q://QID29/ChoiceNumericEntryValue/34/1}"];
answerArrayOO5INFInt = ["${q://QID29/ChoiceNumericEntryValue/35/1}"];
answerArrayOO5INFExt = ["${q://QID29/ChoiceNumericEntryValue/36/1}"];
answerArrayOO5HFInt = ["${q://QID29/ChoiceNumericEntryValue/37/1}"];
answerArrayOO5HFExt = ["${q://QID29/ChoiceNumericEntryValue/38/1}"];
//CREATE VARIABLES
var i = 1;
var x = answerArrayOO4[i-1];
var yLEInt = answerArrayOO5LEInt[i-1];
var yLEext = answerArrayOO5LEInt[i-1];
var yFIint = answerArrayOO5LEInt[i-1];
var yFIext = answerArrayOO5LEInt[i-1];
var yPEint = answerArrayOO5LEInt[i-1];
var yPEext = answerArrayOO5LEInt[i-1];
var yREint = answerArrayOO5LEInt[i-1];
var yREext = answerArrayOO5LEInt[i-1];
var yINFint = answerArrayOO5LEInt[i-1];
var yINFext = answerArrayOO5LEInt[i-1];
var yHFint = answerArrayOO5LEInt[i-1];
var yHFext = answerArrayOO5LEInt[i-1];
//SUM TOGETHER
var sumLEint = [(x/100)*yLEint];
var sumLEext = [(x/100)*yLEext];
var sumFIint = [(x/100)*yFIint];
var sumFIext = [(x/100)*yFIext];
var sumPEint = [(x/100)*yPEint];
var sumPEext = [(x/100)*yPEext];
var sumREint = [(x/100)*yREint];
var sumREext = [(x/100)*yREext];
var sumINFint = [(x/100)*yINFint];
var sumINFext = [(x/100)*yINFext];
var sumHFint = [(x/100)*yHFint];
var sumHFext = [(x/100)*yHFext];
//LE
Qualtrics.SurveyEngine.setEmbeddedData("Int_LE_USD", sumLEint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_LE_USD", sumLEext);
//FI
Qualtrics.SurveyEngine.setEmbeddedData("Int_FI_USD", sumFIint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_FI_USD", sumFIext);
//PE
Qualtrics.SurveyEngine.setEmbeddedData("Int_PE_USD", sumPEint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_PE_USD", sumPEext);
//RE
Qualtrics.SurveyEngine.setEmbeddedData("Int_RE_USD", sumREint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_RE_USD", sumREext);
//INF
Qualtrics.SurveyEngine.setEmbeddedData("Int_INF_USD", sumINFint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_INF_USD", sumINFext);
//HF
Qualtrics.SurveyEngine.setEmbeddedData("Int_HF_USD", sumHFint);
Qualtrics.SurveyEngine.setEmbeddedData("Ext_HFI_USD", sumHFext);
jQuery("#PreviousButton, #NextButton").css("visibility","hidden");
this.clickNextButton()
});
Qualtrics.SurveyEngine.addOnReady(function()
{
/*Place your JavaScript here to run when the page is fully displayed*/
});
Qualtrics.SurveyEngine.addOnUnload(function()
{
/*Place your JavaScript here to run when the page is unloaded*/
});
How do you calculate a sum from two different fields and set as embedded data in Qualtrics?
Sign up
Already have an account? Login
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login to the Community
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join.
No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Login with Qualtrics
Welcome! To join the Qualtrics Experience Community, log in with your existing Qualtrics credentials below.
Confirm your username, share a bit about yourself, Once your account has been approved by our admins then you're ready to explore and connect .
Free trial account? No problem. Log in with your trial credentials to join. No free trial account? No problem! Register here
Already a member? Hi and welcome back! We're glad you're here 🙂
You will see the Qualtrics login page briefly before being taken to the Experience Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
