Examkin

Question

Difficulty: EasyValidation Rules and Data Quality Enforcement

An administrator needs to ensure that a validation rule evaluates only when a user modifies the existing value of the Account Status field on an Account record. Which formula function should the administrator include in the validation rule formula to check whether the field value was updated during the save operation?

  1. ISCHANGED(Account_Status__c)Answer
  2. B
    ISBLANK(Account_Status__c)
  3. C
    PRIORVALUE(Account_Status__c)
  4. D
    INCLUDES(Account_Status__c, 'Updated')

Answer

The ISCHANGED function evaluates whether a field's value has changed during the record update transaction.
The formula function ISCHANGED returns true if the field value being evaluated has changed compared to the value currently stored in the database.

Step-by-Step Solution

1
Identify the business requirement
The validation rule must trigger specifically when a user modifies a field value.
Validation rules should only execute when relevant target fields are changed during record editing.
2
Evaluate available formula functions
ISCHANGED returns true if a field's current value differs from its prior saved value.
This function directly checks for record changes in single-field contexts.

Key Concept

Detecting field value modifications in validation rules
Rate this question

Topics

Validation Rules and Data Quality Enforcement

More questions from this topic