Validation rule: USyd_Contact_AU_Mobile_Validation

Name

USyd_Contact_AU_Mobile_Validation

Label

USyd_Contact_AU_Mobile_Validation

Object

Contact

Active

No

Formula

NOT (
OR ( $User.Alias = 'mule',
$User.Alias = 'ysemb',
$User.AQB__GiftBatchEntry__c = TRUE,
ISBLANK (TRIM(MobilePhone)),
AND ( ISNUMBER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MobilePhone , ".", ""),"-",""),"+","")," ",""),"(",""),")","")),
LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MobilePhone , ".", ""),"-",""),"+","")," ",""),"(",""),")",""),2) <> '61'),
AND ( ISNUMBER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MobilePhone , ".", ""),"-",""),"+","")," ",""),"(",""),")","")),
LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MobilePhone , ".", ""),"-",""),"+","")," ",""),"(",""),")","")) =11,
LEFT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(MobilePhone , ".", ""),"-",""),"+","")," ",""),"(",""),")",""),3) = '614' )
))

Error message

MobilePhone must be number.
AU MobilePhone format must be:
=> +61 4NN NNN NNN (Mobile)

Error location

Mobile

Description

Validation of AU Mobile