Troubleshooting Salesforce Formula Field Real-Time Sync Failures
Platform Event records are not generated when the Formula field in the Salesforce Work Order object depends on fields from related objects rather than those from the field set defined for the object. Even in cases where the Formula field is updated when the related object record changes, a Platform Event record is not generated.
For example, when a formula field named Demo_Event_Subject__c (SVMXC__Company__r.Name) in a Work Order record is updated because the Name field value in the linked Account record is modified, the Demo_Event_Subject__c field in the Work Order record is updated. However, even in cases where the Demo_Event_Subject__c field is included in the Field Set for the Work Order object, and is updated when the related Account record is modified, Platform Event record generation is not triggered.
Solution
Use the
_fixed_modified_fields function to include the field in the payload for subsequent updates. This ensures that even though the field is not included in the
Modified Fields section, it is still synced to
Service Board. For more information, see
Configuring Real-Time Sync for Only Modified Work Order Fields.
For more information: