Solved

Multiple occurances of same field

Posted on 2001-08-20
7
155 Views
Last Modified: 2013-12-18
I have a form, (tabbed table with computed subforms), that will have data for different locations.

I started creating a different form for each location but there must be a better way than that, I need to be able to have the information entered based on the number of locations entered (I have this working using the tabbed tables), then display each location on a different form and also be able to edit each location and information associated with the location.
0
Comment
Question by:GaryZ
[X]
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
  • 3
7 Comments
 
LVL 10

Expert Comment

by:zvonko
ID: 6406892
This is an old discussion topic :-)

...but please state which Domino version and where do you like to have this functionality; web or native client?

and please give some details how many fields and wath kind of information does belong to a location definition.

Regards,
zvonko
0
 

Author Comment

by:GaryZ
ID: 6406942
Running Domino 5.0 and the application is on the web. There are around 70 fields involved.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6407162
the best one I sow until now was this one:
"TableWalker 2.01 w/Web
Dynamic table solution for Notes and the Web."
with this URL:
http://www.notes.net/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/b8a8410321cfa6bb85256a8b004d3675?OpenDocument

Regards,
zvonko
0
Independent Software Vendors: 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!

 

Author Comment

by:GaryZ
ID: 6409791
That example gave me an idea on how to do what I am wanting.

Now, if I have a multiple value field (field1) and I want to display the first value in another field (field2) is there a way to extract the value? I have tried serveral ways with no luck.
0
 
LVL 10

Accepted Solution

by:
zvonko earned 200 total points
ID: 6409827
display only in field2 is no problem.
here the formula for field2 which should be: "ComputedForDisplay"
FIELD field1 := field1;
@SubSet(field1;1)

The first line is only to ensure that field1 value is fetched correctly.
The @Subset command yelds the first (or only) element from field1.

That's all.

Regards,
zvonko
0
 

Author Comment

by:GaryZ
ID: 6410152
Working great. All I need to do is write an agent that would delete one of the occurances.

What I did was create 2 fields (FIELD1, text, editable) and (FIELD1a, text, computed, allow multiple values, hidden).

After the user finishes filling in the field, they click a button to proceed to next location the button has the following formula:

FIELD FIELD1a := FIELD1a + FIELD1 + @NewLine;
FIELD FIELD1 := "";
FIELD Location := Location + 1;

@Command([FileSave])

Then the view formula displays depending on what location the user wants to see.
0
 
LVL 10

Expert Comment

by:zvonko
ID: 6410392
Congratulation!

it's always good to have own experience and not cut'n pasted code not knowing exactly why it is working.

Anyway, thanks for the points and for the feedback. <|;-)

Regards,
zvonko
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

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…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

707 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