Difference between revisions of "AutoSum numerical text grid"

From Catglobe Wiki
Jump to: navigation, search
Line 1: Line 1:
 +
<translate>
 
== Challenge  ==
 
== Challenge  ==
  
Line 61: Line 62:
 
== Source ==
 
== Source ==
 
Questionnaire Resource Id on cg.catglobe.com site: 164079 (Question: Q7_AutoSum_numerical_text_grid)
 
Questionnaire Resource Id on cg.catglobe.com site: 164079 (Question: Q7_AutoSum_numerical_text_grid)
 +
</translate>

Revision as of 08:53, 3 August 2017

Challenge

We need to sum numbers in a
Example

AutoSum.png

Solution

  • Create a text grid question
  • Add the below script to that question

Code

 1 var even = "even";
 2 var AddTotalRowToGrid = true;
 3 var UpdateSelfDefinedElement = false;
 4 
 5 function recalc() 
 6 {
 7    var tmpval;
 8    var tmpnumber = 0;
 9 
10    $("input:text").each(
11       function(i)
12       {
13          if ($(this).attr("name").indexOf("QUESTION.") == 0)
14          {
15             tmpval = $(this).val();
16             if(tmpval != "" && !isNaN(tmpval)) {
17                //DEBUGGING ALERT FOR GETTING THE ACTUAL VALUE
18                //alert("|" + parseInt(tmpval) + "|");
19                tmpnumber += parseInt(tmpval);
20             }
21          }
22       }
23    );
24    if(UpdateSelfDefinedElement)
25       $("#AUTOSUMSELFDEFINED").text("Sum Equals: " + tmpnumber);
26    if(AddTotalRowToGrid)
27       $("#AUTOSUM").text("Sum Equals: " + tmpnumber);
28 }
29 
30 quest.onInit = function()
31 {
32    $("input:text").each(
33 
34       function(i)
35       {
36          if ($(this).attr("name").indexOf("QUESTION.") == 0)
37          {
38             $(this).keyup(function(){recalc()});
39          }
40       }
41    );
42 
43    if(AddTotalRowToGrid) 
44    {
45       $(".grid_inner").append("<tr rowheight=\"12pt\"><td colspan=2 class=\"grid_subquestion_text grid_subquestion_" + even + "\" style=\"height: 20px;\"><p id=\"AUTOSUM\">Undefined</p></td></tr>");
46    }
47    recalc();
48 }

Source

Questionnaire Resource Id on cg.catglobe.com site: 164079 (Question: Q7_AutoSum_numerical_text_grid)