Example: Validates that the Account Number is exactly seven digits (if it is not blank)
Validation Rule on Account:
AND(
ISBLANK(AccountNumber),
LEN(AccountNumber) <> 7
)
Error Message : Account Number must be seven digits.
Error Location: Account Number
Comments
Post a Comment