Skip to main content
Topics#Data ManagementJim Bustamonte의 질문
Jim Bustamonte (ADP) 님이 #Data Management에 질문했습니다
2017년 2월 22일 오후 6:33

Contact Validation Rule, which requires field to be filled in, but only certain users can select a certain value.

I'm trying to combine two validation rules, but have been unable to get it to work.

The first would require the "ContactType" field to be entered as COI if the Lead Source/Advisor CRD is blank

 

The second would limit the use of the "Financial Advisor - Rev Share Agreement", "ContactType" Picklist Value to specfic user ids.

Any help would be greatly appreciated.

(First)

 

AND( 

 

OR( 

 

$Profile.Id = '00e40000001BV4C', 

 

$Profile.Id = '00e40000000jwNJ', 

 

$Profile.Id = '00e40000000qfGv'), 

 

AND 

 

(RecordTypeId = '012400000009lL6'), 

 

AND( 

 

(TEXT(LeadSource) = '')), 

 

AND(Advisor_CRD__c = ''), 

 

OR(NOT(ISPICKVAL(ContactType__c, 'COI'))))

(Second)

AND( 

 

OR (ISPICKVAL(PRIORVALUE(ContactType__c), "Financial Advisor - Rev Share Agreement"), ISPICKVAL(ContactType__c,"Financial Advisor - Rev Share Agreement")), 

 

OR ($User.Id <> "00533000003MptBAAS"), 

 

OR ($User.Id <> "00540000001096YAAQ") 

 

)
답변 11개
  1. Steve Molis (You Owe Me a Beer, Inc.)
    2017년 2월 22일 오후 7:04
    I notice you're mixing 15 char and 18 char ID's, I would stick to 15 

     

     

    OR(
    AND( 
    CASE($Profile.Id,  
    '00e40000001BV4C', 1, 
    '00e40000000jwNJ',  1, 
    '00e40000000qfGv'  1, 
    0 ) = 1 , 
    RecordTypeId = '012400000009lL6', 
    ISBLANK(TEXT(LeadSource)), 
    ISBLANK(Advisor_CRD__c), 
    NOT(ISPICKVAL(ContactType__c, 'COI'))
    ),
    AND( 
    OR (
    TEXT(PRIORVALUE(ContactType__c)) = "Financial Advisor - Rev Share Agreement", 
    TEXT(ContactType__c) = "Financial Advisor - Rev Share Agreement"), 
    CASE($User.Id, 
    "00533000003MptB", 1, 
    "00540000001096Y", 1,
    0 ) <> 1)
    )

     

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