Solved

How to add rows which I want to a table?

Posted on 2001-07-18
5
435 Views
Last Modified: 2013-12-18
I created a table on a form and when the form is being created, the table appears with only 1 row and 1 column.
If I have 3 entries, how do I compute a function to allow me to add another 2 rows and 2 columns? Therefore, it is to say that if the user had 4 entries, he can click on a button that allows him to add the no of rows and columns he want.

How do I achieve it?
I try using this command -> @Command([EditTableInsertRowColumn]) but I do not understand how to make it workable.
Pls help.
Thanks.
0
Comment
Question by:kopibean
[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:sloeber
ID: 6297268
Hey Kopibean,

I think that there is a little miss understanding from you.
The command EditTableInsertRowColumn, is only for design mode.
Example
You have create a table in design mode.
And you want to add a column, than you can choose between Table, Insert Row or this command, it's just the same.

OR

If you've a rich text field, where you've added a table, and you want to insert a new row than you can choose this command or Table ==> Insert Row.

But you can't add a row with fields by this method, in the client.
What you can do is make a table with the maximum count of rows and columns, and hide a couple of rows or columns depending to the value the user choose.

This is the only method.

Greets,
Sloeber
0
 
LVL 8

Expert Comment

by:Jean Marie Geeraerts
ID: 6311201
When your application is for use on the web, you can achieve this using HTML-coding, but it's quite complicated if you don't know HTML to explain.
So let me know if it's a web application before I start...
0
 

Accepted Solution

by:
giusepe earned 20 total points
ID: 6314147
You can achieve what you want to do with the next code:

Starting with the second row, and for each subsequent row, select the entire row, and then in the Text Properties window, check the box "Hide paragraph if formula is true" with the formula:


( ! @IsDocBeingEdited & ThisRowKeyField = "" ) | LastRowKeyField = ""

Substitute the name of a required field in the current row for ThisRowKeyField, and the name of a required field in the previous row for LastRowKeyField. What this will do is suppress the display of any blank rows for read and print, and suppress all blank rows except one in edit mode.

Then you will need a way to "add" rows as they are entered by "un-hiding" them as needed, so put a button or hotspot in the form or on the action bar entitled "Add a row" with the formula:


@if(BottomRowKeyField="";
     @Command([RefreshHideFormulas]);
     @Prompt([OK];"Error";"Thirty rows is maximum"))


Hope this works for you !! and tell me if was useful for you.
giusepe
0
 

Author Comment

by:kopibean
ID: 6316373
Your solution works perfect on my problem.
Thanks
0
 

Expert Comment

by:giusepe
ID: 6319560
We always learn from others, specially in this area of Experts Echange where all the people in the Lotus Notes area help to everyone with comments ans answers.

I am glad Kopibean that my comment was useful for you and works fine.

Regards
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Article by: Rob
Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

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