Skip to main content
DvAML2024
DvAML2024
Participant
March 16, 2018
Answered

Custom calculation scripts for fillable PDF

  • March 16, 2018
  • 2 replies
  • 5254 views

Need help with this. Been googling for the last couple of hours and I just decided its easier to just post here.

I have created a fillable PDF, which is fine. But I am trying to make it easier for people to fill out when it comes to totals.

I have Quantity, Price, Discount and Net columns. I want the Net column to auto fill based on the Quantity times Price minus the Discount (I can get this to work in excel using =B1*(1-C1)*A1 which works fine) But I am clueless how to make this work in this. I don't know if it needs to be javascript or the Adobe scripting language.

I do have the Discount column set to type percentage and a custom validation script of "if (event.value !== "") {event.value = event.value / 100 ;}" so that is stops that weird value of 30 becomes 3000%

Help???

This topic has been closed for replies.
Correct answer try67

So under the Calculation tab of Net1, in the Simple Field Notation option, enter the following:

Qty1 * Price1 * (100-Dis1)

2 replies

C
CousinsS
Participant
April 11, 2024

does anyone know what the custom calculation script is for "Linear Feet x $3.00 flat rate" is to get a total dollar amount for adobe acrobat pro

 

 

try67
Community Expert
try67Community Expert
Community Expert
March 16, 2018

You can use a very similar formula to the Excel one if you use the Simple Field Notation section of the Calculate tab.

What are the actual field names in your file, though?

PS. That "weird value" is so that you could use the percentage value in calculations directly, by the way. The way you're doing it will require you to change it back to a value between 0 and 1 later on...

DvAML2024
DvAML2024Author
Participant
March 16, 2018

Because this is a multi-line form, the fields are Qty1, Price1, Dis1 and Net1 (down to 8)

I changed the "weird value" as I wanted the people filling out the form to be able to just use 30 for 30% and not having to put in 0.03% or whatever it is.

try67
Community Expert
try67Community ExpertCorrect answer
Community Expert
March 16, 2018

So under the Calculation tab of Net1, in the Simple Field Notation option, enter the following:

Qty1 * Price1 * (100-Dis1)

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices