[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Is it possible to create a dynamic table in Lotus Notes R5

Posted on 2003-11-24
Medium Priority
Last Modified: 2013-12-18
I am new to Notes development (All development) and I need to create a dynamic table in the form so the user can enter as many rows as necessary.  I have tried working with an embedded excel spreadsheet, but it is clumsy when it opens and I keep getting errors.  Can anyone help me?  This one problem is holding up the entire project.
Question by:jtennyson
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
  • 4
  • 2
  • 2
  • +2
LVL 24

Accepted Solution

HemanthaKumar earned 500 total points
ID: 9813467
Is this table a fixed rowXcol one ?

And is this table being inserted in a rich text field ?? How do you want it ?

Also are you looking for some data fields in this table ?

PS: If you are using R6, you can create table on DYNAMICALLY !! For R5 there is no such direct method.

LVL 24

Expert Comment

ID: 9813678
I believe you want a std table of fixed row and cols !

If that is what you want do this..

1. Create a form (say, Table) with one RichText Field Call it RT and save the form
2. Create a view (say, TableView) which has selection formula as
   Select Form = "Table"
3. The view's first column should be sorted with following formula.. @Text(@DocumentUniqueID).. Save the view
4. Create a document using Table form and draw table in the RT field and save it.. THis doc should be listed in the view that you created
5. Now in the form where you want the table to be inserted.. Write this formula to the richtext field which will import the table that you created in step 4

temp := @DBColumn( "Notes":"NOCache"; @DBName; "TableView"; 1);
DocID := @if( @iserror(temp); @Return(""); @subset(temp;1));
@GetDocField( DocId; "RT");

Now the contents of RT field is downloaded to your field..


Expert Comment

ID: 9814259
dynamic tables are not supported. you can bypass this either with Hemantha's method, or using hide/when formulas for the table rows.

However your table will be limited by some number of rows.

As for spreadsheet, try to use Microsoft Office Spreadsheet control. It's not heavy and may be you'll get rid of errors.
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

LVL 31

Assisted Solution

qwaletee earned 500 total points
ID: 9815117
For the web, this is possible.  For the Notes client, it is not possible using just the Notes client itself -- you would need some sort of embedded object.  You don't seem to like embedding Excel for this, but I shoudl tell you, that's pretty much the standard way to do this.

Using just Notes, you can have a dynamic table WITH A LIMIT, i.e., you can predefine say, ten rows, and use hide-when to only display some of the rows, or all of the rows.
LVL 46

Assisted Solution

by:Sjef Bosman
Sjef Bosman earned 500 total points
ID: 9823428
All other respondents seem to forget that you talk about inputting values in a form, the user has to enter many rows. Here's a suggestion, which works for me, albeit with some drawbacks:
- don't use fields of the form "field_1", "field_2", etc, but use multi-value fields
- create a one-line table with the columns you want
- put the fields you want in the columns, each in one
- make all fields computed, text, multi-value separated by new-line
- create a sub-form in which you manipulate one line at a time, changing fields etc.
- provide the necessary logic to add or delete lines, or to move lines up and down
- see to it that each field has the same number of values

The table will display all lines nicely, but only if your data isn't too wide. Using the above, I can create e.g.  orderforms with a variable number of orderlines without any problem. Using an unknown number of fields will never be a solution, not even in R6.
LVL 31

Expert Comment

ID: 9825668
> other respondents seem to forget
Who says?  I've got drawbacks, you've got drawbacks.  Whatever floats your boat!
LVL 15

Assisted Solution

Bozzie4 earned 500 total points
ID: 9838143
There are several ways to do this, using workarounds.

Get it here:

This creates a rtf file, that is imported into a richtext field on your form afterwards.  You haven't got a lot of control over the look of the result, but is does do the trick.  In fact, I've used this soluiton extensively over the years (both in R4.6 and R5).

LVL 15

Expert Comment

ID: 9838160
Another possibility:

Use an embedded view in your form, where you show the data (actually stored in individual documents ) to the user.
To add a 'row', you create a new document, that will appear in the embedded view.
Some drawbacks in this approach include the very poor printability of the embedded view.

LVL 46

Expert Comment

by:Sjef Bosman
ID: 9838163
Sorry, went to hospital yesterday. Back in business now.

I'm quite sure the drawbacks of my method aren't half as awful as all the others ;-)
1. it requires an additional (sub)form for the DialogBox
2. a single fieldvalue shouldn't be longer than the width of the table column the field is put into.

1. no unused fields
2. no field shortage when one requires 11 lines where max 10 are prepared
3. no hide-when proliferation
4. no copy-paste mishaps of fields

There must be more...
LVL 31

Expert Comment

ID: 9839332
Hope you are feeling better
LVL 31

Expert Comment

ID: 9839334

Thought you'd gone missing!

Featured Post

Industry Leaders: 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

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

656 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