Did you know that you can get an on-line (hosted, cloud-based) backup account with a 2 GB capacity from DropBox for free? You can!

Last week FrontRange released GoldMine Premium Edition version 2013.1.0, with bug-fixes, enhancements, and more. Here are the release notes:

How many total history records in your database? Why do you want to know?

select count(*) from conthist

Which contacts have the most history?

Have you noticed how GoldMine's main phone fields automatically format the phone number with parentheses and hyphen? You enter 2483998524 and GoldMine auto-formats it as (248)399-8524.

If you have more than one GoldMine database (an archive, for example) you might find it useful to be able to search both (or more) databases at the same time. Consider this scenario:

In our first post about the RecID field, I told you that the first 7 characters of the RecID contain the date and time of the record's creation, to the 50th of a second. What are the other 8 characters for?

Character 8 - unknown, but usually a symbol, rather than a number or letter

If you've ever done a SQL query in GoldMine, you might have noticed a column called RecID. What is the RecID?