Table Cell Colour

HCL Domino Domino Forum
1

Hi all

I need change the colour of cell depending on a Letter in the first Cell on the Column

I have 31 Columns, and 15 rows. I need to fill a complete column if the top cell has an ‘S’ located in the text field.

I need to know if they is a way this can be programmed rather than going into each cell and added the following formula @if(Cell1=“S”;“Green.gif”;“White.gif”)

This is taking a long time and it means each time I add a new row, I have add this to each cell.

Thanks

2

Subject: Have you considered HTML?

HTML works for both Notes and Browser clients in R6/R7

SO

Create a CFD single field . initially set to itself

mark this field as shown as HTML

have script Triggered in Post Open (or WebQueryOpen)

display your table through tags etc

loops within loops should allow yu to cope with indefinite numbers of row/columns

better than laying them out in designer

3

Subject: RE: Have you considered HTML?

Thanks Alan, but I would not know where to begin when it comes to HTML/Java.

If you know of any examples please let me know

Thanks

Dan

4

Subject: NO java needed but you need some HTML

here is a URL to a reference sitehttp://www.htmlhelp.com/reference/html40/

and another to a primer

But basically you would create a field with content something like this.

row 1 col 1 row1 col 2 row 1 col 3
row 2 col 1 row 2 col 2 row 3 col 3

(Paste this into a file, save was text but with extension .html and open with a browser to see the effect)

and there are lots more facilities to play with …

controling fonts etc.

learning this wont be time wasted

dropping into HTML is very useful when building websites - even with the “Domino” aspect of teh server.