Multiple occurances of same field

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.
GaryZAsked:
Who is Participating?
 
zvonkoConnect With a Mentor Commented:
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
 
zvonkoCommented:
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
 
GaryZAuthor Commented:
Running Domino 5.0 and the application is on the web. There are around 70 fields involved.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
zvonkoCommented:
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
 
GaryZAuthor Commented:
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
 
GaryZAuthor Commented:
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
 
zvonkoCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.