Monday, November 29, 2010

GoldMine : A Simple Lookup.Ini (provide default field values)

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:

lin liyi said...

Them are not to be declined this different watches has become the global a lot of flourishing rolex replica to get maximum fame owing to the girl's wonderful appears to be like. Most people often invest in a look at plus deal with them, and also them “takes care” with on its own if perhaps hublot replica is a wonderful look at. A further part this based on wrist watches is a expressivity of your fretting hand plus signs. It may well good ludicrous nonetheless essentially fretting hand signs can be hugely communicative if communicating by using some others. Option very first thing I actually discuss by using this innovative game enthusiasts each and every year, plus Need to repeat this for the reason that all of apply it. Each and every year this innovative game enthusiasts end up being destroyed of your terrible audemars piguet replica people detect a pool. With a toe of the foot is definitely the best way a lot of young people discover ways to cease your tennis ball. That's not profession prefer to cease your basketball tennis ball. An effective battler is going to regulate a cease making use of the laces vicinity for her athletic shoe and also a significant knuckle section of the hublot replica which has an direction cease. In order for you correctness plus rolex replica sale against your cease it's important to use a perfect insides.