Skip to main content
Topics#Data ManagementJohn Smith의 질문
John Smith 님이 #Data Management에 질문했습니다
2015년 4월 20일 오전 12:23

User profile validation rule help?

I'm trying to create a validation rule on the user object. In "english" the rule means to make sure that a picklist value, a phone number field and a user name field are ALL populated before a user record with one of two profiles. 

 

AND( 

 

ISPICKVAL(Sales_Organization__c,""), 

 

ISBLANK(Branch_Phone_Number__c), 

 

ISBLANK(Epicor_Username__c) 

 

&& OR(Profile.Id = "00eb0000000ZNTL", Profile.Id = "00eb0000000EdIb" ))

 

The syntax works fine but in practice the rule allows one of the three fields to be blank? Suggestions welcome...
답변 3개
  1. Geoffrey Flynn (Jarvis)
    2015년 4월 20일 오전 12:29
    Hi John,

     

    Give this a shot.

     

    Yours requires all three to be blank, which I don't think is what you are going for.

     

     

    AND( 
     OR(
      ISBLANK(TEXT(Sales_Organization__c)), 
      ISBLANK(Branch_Phone_Number__c), 
      ISBLANK(Epicor_Username__c) 
    ),
     OR(
      Profile.Id = "00eb0000000ZNTL", 
      Profile.Id = "00eb0000000EdIb" 
      )
    )

     

     
답변을 작성하세요...
0/9000