Tagged

Formula

Around 10% of records in the CONTACT object are failing to sync up a formula column. The local DB value remains NULL while the SFDC values exist.
Is there any condition where Formula or Lookup fields will not be refreshed or replicated accurately?
Thanks!

In the Salesforce API, changes in formula fields will NOT be flagged as changed records. Therefore, if you have formula fields on objects and only their value changes, the record will not be picked up by SF_Refresh. This is because the Salesforce API does not update the last modified date of that record for a formula field change.

When the SF_Replicate occurred, it did pick up the changes because it is a full backup of all the columns and data for that table. We recommend that you take this and revise your SF_Refresh/SF_Replicate schedule, if need be, to account for this.