I have a picklist field with API Name Type_c
I have at text field name VIN_c
both fields are in a custom object name Properties
I am trying to create a Validation Rule in the VIN_c field when someone does not select the value "vehicle" in the Type_c field, then VIN_c field will be blank (Null) and no one will be able to enter any value in the VIN_C field while "vehicle" is selected in the Type_c field .
Below is the partial formula I created.
IF( NOT(ISPICKVAL(Type__c, "vehicle"))
I am very new to Salesforce and I know this formula looks pathetically incomplete.
I appreciate you all help.
For
11 answers
Yes, you will have to amend the VR like this:
AND(RecordType. Name = 'Bank',
Active__c = FALSE,ISBLANK( Bank_Closed_Date__c )
)
AND(RecordType. Name = 'Bank',
Active__c = FALSE,ISBLANK( FIN__c )
)