[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Generating a table in Notes form based on the number of item

Posted on 2012-09-14
Medium Priority
Last Modified: 2013-12-18
I have a Notes database that stores the repair Work Orders. What I would like to do is creating a separate database to store the repair detail with more information and picture of the item that is damaged.

My problem is in one Work Order, there are more than 1 item listed. Usually I just create a button that will create a form on a different database and pass some data. But, in this case, I want each item to have its own separate table in one form. So my question would be how do I create a form that will generate a table (that will host some number of fields) depending on the number of items.
Question by:coronoahcoro
  • 3
LVL 46

Expert Comment

by:Sjef Bosman
ID: 38401220
Don't understand... Why do you want to generate a table when every related document will contain data for only one item? What is the structure of the original form, and what should the related form look like?

Maybe you can add some picture or drawing of what you exactly want?

Expert Comment

ID: 38401804
if you already have a button to create a new form with detail damaged item.
you can do the same with the formula language and a @for loop

@for(i:=1 ; @elements(myitemslist) ; i:=i +1 ;


Author Comment

ID: 38409825
- each WO record has a string field. This field contain item numbers that are separated by a space. If there is no item number '.' (a period) is added to the string.
- I need to create a form that will display all item numbers with their additional details when a user click a button from the WO record. The additional item details reside on a different database.

So my question is I don't know how to design a form that will display each item number and its details.
LVL 46

Accepted Solution

Sjef Bosman earned 2000 total points
ID: 38409986
The short answer is: you can't, and that's something you should have thought of before you started the development.

Two ways to design this: the usual way, and the advanced way.

The usual way would be to define item forms and to create item documents. Each item contains the key of the parent document, either a logical one or a physical one (as in a parent-response relation). You can use an embedded view and a category to display the per WO items.

The advanced way is to combine the WO and item documents into one. Make one WO, and create multi-value item-fields. All item-fields with the same index are together one "record", e.g. itemname[4] and itemdate[4] are both elements of the 4th item.

What you can do, with your current design: create a computed text field that you fill with text related to the items. You'd have to do all the lookups, fetch the data, format the text, etc.etc.etc.
LVL 46

Expert Comment

by:Sjef Bosman
ID: 38442421
This link might be helpful if you try solution #2:

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

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…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Integration Management Part 2
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…

834 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