Help on column colur coding

HCL Domino Domino Forum
1

Hi All:

Could anybody give me breif information about “Column colour coding”?.(Or any link,site etc…)

I have gone through all the forum with no luck.

Thanks in Advance,

-Nagendra

2

Subject: sure, it is pretty good

doesn’t work so well on the web and gets confused with response documents, but apart from that you can specify a column as a colour column, then in that have a formula which evaluates to a list of numbers, you can have 3 numbers for just a background colour or 6 numbers for a foreground and background colour. Bung a couple of fields on a form and set them as colour fields, then you get the pretty chooser thing pop up, you can then use the values stored in these fields for column row colours.

3

Subject: RE: sure, it is pretty good

Minor correction:

“you can have 3 numbers for just a background colour or 6 numbers for a foreground and background colour.”

should be:

“you can have 3 numbers for just a foreground colour or 6 numbers for a background and foreground colour.”

Also, you can a text string (or, for a background color as well, a two-element text list) of six hex digits, but this will only work if you store the strings in a temp variable. (The decimal number list technique doesn’t require variables to work, however.)

Basic definition: a color column changes the color of text in that row for all following columns, up until the next color column.

4

Subject: Help on column colur coding

  1. Create a column to the immediate left of the column that you wish to add color to.

  2. In this new column, select the column property “Use value as color” under the Column Info tab and select “Hide column” under the Advanced tab.

  3. In the Programers Pane select “Formula”. The formula will be a set of 6 RGB color coordinates. The first set of 3 coordinates is the background color and the second set is the text color of the column. For example, the column formula (do NOT put the coordinate values in quotes):

225:225:225 : 255:0:0

produces a Grey (225:225:225) background with Red (255:0:0) text.

Notes:

  1. The colors selected affect ALL columns to the right of the colored column, so you may need or want to add another hidden color column that “returns” the remaining columns to your “default” column combination.

  2. You will also lose “alternate row colors”, if selected, to the right of the color column. To help with readability because of the loss of the “alternate row colors”, under the Style tab of the View Properties I select the Grid option of “Solid” with a color that is appropriate for the view.

  3. Grid style does not work on the web.