Skip to main content
Topics#Data ManagementChristian Camacho 的问题
Christian Camacho 提问于 #Data Management
2016年4月28日 15:55

Validation Rule

I have the following Validation Rule, it works perfectly, HOWEVER, old RFCs cannot be EDITED unless there's a contact, in essence what I want to do is the validation rule to be New only AND once it's filled, it can't be blanked out.

 

 

AND(
RecordType.Name = "RFC",
ISBLANK(RequestContact__c)
)

 

I want users to NOT have to enter a contact in order to EDIT "IF" the RFC was created prior to the VR being activated.
6 个回答
  1. Vinay Chaturvedi (Dazeworks - An iLink Digital Company)
    2016年4月28日 16:17

    Oops ! Missed a comma here,My Bad :(

    OR
    (
    	AND
    	(
    		ISNEW(),
    		RecordType.Name = "RFC",
    		ISBLANK(RequestContact__c)
    	),
    	AND
    	(
    		ISCHANGED(RequestContact__c),
    		RecordType.Name = "RFC",
    		NOT(ISBLANK(PRIORVALUE(RequestContact__c))),
            ISBLANK(RequestContact__c)
    	)
    )

     

     
撰写回答...
0/9000