Custom calculation scripts for fillable PDF

[DvAML2024]

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???

[try67]

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]

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 · Accepted solution]

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

Qty1 * Price1 * (100-Dis1)

[DvAML2024]

I was confused, but with some editing and some help from Google and Excel I made it do what I need it to do.

Thank you so much for the pointers.

[Sarel36676010whho]

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