• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

Custom calculation scripts for fillable PDF

New Here ,
Mar 16, 2018 Mar 16, 2018

Copy link to clipboard

Copied

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

TOPICS
PDF forms

Views

4.5K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Community Expert , Mar 16, 2018 Mar 16, 2018

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

Qty1 * Price1 * (100-Dis1)

Votes

Translate

Translate
Community Expert ,
Mar 16, 2018 Mar 16, 2018

Copy link to clipboard

Copied

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

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 16, 2018 Mar 16, 2018

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 16, 2018 Mar 16, 2018

Copy link to clipboard

Copied

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

Qty1 * Price1 * (100-Dis1)

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Mar 16, 2018 Mar 16, 2018

Copy link to clipboard

Copied

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.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Apr 11, 2024 Apr 11, 2024

Copy link to clipboard

Copied

LATEST

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

 

 

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines