Member records, whether they are people or companies, have both billing and shipping address. Shipping addresses allow for associated counties so that associations can pull pull legislative affairs or other reports based on those jurisdictions. Sometimes strange data, including misspellings, out of market counties, and even random words can find their way into this drop down.
The drop down itself is dynamically generated by the data within your database. If someone on your team enters a new county, it will then appear in the list for future records. Additionally, if someone enters a typo or an "internal note," that data will begin to appear in the drop down.
Cleaning Your County Drop Down List
The easiest way to find records with incorrect data is to generate a quick custom report. Simply set the following condition:
Contact Info > County Equal [enter offending county name here]
In display settings, you'll only need to see the member's actual name, so set the columns to display to:
General Info > Name
Best Practices to Ensuring Clean Data
Novi AMS uses the Google Maps API to help users, both members and staff admins, to validate addresses as they are typed. Simply re-type the member's shipping address in the box and it should auto-populate for you. We recommend that you rely on this assistance as much as possible.
Cleaning Existing Data
If you are looking to eradicate a specific value and you can't figure out which records are using that value, then try creating a custom report. Here is an example:
