Creating on click, visable maths calculations within a matrix table | XM Community
Skip to main content
Michael_Cooksey
Administrator
22 days ago
Solved

Creating on click, visable maths calculations within a matrix table

  • September 12, 2018
  • 5 replies
  • 57 views
R
Hi all, I'm trying to do maths calculations on click so that they appear in the matrix table as below using JavaScript. I also need to restrict the user to not be able to enter anything into the calculation fields. Has anyone done anything similar before and have any code as a starting point? ! Thanks, Rose

Best answer by mattr51

Hi Rose, This is the solution I came up with - should also take care of and NaN errors by defaulting these values to 0. Qualtrics.SurveyEngine.addOnReady(function() { this.questionclick = function(event,element){ var i =0; /*Setting column number for loopage*/ while (i<6){ var a = parseInt(this.getChoiceValue(2,i),10); var b = parseInt(this.getChoiceValue(3,i),10); /*default NaN to 0 */ if(isNaN(a)){ a= 0; } if(isNaN(b)){ b= 0; } var x = a+b ; /*Set Value*/ this.setChoiceValue (4,i,x); var y = parseInt(this.getChoiceValue(5,i),10)/parseInt(this.getChoiceValue(4,i),10); if(isNaN(y)){ /*check if div by 0*/ y = 0; } /*Set Value*/ this.setChoiceValue (6,i,y); /*Increase column number*/ i++; }} });
View original

    5 replies

    PeeyushBansal
    Level 6 ●●●●●●
    Forum|alt.badge.img+39
    • PeeyushBansal
    • Level 6 ●●●●●●
    • 1144 replies
    • September 12, 2018
    Hi @rose_b Please read this post it may help you to write code https://www.qualtrics.com/community/discussion/926/side-by-side-question-constant-sum-and-auto-complete-dropdown
    Best Regards, Peeyush
    NiC
    1 person likes this
    • NiC
      NiC
    LaurenK
    Former XM Community Team Member
    Forum|alt.badge.img+13
    • LaurenK
    • Former XM Community Team Member
    • 900 replies
    • September 12, 2018
    Hi @rose_b! It looks like you may be asking about custom programming/code. We actually have a Developer Corner in the community that is reserved for these types of questions. Therefore, I have gone ahead and moved your question to that section so coders and programmers are more likely to answer your question. P.S. They might assume that you already have a basic knowledge of programming and how to integrate it into Qualtrics. If you do not, we recommend checking out W3Schools and our pages on Adding Custom CSS and Adding JavaScript to get a basic understanding!
    A
    • Anonymous
    • 0 replies
    • September 13, 2018
    Hello @rose_b , The following code will work for Matrix table-> Test Entry, short (rows and column same as the image in the question) Also in the validation type option of the question, select "content validation" -> "number" Paste the following code in the js(onReady) of matrix question for(var i=4;i<=8;i++){ jQuery(".ChoiceRow:eq(3) td.c"+i+" input").prop("disabled",true); jQuery(".ChoiceRow:eq(5) td.c"+i+" input").prop("disabled",true); } this.questionclick = function(event,element){ jQuery(".ChoiceRow:eq(3) td.c4 input").val(parseInt(parseInt(jQuery(".ChoiceRow:eq(1) td.c4 input").val())+parseInt(jQuery(".ChoiceRow:eq(2) td.c4 input").val()))||0); jQuery(".ChoiceRow:eq(5) td.c4 input").val((parseInt(jQuery(".ChoiceRow:eq(4) td.c4 input").val())/parseInt(jQuery(".ChoiceRow:eq(3) td.c4 input").val()))||0); jQuery(".ChoiceRow:eq(3) td.c5 input").val(parseInt(parseInt(jQuery(".ChoiceRow:eq(1) td.c5 input").val())+parseInt(jQuery(".ChoiceRow:eq(2) td.c5 input").val()))||0); jQuery(".ChoiceRow:eq(5) td.c5 input").val((parseInt(jQuery(".ChoiceRow:eq(4) td.c5 input").val())/parseInt(jQuery(".ChoiceRow:eq(3) td.c5 input").val()))||0); jQuery(".ChoiceRow:eq(3) td.c6 input").val(parseInt(parseInt(jQuery(".ChoiceRow:eq(1) td.c6 input").val())+parseInt(jQuery(".ChoiceRow:eq(2) td.c6 input").val()))||0); jQuery(".ChoiceRow:eq(5) td.c6 input").val((parseInt(jQuery(".ChoiceRow:eq(4) td.c6 input").val())/parseInt(jQuery(".ChoiceRow:eq(3) td.c6 input").val()))||0); jQuery(".ChoiceRow:eq(3) td.c7 input").val(parseInt(parseInt(jQuery(".ChoiceRow:eq(1) td.c7 input").val())+parseInt(jQuery(".ChoiceRow:eq(2) td.c7 input").val()))||0); jQuery(".ChoiceRow:eq(5) td.c7 input").val((parseInt(jQuery(".ChoiceRow:eq(4) td.c7 input").val())/parseInt(jQuery(".ChoiceRow:eq(3) td.c7 input").val()))||0); jQuery(".ChoiceRow:eq(3) td.c8 input").val(parseInt(parseInt(jQuery(".ChoiceRow:eq(1) td.c8 input").val())+parseInt(jQuery(".ChoiceRow:eq(2) td.c8 input").val()))||0); jQuery(".ChoiceRow:eq(5) td.c8 input").val((parseInt(jQuery(".ChoiceRow:eq(4) td.c8 input").val())/parseInt(jQuery(".ChoiceRow:eq(3) td.c8 input").val()))||0); };
    M
    Forum|alt.badge.img
    • mattr51
    • 1 reply
    • Answer
    • September 13, 2018
    Hi Rose, This is the solution I came up with - should also take care of and NaN errors by defaulting these values to 0. Qualtrics.SurveyEngine.addOnReady(function() { this.questionclick = function(event,element){ var i =0; /*Setting column number for loopage*/ while (i<6){ var a = parseInt(this.getChoiceValue(2,i),10); var b = parseInt(this.getChoiceValue(3,i),10); /*default NaN to 0 */ if(isNaN(a)){ a= 0; } if(isNaN(b)){ b= 0; } var x = a+b ; /*Set Value*/ this.setChoiceValue (4,i,x); var y = parseInt(this.getChoiceValue(5,i),10)/parseInt(this.getChoiceValue(4,i),10); if(isNaN(y)){ /*check if div by 0*/ y = 0; } /*Set Value*/ this.setChoiceValue (6,i,y); /*Increase column number*/ i++; }} });
    R
    1 person likes this
    • R
      rose_b
    R
    • rose_b
    • Author
    • 4 replies
    • September 13, 2018
    Thanks everyone for your help! Thank you @mattr51 - that did the job!

    Leave a Reply


    Terms & Conditions