Skip to main content
Topics#Customer ServiceForrest Muldune's Question
Forrest Muldune (Capital Recovery Advisors) asked in #Customer Service
Apr 2, 2015, 7:10 PM

Validation Rule - User must select value in field befoe entering value in another field

All,

 

I am requesting help creating a VR, view below.

 

Before a user can select a value in the Court_Division__c Lookup field, there must be a value entered in the Court__c Lookup field.

 

Regards

 

 
4 answers
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    Apr 2, 2015, 7:14 PM

    So that would be like this - 

    AND(
      ISBLANK(Court__c),
      NOT(ISBLANK(Court_Division__c))
    )
    Note

    :

    1. This is not going to happen instantly. The VR will fire only if he / she selects a Court Division but saves the record without a Court.
    2. Also have you explore Lookup Filters [1] ? Your requirement could be handled wit that out of the box offering!

    [1]: What is Lookup Filters - 

    https://help.salesforce.com/apex/HTViewHelpDoc?id=fields_lookup_filters_defining.htm. With that you specify a Filter on the second Lookup Field - Court Division to show values only based on the values in the former Lookup - Court.
Write an answer...
0/9000