Solved

Multiple occurances of same field

Posted on 2001-08-20
7
146 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
Comment Utility
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
Comment Utility
Running Domino 5.0 and the application is on the web. There are around 70 fields involved.
0
 
LVL 10

Expert Comment

by:zvonko
Comment Utility
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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:GaryZ
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

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…
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.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now