Link to home
Start Free TrialLog in
Avatar of GaryZ
GaryZ

asked on

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.
Avatar of zvonko
zvonko

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
Avatar of GaryZ

ASKER

Running Domino 5.0 and the application is on the web. There are around 70 fields involved.
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
Avatar of GaryZ

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of zvonko
zvonko

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of GaryZ

ASKER

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.
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