Forum Discussion

JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
8 years ago

How to auto-fill a county field based on zip code?

I am having an issue with the address field, it pulls all information except for county. Does anyone have a formula or know of a solution to have a field auto-filled once the zip code has been entered...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I suggest googling until you can find a free down load of an Excel file with all the US Zip codes.

Then create a new Table called Counties by Zip Codes, where the Key field is set to Zip Code.

Then build a relationship to the Address field based on the Zip code there.  You may find it easier to create a Zip Code mirror field with the formula and use that to make the relationship.

[Address: Postal Code]

Then, of course lookup the County.
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
7 years ago
np,
Look at your address field properties. It will give you the name of the subfields.

Then make a new formula text field called [zip code] with a formula like

[Address: Postal Code]

Now you have a Text field eligible to be in a relationship.