adobe form Calculations and totals

Hi @johnathan_1494,

Thanks again for reaching out!

Yes, it’s definitely possible to build a form with calculated totals using Acrobat or Acrobat Reader on a desktop, and you’re on the right track with your Qty * Unit structure.

Below is an enhanced example using JavaScript to calculate:

• Subtotals for each line item (Qty × Unit)

• A Grand Total by summing all line totals

Sample Field Setup:

Let’s say your fields are named like this:

• Qty1, Unit1 → result goes in LineTotal1

• Qty2, Unit2 → result goes in LineTotal2

• …and so on

• The grand total goes in a field called GrandTotal

JavaScript for Each Line Total (e.g., in LineTotal1 → Custom Calculation Script 😞

var qty = this.getField("Qty1").value;

var unit = this.getField("Unit1").value;

if (!isNaN(qty) && !isNaN(unit)) {

    event.value = qty * unit;

} else {

    event.value = 0;

}

Copy and adjust this for LineTotal2, LineTotal3, etc., changing the field names accordingly.

JavaScript for Grand Total (in GrandTotal → Custom Calculation Script 😞

var total = 0;

for (var i = 1; i <= 5; i++) { // Adjust 5 to however many line items you have

    var line = this.getField("LineTotal" + i);

    if (line && !isNaN(line.value)) {

        total += Number(line.value);

    }

}

event.value = total;

This script will sum all the LineTotal fields and display the result in the GrandTotal.

⚠️ Important Notes:

• JavaScript runs only in Acrobat or Reader on desktop — it won’t work in most browsers or preview apps.

• Ensure users download and open the form with Acrobat or Reader.

• Saving the form locally is required for full functionality.

• Mobile apps have limited support for JavaScript.

• For broader access or signature workflows, consider using Acrobat Sign Web Forms.

Wait for more inputs from experts.