I know now, that R6 doesn’t support table columns hide/ifs (and I know, that I can hide column’s content).Does anybody know a nice workaround?
I really need to hide this guys based on formula. If it would be HTML - no problem. But what can I do in a client??
Please, advise!
Subject: HIding Notes table columns. A workaround? - I FOUND!!
If I active “render paththough HTML in Notes”, I can use HTML table instead of Notes one.Painful, but still workaround!!
Subject: RE: HIding Notes table columns. A workaround? - I FOUND!!
Hi, if you only want to display data which isn’t changing then I would suggest you to use a HTML Table. I use this othen and the possibilities are not so limited as you might think.
But if you want to make somethink dynamic
(add / edit / delete a row) then I have to disappoint you.
As far as I know you can only define the HTML value on loading of the document.
If the document exist
(I have documents generated via an agent which allows managers have an overview of employees daily activities)
then you can define the layout on queryopen. I use computed value with fieldnames.
TD {font-family: "Tahoma", "Default Sans Serif"; font-size: x-small; } TH {font-family: "Tahoma", "Default Sans Serif"; font-size: x-small; font-weight: bold; text-align: left; } TD.BB {border-bottom: 1px; } TD.BT {border-top: 1px; } TR.TH{font-family: "Tahoma", "Default Sans Serif"; font-size: x-small; font-weight: bold; text-align: left; background-color: #666666; color: white;} TR.row0 {background-color: #FFFFFF; } TR.row1 {background-color: #E6E6E6; } A:link {color: #000000;text-decoration: underline; }and in my computed value you can point to the fields like HTMLResult0, HTMLResult1, …
a great trick to show more than 32K without that LN make any problems.
For example this is my content of my table :
I created my own class to make this generation from plain data into the below result. This is very nice and you have very clear code.
Note you can also add javascript! think about, when I click on this link, a dialog button appear. (I also made, click on the header, and this column is sorted ) and this all in the LN client.
If you want to display images, then I would suggest that you create a profile with these images on, and afterwards ‘install’ / put these files into the users computer folder. Then you can use also IMG
{}
I hope that this pleases you???
example of HTMLResult0
"
| Quote Nr | Expiry Date | Sales Representative | Quote Value | Days |
| 103/080213/7BSJK3 | 20/02/2008 | Engineer A | 2.405,70 | -350 |
| ARS/080603/7F9D58 | 24/06/2008 | Engineer B | 8.546,50 | -225 |
| ARS/080603/7F9DA3-1 | 03/07/2008 | Engineer C | 900,00 | -216 |
| ARS/080603/7F9D57 | 09/07/2008 | Engineer A | 100.000.005.937,50 | -210 |
| 98765/080820/7HP9AR | 21/08/2008 | Engineer F | 10.000,00 | -167 |
| 5 documents found | 100.000.027.789,70 |
Subject: RE: HIding Notes table columns. A workaround? - I FOUND!!
Cedrick,
I really needed a solution for a dynamic table and Thank you for the great tip. I"ll definitely use it for the similar tasks.
In my current case I went though with the combination of dynamic values via computed texts and computed graphics for the cell backgrounds inside the borderless table. All together it imitates the hide-if function. Painful to implement and not 100% what I wanted, but works so far.
Thank you!