Archive for Blog

July 21, 2014   Posted by: gzimmerman

Last contact SQL query for GoldMine users

Here is a SQL Query to be used to find out which Customers have not been contacted within the past # of days.
Copy paste this Query into the GoldMine SQL Query tab and change the 90 to whatever number you would like it to be.
ALSO, you will need to change the Contact1.Key2 field to be the same field in your database that contains the value “Customer”.
__________________________________________________________________________
select contact1.company, contact1.contact, contact2.lastconton, contact2.lastcontat from contact1,contact2 where contact1.accountno = contact2.accountno and contact2.lastconton < (GETDATE()- 90) and contact1.key2 like '%Customer%' order by contact2.lastconton
__________________________________________________________________________
no comments posted in: Blog
May 16, 2014   Posted by: gzimmerman

Two defining forces.

Only two defining forces have ever offered to die for you, Jesus Christ and the American Soldier. One died for your soul, the other for your freedom.

no comments posted in: Blog
May 2, 2014   Posted by: gzimmerman

GoldMine on iPad using Remote Desktop connection

Just loaded the Free Microsoft Remote Desktop APP from the App Store.  This allowed me to connect to my server and run GoldMine.  This works very well.   Let us know and we’ll help you set it up!

no comments posted in: Blog