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

Sample input:

ValidState("CA")

Sample output:

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

State = "AL" or
State = "AK" or
State = "AZ" or
State = "AR" or
State = "CA" or
State = "CO" or
State = "CT" or
State = "DE" or
State = "FL" or
State = "GA" or
State = "HI" or
State = "ID" or
State = "IL" or
State = "IN" or
State = "IA" or
State = "KS" or
State = "KY" or
State = "LA" or
State = "ME" or
State = "MD" or
State = "MA" or
State = "MI" or
State = "MN" or
State = "MS" or
State = "MO" or
State = "MT" or
State = "NE" or
State = "NV" or
State = "NH" or
State = "NJ" or
State = "NM" or
State = "NY" or
State = "NC" or
State = "ND" or
State = "OH" or
State = "OK" or
State = "OR" or
State = "PA" or
State = "RI" or
State = "SC" or
State = "SD" or
State = "TN" or
State = "TX" or
State = "UT" or
State = "VT" or
State = "VA" or
State = "WA" or
State = "WV" or
State = "WI" or
State = "WY"

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.

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

ValidState ( State )

Comments

Support this website.

Support this website.