Solved

How to add rows which I want to a table?

Posted on 2001-07-18
5
427 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Your solution works perfect on my problem.
Thanks
0
 

Expert Comment

by:giusepe
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Adjusting times for a meeting room 3 128
Lotus Notes 6.5.5 6 200
lotus notes, exchange 7 105
Counting documents in a Domino View 3 31
For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
This video discusses moving either the default database or any database to a new volume.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

763 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

11 Experts available now in Live!

Get 1:1 Help Now