The GoldMine Blog - Tips, Tricks & More

Evening!

Just returned late last night from doing some GoldMine training in beautiful, but cold, Toronto, Canada!  Here's a tip I shared with them that went over very well, and I think you'll like it too!

On the GoldMine calendar it, by default, shows the contact name and reference of a scheduled activity:

Wouldn't it be nice to also see the company the activity was scheduled with?  If so here's how you do it.  First, go to Edit | Preferences then to the Calendar tab then click More Options.  Choose "Show results of a xBase Expression" and type in this:

iif(trim(cal->accountno) > ' ', trim(contact1->company) + " " + trim(cal->company) + ": " + cal->ref, cal->ref)

Then Click OK.

Voila!

PS Get notified of the newest Blog postings as they happen!

Go to: http://www.thegmblog.com/notify and fill out the form.  Whenever I update the Blog you'll be notified so you can check out the new post.

Available through January 31st.  If any spark your interest drop me a line at csmith@plain-english.com or (248) 399-8524 ext. 122

1. GoldMine "Up and Bump" - To promote upgrades from GoldMine SE to GoldMine CE, an existing GoldMine Standard Edition customer (who is current on their UPP subscription) may upgrade to CE for $349 per seat, representing a $100 saving.  In addition, an existing GoldMine Standard Edition customer who upgrades and adds additional licenses of GoldMine Corporate Edition can do so at the same price of $349 and receive one 50% off the second license for each new license purchased. Offer expires on January 31st, 2007. Maintenance is based on list price and is required and payable on all licenses including the free licenses.

2. GoldMine "Up and Bump" - To promote upgrades from GoldMine to GoldMine CE, an existing GoldMine Standard Edition customer who does not have a  current UPP subscription may upgrade to GoldMine Corporate Edition for $399 per seat, representing a $50 saving.  In addition, an existing GoldMine Standard Edition user who buys new licenses of GoldMine Corporate Edition can do so at the same price of $399 and receive 50% off the second license for each new licenses purchased. Offer expires on January 31st, 2007. Maintenance is based on list price and is required and payable on all licenses including the free licenses.

3. GoldMine and QuickBooks Link - Buy 5 licenses of GoldMine Corporate Edition and receive the all new GoldMine Plus Accounting for use with QuickBooks SERVER link free (which works with QuickBooks 2006 and 2007). Offer expires on January 31st, 2007. Maintenance is based on list price and is required and payable for all licenses including the free licenses.

4. GoldMine CE and HEAT promotion - New customers, or existing GMCE customers, who purchase a minimum of 5 new GoldMine Corporate Edition license can buy 3 seats of HEAT for $3,000.  Offer expires on January 31st, 2007. Maintenance is based on list price and is required and payable for all licenses.

5. Buy 5 and get 1 Free - New customers who purchase GMCE in multiples of five GMCE licenses will receive 1 GMCE license for each 5 license purchased.  Offer expires on January 31st, 2007. Maintenance is based on list price and is required and payable for all licenses.

Here's another question that came up in Toronto's GoldMine training...  BTW --- I've been doing GoldMine training for 6 years, even certified by FrontRange to do GoldMine training, so if you're looking for GoldMine training whether it be GoldMine 101 or GoldMine administration drop me a line at csmith@plain-english.com

... big discounts if it's somewhere south of the Mason-Dixon line during the Michigan winter! ;-) 

By default, when you alarm an activity the "Alarm Lead Time" will be 10 minutes prior to when the activity is scheduled to take place.  You schedule an activity for 9:30, check the alarm box, and the alarm will be set for 9:20.  This can be changed at that time, but that's the default...

Often times, especially for appointments you'll want to increase this time which can be done on an activity by activity basis by simply changing the time.  If you'd like to increase the default lead time first go to Edit | Preferences then click the Alarms tab.

In the upper-right of the alarms tab is, "Alarms default lead time".  Change that to however many minutes you'd like the default alarm lead time to be!

PS Get notified of the newest Blog postings as they happen!

Go to: http://www.thegmblog.com/notify and fill out the form.  Whenever I update the Blog you'll be notified so you can check out the new post.

Here's a SQL Query request that comes up often...  How to find all secondary contact and their email addresses:

Here ya' go!

select contact1.company, contsupp.contact, contsupp2.contsupref + contsupp2.address1 from contact1, contsupp, contsupp as contsupp2 where contsupp.rectype = 'C' and contact1.accountno = contsupp.accountno and contsupp.recid = contsupp2.linkacct order by contact1.company

Now wouldn't the GoldMine Guide To SQL Queries (http://www.thegmblog.com/sql4gm/) make a great Holiday gift for that special GoldMiner in your life?

First, I hope you had a very enjoyable Holiday, this might be the last post for this year!  Here's to a prosperous 2007!

If you're a user of Groups in GoldMine you'll find this a very handy tip.  Groups, unlike filters or SQL Queries are static, meaning they represent the database when the group was created, a snap-shot, if you will, of the database at a particular point in time.

(For more information on the differences between Filters, Group, and SQL Queries check out this posting: http://goldmineblog.typepad.com/the_goldmine_blog/2006/10/filters_groups_.html)

Since groups are static I find it convenient to 'Date Stamp' the group so I know when it was created.  To do this we can use the 'Code' field for a group.

To make this process even easier we can add a dBASE macro to insert the data automatically for us.  The value should be:

~date()

That code will automatically insert today's date into the field!  Neat eh?  The Code field is limited to 8 characters so we have to stick with the DD/MM/YY format. 

If, when you use this macro, you get '12/26/20' for example you'll need to change your Window's short date setting to use the DD/MM/YY format.  This can be done in the Windows Control Panel under 'Regional and Language Options'.  Once in that Control Panel click 'Customize' then change the short date setting under the Date tab. 

Get notified of the newest Blog postings as they happen!

Go to: http://www.thegmblog.com/notify and fill out the form.  Whenever I update the Blog you'll be notified so you can check out the new post.

Writing today from beautiful downtown Chicago...  Just in town for a couple of nights to bring in the New Year....

Just wanted to wish everyone a Happy & Prosperous 2007!