Potential workaround for SFDC Formula Fields

Question

Hello 
So we know that formula field updates in SFDC don't trigger the SystemModStamp, which means these fields won't update regularly and oftentimes require a manual sync.
 
Would the following solution work?
 
1) Field 1 is updated on Account object
2) Formula Field referencing Field 1 is updated with same value on lead object
3) Using a process builder, we take the value in the Formula Field and copy it to a static field

Would this work? Sounds like the static field should trigger a SystemModStamp

SanfordWhiteman · Accepted Answer

Sure, that'll work fine. But I wouldn't do it with a dedicated field. Instead, have a datetime field that you can use for any such purpose. Update it to the current timestamp when you want to force a sync.

Sign up

Login with SSO

Login to the community

Login with SSO