Examkin

Question

Difficulty: MediumValidation Rules and Data Quality Enforcement

A system administrator is building data validation rules for a custom object named Expense_Report__c. The business requirement states that when an expense report status is updated to 'Submitted', the 'Reimbursement_Account_Number__c' field must not be left blank, and validation must evaluate correctly even if field values are modified during record updates. Which TWO validation rule configuration principles or formula functions must the administrator implement to satisfy this logic and ensure robust data quality enforcement?

  1. Use AND(ISPICKVAL(Status__c, 'Submitted'), ISBLANK(Reimbursement_Account_Number__c)) to ensure the formula correctly triggers when the status is Submitted and the account number is null or empty.Answer
  2. B
    Use PRIORVALUE(Status__c) = 'Submitted' as the sole entry condition to check if the record was previously submitted before validating field emptiness.
  3. C
    Rely on dynamic form field visibility settings on the record page to prevent users from saving blank values when the status changes to Submitted.
  4. Combine ISCHANGED(Status__c) with ISPICKVAL(Status__c, 'Submitted') and ISBLANK(Reimbursement_Account_Number__c) if validation should specifically fire upon transition into the Submitted state.Answer
  5. E
    Configure a matching rule on Expense_Report__c to enforce that Reimbursement_Account_Number__c is populated prior to validation rule execution.

Answer

The administrator should use AND(ISPICKVAL(Status__c, 'Submitted'), ISBLANK(Reimbursement_Account_Number__c)) for standard validation and incorporate ISCHANGED(Status__c) when checking for state transitions.
Validation rules fire when the formula expression evaluates to TRUE. Using ISPICKVAL to evaluate picklist values combined with ISBLANK to safely evaluate missing text data correctly detects invalid records. Adding ISCHANGED ensures the rule evaluates specifically during the stage transition.

Step-by-Step Solution

1
Analyze the field types and logical conditions required.
Status__c is a picklist field requiring ISPICKVAL(), and Reimbursement_Account_Number__c is a text field requiring ISBLANK() to handle empty strings and null values safely.
Validation rules evaluate formula logic to TRUE when data is invalid, so conditions checking for required field completion when a status is met must return TRUE when the required field is blank.
2
Evaluate state transition functions.
Using ISCHANGED(Status__c) alongside ISPICKVAL(Status__c, 'Submitted') verifies that the record is actively moving into the Submitted stage during the save operation.
State transition checks ensure that validation triggers accurately during record updates without disrupting unedited existing records.

Key Concept

Salesforce Validation Rule Formula Functions (ISPICKVAL, ISBLANK, ISCHANGED) and Data Integrity Scope
Rate this question

Topics

Validation Rules and Data Quality Enforcement

More questions from this topic