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.
SarahClark's avatar
SarahClark
Qrew Cadet
7 years ago
Ok - I did that.
I'm still not sure how to match them up. Maybe I'm being dense because it's Friday afternoon. What am I missing?