If I have modified a formula or rollup field such that the returned values change on a given record, it doesn't update the record's
systemmodstamp, since the record itself hasn't been edited.
Is there any trick I could use to force an update to
systemmodstamp when a formula or rollup is changed, but only on records where the resulting value has changed?
(The reason I'm asking is that we have an external data warehouse connected via API, that wants to stay up to date on changed records. It uses a query based on
systemmodstamp to refresh itself periodically, but ends up missing changes that are due to formula/rollup edits)