SOLVED

Potential workaround for SFDC Formula Fields

Go to solution
Malik_Zafar2
Level 4

Potential workaround for SFDC Formula Fields

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
SanfordWhiteman
Level 10 - Community Moderator

Re: Potential workaround for SFDC Formula Fields

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.

View solution in original post

2 REPLIES 2
SanfordWhiteman
Level 10 - Community Moderator

Re: Potential workaround for SFDC Formula Fields

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.
Malik_Zafar2
Level 4

Re: Potential workaround for SFDC Formula Fields

Ah, makes sense. Thanks Sandford!

Tags (1)