- Print
- DarkLight
- PDF
How do I automatically populate county field based on zip codes?
Article summary
Did you find this summary helpful?
Thank you for your feedback
If you have never used the County code before and would like it automatically filled in based on Zip Codes, we have a tool to help accomplish this.
Answer:
- Create a list of all your Counties and which Zip Code ranges belong to each one.
- Then go to Tools > System Utilities > Run Procedure and type: tools\d-zp2cty.w and click OK.
- The tool will open and you can select the county code from the drop down and enter a range of zip codes in the fields at the bottom. You have the option to populate the profiles, grants, and or gift records.
- By default you will only fill in where there is no existing county code. You can check the box to replace existing county codes which can be useful under certain circumstances.
Was this article helpful?