Monthly Archives: September 2012

Using GoldMine Lookup Lists – Part 2

In “Part 1” we showed you how to configure the lookups list settings to help improve the quality of the data being entered into GoldMine.  Part 2 will provide some additional tips on how to add comments, string multiple values, and use dBase expressions to add data to a field.

Adding Comments
Comments inside your lookups provide additional information to your users in order to help them select the correct values.  By using the ‘//’ at the end of the value, you are telling GoldMine not to display the remaining text when the entry is selected.  Selecting any of the items below will only enter the number and not the description.Using_GoldMine_Lookup_Lists_06


Allowing for Multiple Entries
If you would like to be able to string along multiple values into a single field, such as ‘0001, 0002’, using the previous example, to indicate multiple interests, you can use the semi-colon ( ; ) at the end of the entry.  When you use this feature, GoldMine will automatically add the comma and space between your selections.Using_GoldMine_Lookup_Lists_07

For both comments and multiple entries, just use them in this order:  value, semicolon, forward slashes, description.Using_GoldMine_Lookup_Lists_08

Also, note that any entry without a semi-colon ( ; ) will replace the current values instead of adding it as a string.  In the example above, “None” will replace any and all existing values.


Using dBase Expressions
To add the results of a dBase expression to a field, type a ~ followed by the expression.  For example, ~age(field) will calculate the age of that other field and enter that value in the field.Using_GoldMine_Lookup_Lists_09

Other examples might include:

~proper(contact1->contact) in the Contact lookup to do a one off “Convert to Proper Case”.
~dtoc(date()) to put today’s date in a text field

and many more…


Enjoy and Happy GoldMining!!


Using GoldMine Lookup Lists – Part 1

GoldMine lookup lists provide businesses a multitude of benefits including saving time by avoiding manual type-in of data and reducing data entry errors such as misspellings.    However, most organizations seem to be using them haphazardly.

When you bring up any lookup list in GoldMine, you will find a Setup button to the right of the list of entries.  Clicking that button will bring up the F2 Field Setup window for that specific list.
Here are some simple steps administrators can use to ensure their lookup lists are properly configured.

  1. Lock down the list.  Not all lookup lists need to be populated and the ones that are, likely do not need to be changed by every user. To prevent users from Adding, Editing, or Deleting items from the list, remove the checkmarks next to those options.  Feel free to do this for fields such as Address1-3, and the Phone fields, to keep users from adding lookups where not needed.Using_GoldMine_Lookup_Lists_02
  2. Lock down the users.  With many lookups, you may not want stray entries, especially for marketing and reporting.  Force them to use only items in the list*, and decide if it’s OK for this field to be left blank.Using_GoldMine_Lookup_Lists_03
  3. Auto-Fill (or not).  If you turn ON the Auto-Fill, GoldMine will “fill-in” the value as you are trying (see example on the left-side of the image below).  If you are using GoldMine Premium Edition and you turn OFF the Auto-Fill, GoldMine displays a dynamic lookup list as you type. (see example on the right-side of the image below).  In this example, if you wanted to select President, you can simply down arrow twice and hit the Enter key.Using_GoldMine_Lookup_Lists_04
  4. Name the Lookup List.  Though not as important as the others above, this makes the window look cleaner and is helpful if you later have to copy this list to another list. Using_GoldMine_Lookup_Lists_05

* Turning OFF “Allow blank input” will only force the user to pick from the list, only if they enter the field itself)


Stay Tuned for more Lookup Tips in our next post!
Enjoy and Happy GoldMining!!