Saturday, April 30, 2011

GoldMine : Using conditional colors

There an easy way to change labels and data fields based on the contents.

See the example below. It changes the KEY1 label and data field based on the contents. To use it:

* Right click on the Goldmine form > select Screen Design
* Double click on the KEY1 field > select the Color tab
* Enter the following expression in both the label and data areas:

IIF(KEY1='First', 139, IIF(KEY1='Second', 10526303, IIF(KEY1='Third', 25600, 0)))

Change the sample data (First, Second, Third) to your KEY1 data and you have an easy way to track fields by color.

No comments: