Formula columns and Roll up summary fields are not synching from Salesforce to Heroku

[sekhars2019]

Required Terms

• I agree to follow this project's Code of Conduct
• I have read and accept the Salesforce Program Agreement

What service(s) is this request for?

Heroku Connect Sync

Tell us about what you're trying to solve. What challenges are you facing?

Cross-Object Formula and Roll-Up Summary Fields are synced with Heroku.

Salesforce calculates formula fields at query-time and can use other fields, functions, and literal values. They can also refer to fields in parent objects via master-detail or lookup relationships. However, this can cause problems when Heroku Connect is synchronizing data.

Formula fields are automatically calculated, read-only on record detail pages, and don’t update last modified date fields. Changes to formula fields that are driven by a change in a parent object don’t update the SystemModStamp of the child object. This means that Heroku Connect doesn’t synchronize the object.

For example:

The Contact object has a formula field called name_formula__c that refers to the Name field of the related parent Account object.
The Name field on an Account record is updated.
The updated value of name_formula__c is returned when the related Contact record is queried.
The SystemModStamp of the Contact record isn’t updated so the new name_formula__c value isn’t synchronized to the Heroku Postgres database.

Please fix this on priority, otherwise no point of Heroku if data is not available in Heroku, it's impacting seriously as data is not same in Salesforce and in Heroku, data discrepancies between systems and other downstream systems using Heroku Data.

[shiladityab24]

This is a big issue, yet

Calculated fields (Formula and Roll-up fields) in Salesforce may not always update system fields like SystemModstamp and LastModifiedAt. As a result, while data may sync successfully during the initial load, it might not remain synchronized afterward. This can cause discrepancies in ongoing data synchronization. Also Calculating roll-up summary field values can take up to 30 minutes