Potential workaround for SFDC Formula Fields | Community
Skip to main content
M
mzzee
New Participant
May 19, 2021
Solved

Potential workaround for SFDC Formula Fields

  • May 19, 2021
  • 1 reply
  • 2348 views

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

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SanfordWhiteman
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.

1 reply

SanfordWhiteman
SanfordWhitemanAccepted solution
New Participant
May 19, 2021
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.
M
mzzeeAuthor
New Participant
May 19, 2021

Ah, makes sense. Thanks Sandford!

    Terms & ConditionsAccessibility statement

    Loading footer...