How to use Color Fields for Columns

HCL Domino Domino Forum
1

Hello,

I have documents with Color - Fields. Now I want to show the color in View for that documents with selected color.

When I define the color-field in the first column with option “use value as color” then there are no showing colors

The color-field saves the color as hexadecimal color. The columns but need rgb colors like

255:255:255:0:0:0

How to transform ?

Where is my thinking error ?

2

Subject: How to use Color Fields for Columns

You need to have a formula in the view column and it has to be the left hand column (I think). You need something like this:

red := 255:0:0;

blue := 0:0:255;

green := 67:152:65;

back := @If( Priority = “High” ; 0:255:64 ;@If( Priority = “Medium” ; 235:197:65 ; -1:-1:-1 ) );

@If( status = “Open” ; back:blue ; @If (status = “Hold” ; back:red ; back:green ) )

HTH

Dennis

3

Subject: RE: How to use Color Fields for Columns

Hello,

thank you for your post. But I want to use a color field. Color Fields are new with notes6 and you can use them like in your Mail-File/Options/Color.

Greetings

4

Subject: How to use Color Fields for Columns

Using the value of the color field works for me. What version are you using?

5

Subject: RE: How to use Color Fields for Columns

Hello,

thanks, you are right.

colorfield1 : colorfield2 shows the correct color in the column.

I used a computed field for both fields on my form. Then my color didn’t show

thanks