Tuesday, May 31, 2016

GoldMine: Lookup.ini Refresher

Still, one of the most under-used aspects of GoldMine! Enjoy.

One of the most powerful yet under-leveraged functions in GoldMine is the LOOKUP.INI, which has been available since the good old days of GoldMine for Windows. Think of it as a script file that GoldMine uses to update fields automatically. A "poor-mans" SQL trigger, if you will. It can also be used to "default" values on new contact records.

Let us suppose we want to make every newly entered record a "Prospect" by putting that value in our Key1 field.

If you have no LOOKUP.INI, then we must create one. Open Notepad and paste in the following text:

[AutoUpdate]
NewRecord=Key1

[Key1]
Otherwise=Prospect


The NewRecord entry under the [AutoUpdate] header specifies what fields should be evaluated when a new record is created.

Then the process skips to [Key1], the first item in our list.

When evaluating Key1, GoldMine then uses the Otherwise value, as no other instructions exist under [Key1].

As Otherwise=Prospect, the value of "Prospect" is autofilled into the Key1 field upon record creation.

You can add more default fields/values to your Lookup.Ini thusly;

[AutoUpdate]
NewRecord=Key1, Key2

[Key1]
Otherwise=Prospect

[Key2]
Otherwise=House Account

When you are finished creating your Lookup.Ini, save it into your GoldMine folder with the specific name "Lookup.Ini", then restart GoldMine to affect the changes.

ProTip: Lookup.INI instructions are also processed when importing contact records.

1 comment:

Jeffer Shen said...

That being said, you can get that rolex replica experience without opting for this model, but rather going for the more demure hublot replica uk. Offering luxury watch buyers something different and more "contemporary" than a lot of its similarly priced Swiss peers, cartier replica has not shown any signs of slowing down; and it's possible to enjoy the brand for less than you might imagine. What sometimes gets lost or overlooked is the fact that hublot replica sale was, indeed, a brand before JCB and they produced watches (and continue to do so) that are not the replica watches or an offshoot of it. Drawing inspiration from the early Hublot watches from the 1980s, the replica watches uk takes a step back from the busy, bold, and brash Big Bang and offers something (dare we say?) discreet.