Calculate price based on fillable field

Question

Hello,Apologies, I know this is a very basic question but I cannot figure out the correct syntax for the Custom Calculation Script needed to generate the total cost in my form (I just got Acrobat Pro today).I am having the user fill in the QTY field and then I am trying to set the TOTAL field to calculate cost by multiplying QTY by the price of $29. I would have thought it was simple, like writing out a formula in Excel, but it doesn't seem to work that way and I cannot find any resources on Adobe.com or online that point me in the right direction. Any assistance anyone can offer would be greatly appreciated.

George_Johnson · Accepted Answer

It might be easier to use the simplified field notation option, in which case you'd enter:

29 * QTY

If you want to use a custom calculation script, it could be something like:

// Custom calculation script for a text field

(function () {

// Get the quantity value, as a number

var qty = +getField("QTY").value;

// Calculate this field's value if the quantity is greater than 0

if (qty > 0) {

event.value = util.printf("%.2f", 29 * qty); // round to nearest cent

} else {

event.value = ""; // Blank this field

}

})();

So this option gives you more flexibility. allowing you to round and blank the field. You can also do additional checking to make sure the quantity makes sense (e.g., a positive integer within a certain range) You'll find more information in the Acrobat JavaScript reference, and here's a link to an introductory tutorial about setting up calculations in PDF forms: https://acrobatusers.com/tutorials/how-to-do-not-so-simple-form-calculations

Be sure to set any calculated fields to read-only so the user doesn't attempt to interact with them.

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