Solved

Multiple occurances of same field

Posted on 2001-08-20
7
148 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
  • 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
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.

 

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

Suggested Solutions

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…
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…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

808 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