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

Is there a way to manually calculate field values with calculations?

New Here ,
Apr 24, 2024 Apr 24, 2024

Copy link to clipboard

Copied

So I have a form that I need to fill out, I use sums and it works just fine.  However, it is so incredibly slow, I have to put in dozens of values and it recalculates every time.  So I turn off "Automatically calculate field values" in "Forms" in options and it goes super fast, which is great.  The problem is I can find a way to tell it to run my calcluations once the form is complete.  I have to go back in, turn the option on, then modify a field twice so that the first set of calculations run and then the calculations based on those calculations run.  Excel just has a "Calculate Now" button.  Does anything like that Exist in Acrobat?

TOPICS
PDF , PDF forms

Views

147

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 ,
Apr 24, 2024 Apr 24, 2024

Copy link to clipboard

Copied

Dozens of calculated fields is not that many. I've had forms with hundreds of such fields and it worked quite fast.

If you're having such issues it could indicate there's a problem with how you set up your calculations.

But yes, you can disable the calculations from within the file itself and trigger them when a button is clicked.

To do the former add this code to a doc-level script:

this.calculate = false;

To do the latter add this code to your button's Mouse Up event:

this.calculateNow();

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 24, 2024 Apr 24, 2024

Copy link to clipboard

Copied

You are right.  My calculations are probably pretty bad seeing as how I'm an idiot public defender and my programming skills are limited to "Hello World" in BASIC that I learned 30+ years ago.

 

Maybe you (or someone) can help me find a more efficient way of doing it.  Basically, there's 40 lines where I need to put my hours in.  My hours are either Out of Court, In Court Pretrial, or In Court Other.  For each line I need to sum the two in court hours and put them in a box and then sum all 3 sets of hours and put them in another box.  Then, in the final line, I need to sum all the boxes from the 40 lines.

 

Finally, on the first page, I need to take the final line's number from out of court and put it in one box, and then the in court in another box, multiply them both by a rate, and finally sum those two boxes, and then 3 fee boxes.  It might make more sense if you look at it.  I've attached one called My Formulas which have my formulas (where I can't even do half of what I want but you can kinda see how I did).  The other one is called Desired State which is just the blank form then I scanned in and wrote, in pen, what I am hoping to do.  Maybe it's not feasible and I'll just have to try to figure out the suggestion you have above (I know next to nothing about scripts or how to handle them).

 

If there's just a way of doing this without sacrificing speed, even if you can give me an idea or link me to something, I'm happy to try to figure it out, not asking anyone to do anything for me.  I'm just really not good with programming.

 

Thanks for the response though!

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 ,
Apr 25, 2024 Apr 25, 2024

Copy link to clipboard

Copied

LATEST

I'm happy to set it all up for you, for a small fee. If you're interested feel free to contact me privately to discuss it further.

I have to tell you, though, that I'm not seeing any speed issues in the calculations in the file you shared. It works instantaneously for me.

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