Optimal Field Update Method

I currently have three forms/views.

Form1/View1: This contains global variables that certain users have access to change.
Form2/View2: This contains global constants that only me the administrator has access to change.

Form3 is where it gets a little interesting..
Form3/View3: The records associated with this form/view contain about 12 fields. Only field1,field2,field3 and field4 are set to visible on Form3. The rest of the fields (field5 to field12)are calculated as a function of Form3's field1, field2, field3, field4, Form1's global variables and Form2's global constants. They are calculated in the On Add>Validate scripting section of Form3.

So, when a global variable in Form1/View1 is modified, accordingly the field5 to field12 of ALL the records on View3 need to be updated accordingly.

Can someone with more database/creator experiece share with me how this should be possibly tackled?
Especially given that I also know that Zoho has a limit on the number of deluge operations that can be performed in a day or a script.

Currently, when any global variable is updated, I just delete all the records from View3 as the field values are not accurate any more and have my users re-enter the field1 to field4 in From3 as required. While View1 and View2 always have less that 10 records each, View3 can possibly grow to over 500 records.
This seems like pretty poor design and isnt optimal at all.

Previously, all of this was in a excel file. And when the global values were updated, so were the corresponding results.

Thanks for any help in advance.

Regards,
Nish
nfaria