New
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.