/
Validation rule: Valid_Canada_Prov_in_Shipping_Add_Abbre

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_Shipping_Add_Abbre

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

Validation rule Details

Name

Valid_Canada_Prov_in_Shipping_Add_Abbre

Label

Valid_Canada_Prov_in_Shipping_Add_Abbre

Object

Account

Active

No

Formula

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

Error message

A valid two-letter Canadian province code is required.

Error location

Account.ShippingState

Related content

Validation rule: Valid_Canadian_Province_in_Shipping_Add
Validation rule: Valid_Canadian_Province_in_Shipping_Add
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_Billing_Add_Abbre
Validation rule: Valid_Canada_Prov_in_Billing_Add_Abbre
TAP - Advancement Portfolio Product
More like this
Validation rule: Valid_Canada_Prov_in_Address_Abbrev
Validation rule: Valid_Canada_Prov_in_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_Mail_Address_Abbrev
Validation rule: Valid_Canada_Prov_in_Mail_Address_Abbrev
TAP - Advancement Portfolio Product
More like this