Skip to main content
Topics#Data ManagementOSF Digital's Question
OSF Digital (OSF Digital) asked in #Data Management
Jun 8, 2021, 10:17 PM

Help with Case Status Validation Rule

Trying to write a validation rule that will prevent Cases from being progressed out of "New" or "Escalated " Status unless the case has been assigned to another user, or just any other user than this particular queue. 

 

This rule needs to apply to only one record type. 

 

SF is telling me that I'm missing a "(" but I think there's something else going wrong. Is there a Validation wiz out there that can help enlighten me? 

 

Thanks

 

AND(

 

 (Owner:Queue.DeveloperName = "Outbound_Sales_Queue"),

 

 (RecordTypeId = "0122j000000CgftAAC"), 

 

 OR(ISPICKVAL(Case.Status, "New")

 

(ISPICKVAL(Case.Status, "Escalated")))
2 answers
  1. Keiji Otsubo
    Jun 8, 2021, 10:21 PM
    Hi Georgi,

     

    Try this

     

    AND(

     

    Owner:Queue.DeveloperName = "Outbound_Sales_Queue",

     

    RecordTypeId = "0122j000000CgftAAC", 

     

    OR(

     

    ISPICKVAL(Case.Status, "New"),

     

    ISPICKVAL(Case.Status, "Escalated")

     

    )

     

    )

     

    I think that Id will not work unless it is 15 digits.
Write an answer...
0/9000