Validation rule: Syncing_of_Status_and_IsActive

Name

Syncing_of_Status_and_IsActive

Label

Syncing_of_Status_and_IsActive

Object

AQB__AQAddress__c

Active

No

Formula

AND( $User.Alias <> 'mule',
NOT(
IF(
OR(
text(AQB__Status__c)='Last Known', text(AQB__Status__c)='Needs Verification'), True,
IF (
AND(text(AQB__Status__c)='Bad',AQB__IsActive__c=False),
True,
IF(
AND( text(AQB__Status__c)='Former',AQB__IsActive__c=False),True,
IF(
AND (text(AQB__Status__c)='Good',AQB__IsActive__c=True), True,False











))))))

Error message

When Status='Good', the address should be active.
When Status='Bad'/'Former', the address should be inactive.

Error location

Top of Page

Description

This validation ensures that when a user is updating the address/email/phone, particular status' is in sync with inactive/active.