Sum a Column from a Custom Table

Ever needed to sum the input to a textbox column on a Custom Table?*

This script is increadibly easy to add to your survey. The output is displayed to the respondent below the Custom Table.

Check it out in an example survey!

Put the script to work!

1.  Add a custom table question to your survey. Include a Textbox question as one of the column headers.

2. Click Add New Action, select JavaScript. Copy and paste the code below into the action:

$(document).ready(function(){
  
  //change this to your column header (case sensitive)
  var columnHeader = "Hours";
  var totalMessage = "Your total hours are:";
  
  
  //don't change below here!
  $("input[title='" + columnHeader + "']").last().after("<br><br>" + totalMessage + " <span class='total'>0</span>");
  
  $("input[title='" + columnHeader + "']").blur(function(){
    var sum = 0;
    $("input[title='" + columnHeader + "']").each(function(){
      var each = $(this).val()*1;
      console.log(each);
      sum += each;
      $(".total").text(sum);
    });
  });
});

3. Customize the variables. You will need to change "Hours" to the name of the column header for the Textbox Column in the Custom Table question. and "Your total hours are:" to the message you wish to display below the column.

4. Save and test the script.

*This script does not record the summed value for reference later.