/
Validation rule: Valid_Canada_Prov_in_Address_Abbrev

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: Valid_Canada_Prov_in_Address_Abbrev

Owned by praveen.sampath
Aug 16, 2024
1 min read

Validation rule Details

Name

Valid_Canada_Prov_in_Address_Abbrev

Label

Valid_Canada_Prov_in_Address_Abbrev

Object

AQB__AQAddress__c

Active

No

Formula

AND(
OR( AQB__Country__c = 'CN',AQB__Country__c="CAN",AQB__Country__c="Canada"),
NOT(CONTAINS("AB:BC:MB:NB:NL:NT:NS:NU:ON:PC:QC:SK:YT", AQB__StateProvince__c )))

Error message

A valid two-letter Canadian province code is required.

Error location

State/Province

Related content

Validation rule: Valid_Canadian_Provinces_in_Address
Validation rule: Valid_Canadian_Provinces_in_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Perm_Address_Abbr
Validation rule: Valid_Canada_Prov_in_Perm_Address_Abbr
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Mail_Address_Abbrev
Validation rule: Valid_Canada_Prov_in_Mail_Address_Abbrev
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canadian_Province_in_Perm_Address
Validation rule: Valid_Canadian_Province_in_Perm_Address
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Shipping_Add_Abbre
Validation rule: Valid_Canada_Prov_in_Shipping_Add_Abbre
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Billing_Add_Abbre
Validation rule: Valid_Canada_Prov_in_Billing_Add_Abbre
TAP - Advancement Portfolio Product
More like this