Skip to main content
Topics#Sales CloudPregunta de Amin Ahcene
Amin Ahcene preguntó en #Sales Cloud
13 oct 2021, 21:33

validation rule

i wish to have the billing email filled to be able to save a record except for one user that shoud be able to save it regardless.

AND(  NOT(ISPICKVAL (Partner_Status__c, "Prospect")),  ISBLANK( Billing_eMail_Address__c ),  $User.Id = "0055Iknck001lwXHQAY"  )

 

Is the formula correct it does not seems to work?

 

Thanks in advance 

 

#Sales Cloud  #Service Cloud

3 respuestas
  1. Michael Brown (SETGO Partners) Forum Ambassador
    13 oct 2021, 22:06

    Hi Amin, 

     

    This current rule will only fire if the one user is the one making the change. You'll want to use the <> operator here so that the rule fires if the logged in user is not equal to that user. Also, I would try and reference their name, email, or another value instead of their Salesforce Id, as id's can change between orgs. 

     

    AND( 
    NOT(ISPICKVAL (Partner_Status__c, "Prospect")),
    ISBLANK( Billing_eMail_Address__c ),
    $User.FirstName <> "Mike"
    $User.LastName <> "Brown")

     

    Thanks,

    Mikey

Escribir una respuesta...
0/9000