Skip to main content
Topics#Data ManagementPregunta de Andi Keep
Andi Keep (FTS Inc.) preguntó en #Data Management
25 may 2018, 22:25

Help with validation rule using $Profile.Name

Hi

 

As an Administrator, I should be able to save a record with the following VR, but it still triggers the error message:

 

AND (

 

  ISPICKVAL(StageName, "Closed Won"),

 

  $Profile.Name <> "System Administrator"),

 

    OR (

 

      ISBLANK(TEXT( example_picklist_1__c )),

 

      ISBLANK(TEXT( example_picklist_2__c )),

 

      ISBLANK(TEXT( example_picklist_2__c )))

 

)

 

I wonder if I have the AND/OR functions written corretly?

 

Thanks
4 respuestas
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    26 may 2018, 06:59

    +1 Alagu Did you try this = 

    AND(
        ISPICKVAL(StageName, "Closed Won"),
        $Profile.Name <> "System Administrator",
        OR(
            ISBLANK(TEXT(example_picklist_1__c)),
            ISBLANK(TEXT(example_picklist_2__c)),
            ISBLANK(TEXT(example_picklist_2__c))
        )
    )

     

    I honestly think there is NO need to write 3 Validation Rules
Escribir una respuesta...
0/9000