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!
From the monthly archives:
December 2006
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.
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
{ 2 comments }
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.
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.
{ 1 comment }
