Examkin

Question

Difficulty: EasyValidation Rules and Data Quality Enforcement

An administrator wants to ensure that users provide a Mobile Phone number whenever the Preferred Contact Method picklist field is set to 'Mobile' on a Contact record. Which validation rule formula correctly enforces this requirement?

  1. AND(ISPICKVAL(Preferred_Contact_Method__c, 'Mobile'), ISBLANK(MobilePhone))Answer
  2. B
    OR(ISPICKVAL(Preferred_Contact_Method__c, 'Mobile'), ISBLANK(MobilePhone))
  3. C
    AND(ISPICKVAL(Preferred_Contact_Method__c, 'Mobile'), NOT(ISBLANK(MobilePhone)))
  4. D
    ISPICKVAL(Preferred_Contact_Method__c, 'Mobile')

Answer

AND(ISPICKVAL(Preferred_Contact_Method__c, 'Mobile'), ISBLANK(MobilePhone))
The formula correctly uses the logical AND function to require that the Preferred Contact Method picklist equals 'Mobile' while the Mobile Phone field is simultaneously blank, evaluating to true and preventing save when data quality is violated.

Step-by-Step Solution

1
Identify the criteria for triggering the error
The validation rule must fire when Preferred Contact Method equals 'Mobile' AND Mobile Phone is blank.
Validation rules fire when the formula expression evaluates to true.
2
Select appropriate formula functions
Use ISPICKVAL() to evaluate picklist values and ISBLANK() to test for missing text values.
ISPICKVAL checks picklist selection, while ISBLANK verifies whether a field contains data.
3
Combine conditions using logical AND
AND(ISPICKVAL(Preferred_Contact_Method__c, 'Mobile'), ISBLANK(MobilePhone))
Both conditions must be simultaneously true to block record saving.

Key Concept

Combining ISPICKVAL and ISBLANK functions in validation rules to enforce conditional data entry.
Rate this question

Topics

Validation Rules and Data Quality Enforcement

More questions from this topic