Mutli-row view column color issues

HCL Domino Domino Forum
1

I have a request to do something I am not sure is possible so I want to solicit ideas from everyone.

I have a view that contains multiple lines per document. the first and second columns contain numbers (Qty and RemQty). What I want to do is color the lines within the column different colors depending on what the difference between the two columns are.

An example (if it renders here)

Line…Qty…RemQty

1…100…50

2…200…200

3…300…150

4…400…400

What I want to do is color the row within the cell (in this example lines 2 and 4) a different color than the values in rows 1 and 3.

I know how to do this in individual lines but these are all on one document using a formula like

@Text( Qty1 ) : @Text( Qty2 ) : @Text( Qty3 ) : @Text( Qty4 ) for column 1

and

@Trim( @Text( RemQty1 ) : @Text( RemQty2 ) : @Text( RemQty3 ) : @Text( RemQty4 ) column 2

How can I write a color column formula to do what I am trying to do - is it even possible?

2

Subject: RE: Mutli-row view column color issues

To have a different color on each row of the same document, you mean, depending on the numbers displayed on that row. Doesn’t look like it.

Please let us know whether you get this working.

I think you could do it using a DB2NSF with a QV…

3

Subject: RE: Mutli-row view column color issues

Come on Andre, you know that is not the answer I was looking for. I was seriously hoping some enterprising developer would have come up with this in the last couple of years. Oh well, something new to add to the wish list for the next release.

How about this one…

Can you get icons to appear down a column instead of across in the same example? That way I could use a checkmark and an X to represent the different values.

4

Subject: RE: Mutli-row view column color issues

No, but if you have only two values for each row, and a limited number of rows (say, 5), then you could create an image resource for each combination of values – 61 of them in this case – showing a vertical row of icons, and just display the appropriate one depending on the number of values and state of each value.

Of course, if you are happy to display an icon rather than using the row color, it might work to return a list of image resource names in a column that’s set to display multivalues in multiple rows.