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.
You can add a button for the calculation.
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.
How can I do that? I know how to add a button, but I dont know how to make that button perform the calculation function. Could a single button perform all calculations at once?
You can use all calculations at the button.
How is that done?
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.
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?
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?
Calculations are all simple addition and averages. I havent used scripts because I do not know how to code.
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.