ValidState ( State )
Checks for a valid US State Abbreviation
Be the first to rate this function Log in to vote
|Bradley B - Show more from this author|
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
A simple custom function to check if a state entry is a valid abbreviation of one of the USA's states.
Returns a 1 if valid or a 0 if not valid.
Prevents the need for field-level validation warnings, which may have a negative effect on user experience.
I made this because I have a drop-shipping solution which integrates via UPS and FedEx via NRGShip, and one of the reasons a a shipment may fail is an invalid state code.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.