« How To Make Completed Activities Show on the Calendar | Main | CompanionLink Update »

Quick Cleanup After Poor Capitalization

Few things annoy me more, than someone who has entered a contact into GoldMine with improper capitalization in the contact field, address field, city, etc…  

GoldMine Contact

Here’s a trick for giving those field values ‘proper’ capitalization without having to do any typing!

In the Field’s Lookup add an entry like you see below… Just swap out contact for the field… Company, address1, etc.

Field Lookup (GoldMine Premium Edition)

Then, on a field w/ improper capitalization select the lookup code… and Voila!

GoldMine Contact Name with Proper Capitalization

You’ll also notice in the Setup for fields within the Lookup window you can choose Capitalize first letter.  Not a bad option to turn on either.  

Field Setup - GoldMine Premium Edition 

 

PS - Also check out the Dear field post: http://www.thegmblog.com/2007/08/how_to_use_the_dear_field_in_g.php 

 

GoldMine Guide to SQL Queries
 

 

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About

This page contains a single entry from the blog posted on January 24, 2008 10:36 PM.

The previous post in this blog was How To Make Completed Activities Show on the Calendar.

The next post in this blog is CompanionLink Update.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type 3.34