Skip to main content
A
AutoCalcHelp
Participating Frequently
June 4, 2020
Question

Fillable Form Running Slow Due to Calculations

  • June 4, 2020
  • 3 replies
  • 2887 views

I have a fillable form with roughly 100 fillable fields.  Out of those fields, 18 fields contain calculated values (averages).  The form is running extremely slow when switching between fields even if the current field is not involved in any of the calculations.  Sometimes it takes 7 seconds to switch between fields.  This obviously wont work with a form that contains 100 fields.  

 

If "Automatically calculate field values is turned off" the form works like it should with no lag time when switching fields.  Is there any way to force all of the calculations to happen at the same time so that automatic calculation can be turned off and there wont be lag time when each field is filled. 

 

Is there another option for speeding up the file?  I'm not familair with coding in javascript.  

    This topic has been closed for replies.

    3 replies

    A
    AutoCalcHelpAuthor
    Participating Frequently
    September 16, 2020

    I'm still having issues with adding calculations to my form documents.  Every one has the same issue with running slowly when autocalculate is enabled.  Any help would be appreciated. 

    try67
    Community Expert
    try67Community Expert
    Community Expert
    June 4, 2020

    Each time you change the value of any field in a file it triggers the calculation for all the fields in it, even if they have nothing to do with the field you changed. However, 18 calculated fields is not a lot at all, so that suggests to me there might be some other issue there. Forms with hundreds of calculated fields usually suffer from lags, yes, not to have issues with 18 fields is not usual.

    A
    AutoCalcHelpAuthor
    Participating Frequently
    June 4, 2020

    I was thinking the calculations were the issue because the lag issues stopped when the automatic calculation was turned off.  What else could be causing the issue?  Many of the fields have formating rules to ensure the numbers have the correct amount of digits behind the decimal.  Would that slow the file?

    try67
    Community Expert
    try67Community Expert
    Community Expert
    June 4, 2020

    Yes, that's probably the issue, but the question is why is it happening.
    What kind of calculations did you add? Did you use any scripts? If so, what's their code?

    Can you maybe share the actual file with us?

    Bernd Alheit
    Community Expert
    Bernd AlheitCommunity Expert
    Community Expert
    June 4, 2020

    You can add a button for the calculation.

    BarlaeDC
    Community Expert
    BarlaeDCCommunity Expert
    Community Expert
    June 4, 2020

    HI,

     

    If you move you calculation to a Document Javascript, this makes it callable from each form field, you could then move your calculation to the validation step of your fields, the advantage of doing this is that the validation only runs when the field you are editing is included in the calculation, meaning the calculation might change, but not when any other field is change. This might help, although if it is a large calculation then Bernd Suggestion above would be the way to go.

     

    Regards

    Malcolm

    A
    AutoCalcHelpAuthor
    Participating Frequently
    June 4, 2020

    Thank you for the reply, Malcolm.  I'm a bit of a novice when it comes to creating these forms and I have no experience with writing in javacsript. 

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