Skip to main content
Topics#Data ManagementPregunta de Christian Camacho
Christian Camacho preguntó en #Data Management
28 abr 2016, 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 respuestas
  1. Vinay Chaturvedi (Dazeworks - An iLink Digital Company)
    28 abr 2016, 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)
    	)
    )

     

     
Escribir una respuesta...
0/9000