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:

Did this answer your question?