For a field like Account Type, which denotes whether a record represents a customer, prospect, vendor, etc. it’s of the utmost importance the data you have in the field is uniform. Want to run a filter to see all your prospects? Well if some people enter Prospect, some Prospects, some Prsp, etc. it quickly devolves into a frustrating endeavor.
Fortunately, GoldMine has several settings here that make it easy to ensure good data hygiene for any field. To access these click the Setup button within the F2 Lookup. You will need Master rights to change most of these settings.
Within the Setup screen we have two columns:
The first column controls whether the data someone enters into the field is acceptable, and if not what happens. At a minimum, you should check Force Valid Input so someone must select an entry from the F2 Lookup. You can also choose whether to accept blank input, to input the closest match if someone types something in that isn’t valid, to capitalize the first letter, and to have the F2 Lookup pop up when someone enters the field. These are more personal preferences, but you probably want Allow blank input unchecked.
In the second column are the settings to determine whether or not non-Master Right users can Add, Edit, and Delete the F2 Entries themselves. These three should definitely be unchecked. What’s the point of forcing valid entries if someone can go in and change or add bad entries? Finally, the last option, Auto Fill, will finish typing an entry if someone starts typing into the field instead of using the F2 Lookup window.
With those options, if someone attempts to type in a non-valid entry, like “Active Prospect” the F2 Lookup window will automatically pop up, making them use a valid entry. If they attempt to cancel out of the window another message pops up, making them enter something valid.