Cloud Backup for Free

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!

GoldMine 2013.1 Released

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

GoldMine queries for history counts

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

select count(*) from conthist


Which contacts have the most history?

Incredibly cool tip for user-defined phone fields

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.

Search Archive and Main Database Simultaneously

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:

Anatomy of a RecID, part 2

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

Anatomy of a RecID

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

Subscribe to RSS - Technical