Tuesday, May 31, 2016

GoldMine : Driving Color with Expressions

Back "in the day", GoldMine was the king of dBase. All of those expressions are still available, even within Field Properties;

One of the truly unsung features of GoldMine is the ability to conditionally change a data value color based on what the data value is.

Let us take the Source field for example. We'll imagine that if a Contact Records' Source field is set to "Direct Mail", then it should be in red.

We need to first get into the Field Properties:

1. Right-click on the Source field (on the word "Source", not inside the field)
2. Select Field Properties (your GoldMine user must have "master" rights to do this)
3. Go to the Color Tab

Now we need to provide the expression to control the color based on Field Value.

4. Click on the Expression radio button near the bottom, under "Data Color"
5. Paste the following text into the Expression textbox:

iif(CONTACT1->source="Direct Mail", 255, 0)

6. Ok your way out

Now, whenever "Direct Mail" is chosen for Source, the Field Value will be in red.

ProTip: The "255" represents the color red in the above expression. To see the numbers for the other colors, simply use a "Fixed Color". Select the color you want; you'll notice that the corresponding color number is displayed in the Expression textbox.


Emily Walker said...

Thank you for sharing the post. It's so hard to find out myself :)
gmail email login

raja said...

gmail sign up nice information
paltalk expressdownload paltalk express here
cloudtv apk free cloudtv app

raja said...

its really good one to read thanks for your post
rediff mail

Mohammad said...

Latest Updates and contestant list of Bigg Boss season 10

Have some new collection of Gurupurnima 2016 Wishes, SMS and Greetings

Giải Trí Tổng Hợp said...

The blog or and best that is extremely useful to keep I can share the ideas. Age Of War 2
Big Farm | Slitherio | Tank Trouble
Of the future as this is really what I was looking for, I am very comfortable and pleased to come here. Thank you very much.
Happy Wheels | Goodgeme Empire | Slither.io

Anonymous said...

Amazing article, many thanks for dual-lane. I indigence to peach approximately this collectively my hyperlink weblog earshot msp hacker v3. Too, delight, sojourn my weblog and anyone unforced surprised along with regards in order to its content cloth lets starting on heavy MovieStarPlanet tips. Huge piles!