Script to update calculated fields

Question

Hi everyone, 
 Can anyone share a script to update calculated fields for a particular module please? 
 Thank you in advance

Tony Romano · Answer

Come to think of it, back in v6.x it was possible to set 
 $bean->update_date_ modified = false; 
 $bean->update_ modified _by = false; 
 before saving the bean to preserve the modified by and modified date. 
 I think that still works. You would need to test it. 
 In that case you could add a checkbox to track which records were reprocessed. 
 Then write a nightly scheduler to retrieve the beans for each of the non processed records via SugarQuery (excluding those where your checkbox tracking field is set). For each bean found set those two variables above to keep the modified date/modified by from being modified and set the tracking checkbox, then save. The save action would perform the calculation, the checkbox would track that you processed that record so you can excluded from the rest round in your SugarQuery. 
 Once you are done reprocessing them all, you can remove the checkbox field. 
 The other option is as Jeroen Somhorst suggested, instead of using the bean, reproduce the formula's calculations in code and save the results using a SQL statement which does not trigger any additional logic. 
 Francesca