Skip to main content
Topics#Data ManagementFrage von Stefanie Stafford
Stefanie Stafford (Independent Contractor) fragte in #Data Management
8. Juni 2017, 22:55

"does not contain" formula with AND statements

Need help with whether this reads correctly in adding 1 piece of criteria to the end of my existing workflow to exclude the workflow from firing if the Last Modified By Alias = a specific user.

 

AND( 

 

INCLUDES 

 

(Classification__c, "Certified ShellacPro" ) && 

 

ISCHANGED( ReCertification_Date__c ) && 

 

NOT(ISBLANK( ReCertification_Date__c )), 

 

NOT(CONTAINS( LastModifiedBy.Alias, "jolas")) 

 

)

 

The bold formula is my existing workflow.
2 Antworten
  1. Steve Molis (You Owe Me a Beer, Inc.)
    8. Juni 2017, 23:55
    Actually after re-reading your post there's a few more changes...  

     

    Your Formula is evaluating a few fields using an ISCHANGED Function, but the LastModifiedBy field will not be updated with the ID (and Alias) until after Database Commit 

     

    KNOWLEDGE ARTICLE

     

    Process order for automation rules and Apex triggers 

     

    https://help.salesforce.com/articleView?id=000005694&type=1&language=en_US

     

    I think you need to use $User instead

    AND( 
    INCLUDES(Classification__c, "Certified ShellacPro" ), 
    ISCHANGED( ReCertification_Date__c ), 
    NOT(ISBLANK( ReCertification_Date__c )), 
    $User.Alias <> "jolas"
    )

     

     
Antwort schreiben...
0/9000