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,904 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
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…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

690 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