Skip to main content
Question

 

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
  1. Jan 31, 2014, 4:26 PM
    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 )

    )

0/9000