Skip to main content
Topics#Data ManagementAndi Keep의 질문
Andi Keep (FTS Inc.) 님이 #Data Management에 질문했습니다
2018년 5월 25일 오후 10: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개
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2018년 5월 26일 오전 6: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
답변을 작성하세요...
0/9000