I am trying to validate a Postal Code. If a user selects United States for their country (this is the default) the PostalCode field would be required. If another country is selected then the Postal Code field would not be required.
I have enabled custom SQL.
SQL Query: if ('$(Country)' = 'United States')
select 0 as IsValid
else select 1 as IsValid
Validation Error Message: If your address is in the US your Postal Zip Code is required
Client Side Validation and Server Validation are both selected.
If United States is selected than the user can not register even after providing a zip code, any other country the user can register? I have this working in development but after moving to production it is no longer working?
I must be missing something?
Lewis