AnsweredAssumed Answered

Validation of postcodes

Question asked by Brucey on Oct 9, 2009
Latest reply on Oct 18, 2009 by Brucey

Title

Validation of postcodes

Post

Is there an easy way for FileMaker 10 to deal with the validation of postcodes or ZIP codes if in the US?

 

I want to be able to validate the following types of postcodes.  Here are three examples. 

 

 

  • HT14 6GH - This one is acceptable
  • 3RT B14     - This one is unacceptable because the first part starts with the number 3 and the second part starts with the letter B.
  • S2 4PQ - This one is acceptable.

 

 

 Not sure how to tackle this one in FileMaker. I believe in Access you would use input masks.

 

Any help appreciated 

 

Outcomes