Outlook Validation for Forms and Zip codes [SOLVED]

Outlook Validation for Forms

We had a client where they had a very specific validation that needed to be applied to their contacts. The Zipcode field needed to start with a country Letter. Here is the validation necessary.

Watch the video

([Business Address Country/Region] =”Austria” AND Left( [Business Address Postal Code] , 2 ) = “A-“) or ([Business Address Country/Region] =”Germany” AND Left( [Business Address Postal Code] , 2 ) = “D-“)  or ([Business Address Country/Region] =”Switzerland” AND Left( [Business Address Postal Code] , 3 ) = “CH-“)  or ([Business Address Country/Region] =”Italy” AND Left( [Business Address Postal Code] , 2 ) = “I-“) or ([Business Address Country/Region] =”Ireleland” AND Left( [Business Address Postal Code] , 3 ) = “IE-“)  or ([Business Address Country/Region] =”Iceland” AND Left( [Business Address Postal Code] , 3 ) = “IS-“)  or ([Business Address Country/Region] =”Netherlands” AND Left( [Business Address Postal Code] , 3 ) = “NL-“)  or ([Business Address Country/Region] =”France” AND Left( [Business Address Postal Code] , 2 ) = “F-“) or ([Business Address Country/Region] =”Spain” AND Left( [Business Address Postal Code] , 2 ) = “E-“) or ([Business Address Country/Region] =”Finland” AND Left( [Business Address Postal Code] , 3 ) = “FI-“) or ([Business Address Country/Region] =”Norway” AND Left( [Business Address Postal Code] , 2 ) = “N-“) or ([Business Address Country/Region] =”Denmark” AND Left( [Business Address Postal Code] , 3 ) = “DK-“) or ([Business Address Country/Region] =”Belgium” AND Left( [Business Address Postal Code] , 2 ) = “B-“) or ([Business Address Country/Region] =”Luxemburg” AND Left( [Business Address Postal Code] , 2 ) = “L-“) or ([Business Address Country/Region] =”Poland” AND Left( [Business Address Postal Code] , 2 ) = “PL-“) or ([Business Address Country/Region] =”Portugal” AND Left( [Business Address Postal Code] , 2 ) = “P-“)

 

Outlook Validation for Forms

Leave a Reply

Your email address will not be published. Required fields are marked *