Skip to main content
Topics#Customer ServicePergunta de Launa Saunders
Launa Saunders (Open to work) perguntou em #Customer Service
6 de jun. de 2011, 16:49

Validation rule based on User ID

We are on Professional Edition so I am unable to create a validation rule based on profile, so I must rely on user id since only 2 people have permissions to close certain cases. 

 

I need the rule to state that only the two user id's indicated have the ability to close a case if the case sub-reason is either option 1 or option 2. I created it, and it blocks the users from closing cases with this information (including myself), however, the two people with the user ids that are in the formula are also not able to close the case (so essentially no one is able to close the cases).

 

Here is what I have so far:

 

AND(

 

ISPICKVAL(Status,"Closed"), 

 

OR(

 

  ISPICKVAL( Case_Sub_Reason__c ,"Option 1"),

 

  ISPICKVAL( Case_Sub_Reason__c ,"Option2")),

 

    OR(

 

    $User.Id <> "00540000000leyp",

 

    $User.Id <>"00540000001RA2M"),

 

)

4 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    6 de jun. de 2011, 20:08
    Here you go (I was missing a paren)

     

    I would double-check the spelling and punctuation of the Sub Reason values in your VR (they need to match exactly) 

     

    AND(

    $

    User.Id

    <> "00540000000leyp",

    $

    User.Id

    <> "00540000001RA2M"

    ISPICKVAL(Status,"Closed"),  

    OR(

    ISPICKVAL(Case_Sub_Reason__c ,"Option 1"),

    ISPICKVAL(Case_Sub_Reason__c ,"Option 2")))

Escrever uma resposta...
0/9000