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.
Technology Partners: 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!

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

801 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