Problem with color coding in view

HCL Domino Domino Forum
1

Hi,

I want to a particular value to be appeared in a particular color in the view. That value can be any column of that view. I know that this could be done by color coding but it would give color to the total document not to the text. How will I be able to do this? Please advice…

Thanks in advance.

Thanks,

Asish

2

Subject: Problem with color coding in view…

Hi

If you need to color only some data in a certain column you need 2 color-code columns. One on each side of the column

Example… your columns are Name, Address, Amount and Percent

If Amount is greater than 100 it should be red… Percent should always be black (standard color) …

Place a color column on each side of the Amount-column… the first one should have this formula:

a:=255:255:255:255:255:0;

b:=255:255:255:0:0:0;

@if(amount>=100;a;b);

the second column should have a formula for black:

255:255:255:0:0:0;

Dont forget to mark the column for color-values in the property-box. You must always neutralize the color-code because a color-code works from where it is and all the way to the right -unless it meets another color-column

Soren

http://www.zoomtek.dk

3

Subject: RE: Problem with color coding in view…

Thanks for replying… My problem is that value can appear any column of that view… not in acertain column.

4

Subject: RE: Problem with color coding in view…

The only way to do this as far as I know is to prepare a color coding column (hidden) before and after every column, and test for that value in each column.

Nicolas Abesdris

5

Subject: RE: Problem with color coding in view…

I agree. This might cause quite a bit of overhead, but at least it can be done.

6

Subject: RE: Problem with color coding in view…

Thanks… I could do that… but that might make the view heavier… could take a lot of time to open it on server. Ok… anyway when there is no other option, I will have to go for it.