Validation rule: Imod_and_SS

Name

Imod_and_SS

Label

Imod_and_SS

Object

AQB__AlternateID__c

Active

No

Formula

AND( $User.Alias <> 'mule',
NOT(
IF
(
AND(text(AQB__Type__c)<>'Sydney Student ID',text(AQB__Type__c)<>'imodules' ),True,

IF(
AND( text( AQB__Type__c )='imodules', AQB__AlternateID__c = AQB__NonuniqueAlternateId__c ),True,

IF
(AND(text(AQB__Type__c)='Sydney Student ID',AQB__AlternateID__c = AQB__NonuniqueAlternateId__c),True,False

)

)
)


)
)

Error message

For type='imodules' and type='Sydney Student Id' the Unique and Non-unique IDs should be the same.

Error location

Top of Page

Description

This validation rule states that the 'Sydney Student' and 'Imodules' types should have the same unique and non-unique IDs.