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 !!!