Question
Address fields allow invalid State names
+12Is there a way to force the State name to be valid. I have an office address field but the user can enter anything in the State name, it doesn't have to be valid, so we have a lot of records with invalid state names. Is there a way to correct this when using address fields?
There is a new feature called data validation that can be enabled at the table level. I can't seem to get the help system to search in the last couple of days, but you make a formula to calculate an error message. If the formula is blank result then the record will save, else it will block the save with an error.
Note that if you enable this you would need to deal with the old records, or maybe have the formula only abort the save where [date created] is after June 27, 2019.
Or else make users fix the state even though they may not have been the ones to enter it wrong.
Post back if you need a list of states.
Note that if you enable this you would need to deal with the old records, or maybe have the formula only abort the save where [date created] is after June 27, 2019.
Or else make users fix the state even though they may not have been the ones to enter it wrong.
Post back if you need a list of states.
Do they input the address all in one field, or are they split up to multiple sections (for example: street address 1, 2, City, State, Postal Code)
If you look at the field properties for that address field it will give you the subfield names that you should be able to use in formulas
It will tell you what the field name is for the state field
It will tell you what the field name is for the state field
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.