I have the simplest formula to calculate Days Outstanding:
However, only works on Save or Recalculate....
How can I get it to refresh otherwise?
At the moment Sugar does not have a method for keeping calculated fields up-to-date, without manual intervention. We do have an open Enhancement Request to add automated functionality in the future: https://portal.sugarondemand.com/#supp_Bugs/75443
Advanced Support Engineer
Learning Resources: http://support.sugarcrm.com | http://university.sugarcrm.com | http://community.sugarcrm.com
Through formula yes, but by configuring a dependency setValue, whose trigger is always TRUE, it should work without big deal.
If you have ENT and a small - medium number of records that should be updated you can build an advanced workflow including a loop that updates a checkbox or something else on those records every 24h (wait event ^^) as long as a second criteria has been matched (like days until = 0)
Don't do this if this will produce too many running processes because this will slow down your server.
Retrieving data ...