Monday, November 29, 2010

GoldMine : A somewhat less simpler Lookup.Ini (fill values based upon other values)

Let us consider the Key1 update. Let us now suppose we want to auto-fill the name of whoever created the record based upon who was logged into GoldMine at the time. And since GoldMine usernames can only be 8 characters long, we sometimes want to see the "real name"

This is how it's done;

[AutoUpdate]
NewRecord=Key1

[Key1]
lookup1=&username
JHILL=Justin Hill
CBABKA=Corey Babka
GMARKS=Gene Marks
Otherwise=Unknown

Again, our NewRecord entry triggers the Key1 "block".

Then GoldMine "looks at" the &username macro (which returns the GoldMine username currently logged in).

Then, based upon THAT value, returns an item in the list. If no such username is found, our Otherwise is a "catch-all", marking them as Unknown.

ProTip: For a list of GoldMine dBase expressions, Google "GoldMine dBase Expressions" and look for "Using dBase Expressions" by FRS.

No comments: