Replication and formula fields in Salesforce

salesforce
#1

How does replication work with formula fields in Salesforce?

#2

“Updates” displayed within formula fields in Salesforce don’t result in the source record’s SystemModstamp value being modified, so Stitch is generally not able to capture changes reflected in a formula field unless the record is modified with a traditional update as well.

We have a full guide to how Stitch interacts with formula fields available here, and we generally recommend recreating the formula using SQL in your destination, or modifying the field in your source Salesforce instance to be a native Salesforce field if possible.

1 Like