i have been tasked to set up a new database,(inventory system).This is my practical project.I’ve never used designer before,i just learn from book and help session.My problem is, i have no idea to create a table with multiple lines of entries without specifying the number of lines in advance (dynamic table).The table dynamically accepts data that is input.I have create one row and 2 columns of table that consist 2 fields that display the input data from user.The user input data through dialog box. There is a hotspot button outside the table that call this dialog box which have 2 input field for user key-in the data.The input data from dialog box will be displayed in the field in the dynamic table. The problem is when user input more data in the dialog box, the table does not generate a new row for this new input data.It just replace the prevous data in the first row that i have created.
i dont know the script to auto generate dynamic table. I have no basic of lotus script. Hope anybody can help me.thanx you.
Thanx Mr Glenn for your guide, but I’m still quite not understand.If you dont mind, can i get your email address for further information?I can attach the sample form that i have designed.
Subject: ND6 can handle dynamic tables there is a LS
There is a NotesRichTextTable Class in LS that can be used to dynamically control a table in a RT Item. This will be a pretty steep learning curve is this is your first exposure to LotusScript.
Subject: RE: ND6 can handle dynamic tables there is a LS
Bill,
The methods and properties available within that particular class are sparse indeed. I can’t even begin to imagine attempting to write a full-featured table using that class, especially since you have to pretty much provide your own navigation and there are no events available within the RichTextItem object that are particularly handy for capturing data changes. Sure you can tell when there is a change to the rich text field itself, but how do you know WHICH cell changed? Only by keeping a reference of every preexisting cell and comparing it to every current cell could you even begin to track changes to a table within a rich text field.
Subject: RE: ND6 can handle dynamic tables there is a LS
Then hie ye to the @Midas formulas – Ben’s got versions of @DbColumn and @DbLookup that work on rich text table values as data source/sink. It’s in beta now, but the concept is way, way beyond the merely cool:
I can’t think of a better way to do this in the Notes client.
Embedded (editable?) views are a possibility, as well – it all depends on whether the response depth would cause problems. If the invoices are already responses to clients, for instance, then an invoice-on-top hierarchy wouldn’t be available.
If the maximum number of rows is a reasonably small number (perhaps 10 to 15), you can do this: Create the table with all 10 to 15 rows. Also create a hidden field to use as a counter. As the user adds data for a new row, incriment the counter by 1. Use hide-when formulas in the rows of the table to display rows based on the value of the counter. A similar hide-when formula must be placed in every cell in a row.
Of course, this gets rediculous for a large number of rows. In that case you will have to resort to LotusScript or an alternative.