Tuesday, May 31, 2016

GoldMine : Lookup.ini with Conditions

What you can do with the LOOKUP.INI is simply amazing. I find that once someone "gets a handle on it", they take off running with this kind of conditional replacement.

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.

1 comment:

Anonymous said...

The bezel, the case, crown guard and clasp are all matte black, and the caseback is see-thru, exposing a rolex replica automatic movement, but we’ll talk more about it in the next part of this rado replica sale, the movement part. The bezel rotates only counterclockwise, in a smooth and very pleasant fashion. The inlays on it match perfectly the markings on the dial, especially the mini-scale rolex replica sale. I’m very excited about the leather strap, as replica watches sale really exceeded my expectations. It’s not quite like the original one, which has small cracks on it, giving it a vintage feel, but it feels very solid and the cream stitching, besides giving rolex replica uk some depth, also matches the markings on the dial and those on the bezel. Overall, this baby is an awesome watch, really manly and certainly tag heuer replica sale you see every day, so it will definitely be a keeper.