Solved

How to add rows which I want to a table?

Posted on 2001-07-18
5
430 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now