Validation rule: USYD_Gift_Club_Status_Validation

Name

USYD_Gift_Club_Status_Validation

Label

USYD_Gift_Club_Status_Validation

Object

AQB__Summary__c

Active

No

Formula

AND(
AQB__Summaries_Definition__r.Name = 'Challis Bequest Society',
NOT (ISPICKVAL( USYD_Status__c , "Legacy")),
NOT (ISPICKVAL( USYD_Status__c , "Legacy Anonymous")),
NOT (ISPICKVAL( USYD_Status__c , "Lifetime")),
NOT (ISPICKVAL( USYD_Status__c , "Lifetime Anonymous")),
NOT (ISPICKVAL( USYD_Status__c , "Silent (Non-active member)")))
||
AND(
AQB__Summaries_Definition__r.Name = "Founder's Circle",
NOT (ISPICKVAL( USYD_Status__c , "Eligible")),
NOT (ISPICKVAL( USYD_Status__c , "Disqualified")),
NOT (ISPICKVAL( USYD_Status__c , "Existing")),
NOT (ISPICKVAL( USYD_Status__c , "New")),
NOT (ISPICKVAL( USYD_Status__c , "Donor Foundation (Existing)")),
NOT (ISPICKVAL( USYD_Status__c , "Donor foundation (new)")),
NOT (ISPICKVAL( USYD_Status__c , "Unclear")),
NOT (ISPICKVAL( USYD_Status__c , "University partner")),
NOT (ISPICKVAL( USYD_Status__c , "Opted-Out")))

Error message

Invalid status.

Error location

Status

Description

Validates the gift club status