Hi Shane,

Thanks for clarifying, that helps a lot.

I think I have a solution that will work for your form, and it will save the poor picker a step!

I started by reproducing the table in your example, but I ended up not using the "Update Total" checkbox--it's just a vestige in my screenshots below.

First, you need to add the "weight" and "totalweight" CSS classes to you table columns:

You can add classes like so:

Use this code to make the form work:

$(document).ready(function() {  
  // Define and set initial totalWeight value to 0
  var totalWeight = 0;
  
  // Trigger calculation on focusout (ie, tabbing out of field)
  $('.weight').focusout(function() {
    
    // Take the value in the "Weight" column and add it to the value
    // of the totalWeight variable
    totalWeight += parseFloat($('.weight input').val());
    
    // Plug totalWeight value into "Total Weight" field
    $('.totalweight input').val(totalWeight.toFixed(2));
    
    // Clear the value in the "Weight" column
    $('.weight input').val('');
  });
});

The way this works is, the picker will type the weight into the the "Weight" column field. When the picker tabs or clicks out of the "Weight" column field, the number they just typed is cleared from that field and added to whatever number is in the "Total Weight" column field. So, the picker would type the first value, tab to the next field or click anywhere outside the "Weight" field, then would tab or click back into the "Weight" field to enter the next value. This saves the hassle of having to click the "Update" checkbox every time, too.

~Rob

That's awesome Rob, thank you, just one thing I found is if there are multiple rows and you add an amount to the first one it is adding it to Total weight in every row, is it possible to populate just that row? See attached

Thanks again for your help so far