Solved

Hiding the rows of a table in lotus notes, how could be this be achieved .is there a way?

Posted on 2011-09-23
5
1,861 Views
Last Modified: 2013-12-18
I have a table in lotus forms with about 60 rows. I populate those rows with an agent and save it as document. But agent does not have to fill all rows necessary . Lets say according to that person's data only 5 rows could be filled. if that happens 55 rows looks empty in the document which allocates space on the screen and causes a bad look.

I would like  to achieve the if a row is empty( no value) then hide this row totally from the form and show only populated rows. which can be 5 or whatever.

In the fields i put a hide formula but it hides the fields not the row itself. and there is no property like hide a row or so.. i thought i could but each row inside a section just for that but it does not look pretty and also it has a header and expander arrow or so ,so that is not the ideal solution either ,

How should I go with it.... in the screenshot i want to hide the empty rows you can check, thanks in advance for your support !!! rows empty should not display
0
Comment
Question by:fatihdi
5 Comments
 
LVL 4

Expert Comment

by:cohalex
ID: 36585492
You can not hide the rows.
You could, however, append a new row programatically in the same loop where you fill in the data.
Or, you could delete the table row if there is no data and you can have this in your script as well.

There are classes for manipulating rich text field elements.
Check the NotesRichTextTable class - this is what you need:
http://www-12.lotus.com/ldd/doc/domino_notes/7.0/help7_designer.nsf/f4b82fbb75e942a6852566ac0037f284/1dac0026f9fda3428525704a0040fe27?OpenDocument
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 36585607
Of course you can hide a row if this is in a form.

You have to set the same hide-when formula in every cell of that row, or maybe not the same, but every cell of the row should be hidden when there is nothing available.
0
 

Author Comment

by:fatihdi
ID: 36585706
@sjef,

in the cell of the table there is no option for a hide-when how will i hide the cell? there is text field and table field hide-when but cant find hide-when for cell ,where is it? where is hide for cell?
0
 
LVL 13

Expert Comment

by:CRAK
ID: 36585753
Sjef is right: just hide all paragraphs in each cell of that row. If you forget to hide a paragraph in a single cell, the entire row is displayed (possibly empty).
0
 

Author Closing Comment

by:fatihdi
ID: 36586154
thanks
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question