Have you considered updating to forms 10.1 where you can use the inherent Forms Calculations instead of JS to provide this functionality?

Attached is a form Template as an example for you, just rename the file from .txt to .xml to be able to import into your Form as a Business Process.

Includes Calc for the Total and an IF statement for the Tax as per the picture you had posted.

I have used the formula for Line Total:   "=PRODUCT( INDEX(Purchases.Qty,ROW()) , INDEX(Purchases.Unit_Price,ROW()) )".

The formula works OK but it gives the Line Total the Quantity value when only the Quantity is set.  This cascades down to the Total Amount.  I have set Qty and Price to 'Required' but it still looks a bit odd.

Also I have been using the formula for Line Total:

"= INDEX(Line_Items.Qty,ROW()) * INDEX(Line_Items.Price,ROW())"

but this will show an error at the Line Total as soon as the Quantity is entered as it is trying to multiply a value by a blank field.  I will address this in another post.

Thanks again for your help.

Hi Peter, yes, if you use ×, /, etc you may see errors when the formula are incomplete, its how they have implemwnted the error correct, but if you use the other formulas such as Product(var1,var2) or DIV (var1,var2) they work correctly.

Yes, the formulas do calculate on the fly, some people chose to put default values in the fields (ie:0) or move the Qty field next to the prixe so it is filled in after the text, just symantics but some prefer it that way.

I did not like the defaults as they can add extra keystrokes for the user.

I have now set the total fields to "hidden" until the Qty and Price have values > 1.

Your code formats the result to two decimal places, which is a reason for using Javascript instead of a Laserfiche formula to calculate the total. In order to make your javascript work after a line has been deleted, add a line that says:

  $('.itemsAUD').on('click', linetotal);

Your complete script will then be:

$(document).ready(function () {


  $('.itemsAUD').on('blur', 'input', linetotal);
  $('.itemsAUD').on('click', linetotal);

    function linetotal() {
        var sum = 0;
        $('.cf-table-block tbody tr').each(function () {
            var s = 0;
            s = parseNumber($(this).find('.qty input').val()) * parseNumber($(this).find('.unitprice input').val());
            $(this).find('.linetotal input').val(s.toFixed(2));
            sum += s;
       });

        $(".total input").val(sum.toFixed(2));

    }
  
    function parseNumber(n) {
        var f = parseFloat(n);
        return isNaN(f) ? 0 : f;
    }
});