function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Chris McKaughanChris McKaughan 

Workflow formula rule will only run when record is edited, not created

Hello,

So I have a workflow rule that runs fine when the record is edited but will not run at all when it is created. The criteria is that it runs when the record id is not equal to NULL.

User-added image

The field update formula is:

CASE(Size_Code__c,
"S", CASE(Tier__c, 
             1, 595,
             2,655,
             3, 945,
             0),
"M", CASE(Tier__c, 
             1, 835,
             2,835,
             3, 1405,
             0),
"L", CASE(Tier__c, 
             1, 1125,
             2,1305,
             3, 2025,
             NULL),
"XL", CASE(Tier__c, 
             1, 1555,
             2,1835,
             3, 2910,
             0),
"XXL", CASE(Tier__c, 
             1, 2225,
             2,2385,
             3, 4525,
             0),
0)

Any thoughs would be appreciated!

Chris
Nayana KNayana K
Try using rule criteria  when 'formula evaluates to true ' instead of 'crieterias met'. :
OR(ISNEW(),<here you place cross object bundle id field api name> != NULL)
Chris McKaughanChris McKaughan
Thanks Nayana. Tried your suggestion but the results were the same. Rule doesn't run on creation but does when the record is edited.
Nayana KNayana K
Set evaluation criteria to created and eveytime edited. And see the behaviour once.
Chris McKaughanChris McKaughan
Tried that as well Nayana, and still no luck. Works on edit still.
Nayana KNayana K
This is so weired!
Nayana KNayana K
Check debug logs and examinewhether workflow fired or something else is happening.