Validation rule: Blank_Phone_On_Primary_Employment

Name

Blank_Phone_On_Primary_Employment

Label

Blank_Phone_On_Primary_Employment

Object

AQB__Employment__c

Active

Yes

Formula

AND(
ISBLANK(AQB__BusinessPhone__c),
TEXT( AQB__ContactId__r.AQB__PhonePreference__c) = "Business Phone",
AQB__SetAsPrimary__c = TRUE,
OR(ISNEW(), ISCHANGED(AQB__SetAsPrimary__c)))

Error message

The Contact Phone Preference is set to "Business Phone" and the phone number on this employment record is blank. Change the Phone Preference on the Contact or add a valid phone number to this employment record before setting as the Primary Employment.

Error location

Top of Page

Description

Cannot make the record the Primary Employment when the Contact Phone Preference = 'Business Phone' and the Business Phone is Blank.