Calculating order form total column using Javascript

Question

HiApologies, I know nothing about Javascript.I have an order form in Acrobat that I need to calculate a total with Goods and Services Tax (GST) attached image.Staff members enter quantity (QTY) and unit price (UNITPRICE). They then choose Y or N to whether the unit price is inclusive of GST.So, therefore the TOTAL column needs to calculateIf GST = YThen multiply QTY by UNITPRICEElse multiply QTY by (UNITPRICE*1.1)I know that I need to use javascript with a IF and THEN statements in the 'Custom Calculation Script' section, just not sure how to script it. ThanksMichael

PDF Automation Station · Accepted Answer

Assume your check boxes are named "GST" (name them identically, but set the export values in the options tab to 1 for No and 1.1 for Yes. At the top of the Total field calculation tab select Value is the product of and select the 3 fields. The calculation will take the unchecked boxes as zero so it will calculate to zero until the user checks whether there is GST or not. If you don't want a zero value when the GST boxes are not checked, use the following custom calculation script instead:

var gst=1;

if(this.getField("GST").value!="Off")

{gst=this.getField("GST").value}

event.value=this.getField("QTY").value * this.getField("UNITPRICE").value*gst;

If you want to modify the script above once, so you don't have to modify for each Total field you can enter a script that antipates what the field names will be when you create all the rows from the first row using Right-click>Create multiple copies. This article explains exactly how to do it, with video.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded