Examkin

Soru

Zorluk: KolayValidation 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))Cevap
  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')

Cevap

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.

Adım Adım Çözüm

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.

Anahtar Kavram

Combining ISPICKVAL and ISBLANK functions in validation rules to enforce conditional data entry.
Bu soruyu puanla

Konular

Validation Rules and Data Quality Enforcement

Bu konudan daha fazla soru