Under Review
over 1 year ago

Scheduled Job which triggers recalculation of SugarLogic fields

A common scenario is to design a SugarLogic field which contains a date reference relative to today, e.g. an "Age" field which is derived from the contact's DOB. There are many scenarios where this happens more frequently than annually - e.g. here's a monthly example: https://sugarclub.sugarcrm.com/dev-club/f/questions-answers/3998/problem-with-calculated-fields-updating-automatically. I've seen plenty of others which are weekly or more.

Due to SugarLogic only being recalculated upon the ListView trigger/save of records, this can make these fields out of date quickly.

It would be ideal to have:

  • A nightly scheduled job which could trigger recalculation of SugarLogic fields
  • An admin page to configure which modules/records are recalculated, and frequency if less than daily.
  • Yes It is really required feature for most of the people using Calculated fields and which needs to be updated frequently. If Sugar Comes with default Scheduler it really helps a lot. Thanks Adam for putting this in Product Suggestions.