/
Validation rule: Duplicate_Account2_Contact2_must_be_pair

Attention: Confluence is not suitable for the storage of highly confidential data. Please ensure that any data classified as Highly Protected is stored using a more secure platform.
If you have any questions, please refer to the University's data classification guide or contact ict.askcyber@sydney.edu.au

Validation rule: Duplicate_Account2_Contact2_must_be_pair

Validation rule Details

Name

Duplicate_Account2_Contact2_must_be_pair

Label

Duplicate_Account2_Contact2_must_be_pair

Object

Case

Active

Yes

Formula

AND( RecordType.Name = 'Duplicate Account/Contact',
NOT(ISBLANK( Usyd_Potential_Duplicate_Contact_2__c )),
NOT( OR( Usyd_Potential_Duplicate_Contact_2__c = Usyd_Potential_Duplicate_Account_2__r.AQB__PrimaryContact__c ,
Usyd_Potential_Duplicate_Contact_2__c = Usyd_Potential_Duplicate_Account_2__r.AQB__SecondaryContact__c)))

Error message

Potential Duplicate Contact 2 must be either primary or secondary contact of Potential Duplicate Account 2.

Error location

Top of Page

Description

If duplicate Contact 2 selected then it must be either Primary or seondary of the Account

Related content

Validation rule: Duplicate_Account1_Contact1_must_be_pair
Validation rule: Duplicate_Account1_Contact1_must_be_pair
More like this
Validation rule: Retain_Account_Contact_must_be_pair
Validation rule: Retain_Account_Contact_must_be_pair
More like this
Validation rule: Duplicate_Account1_Not_equal_Account2
Validation rule: Duplicate_Account1_Not_equal_Account2
More like this
Validation rule: Secondary_Contact
Validation rule: Secondary_Contact
More like this
Validation rule: Primary_Contact
Validation rule: Primary_Contact
More like this
Validation rule: ACCOUNT_MATCHES_CONTACT_ACCOUNT
Validation rule: ACCOUNT_MATCHES_CONTACT_ACCOUNT
More like this