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

Forum|Forum|2 years ago
April 24, 2024
3 replies
1107 views

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?

This topic is closed to new replies. Start a new post to keep the conversation going.

try67

Community Expert

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();

P

PiazzaLawAuthor

Participant

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!

My_Formulas.pdf

Desired_State.pdf

try67

Community Expert

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.

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.