asked on

Multivalue Field In View

Hi Experts,

My problem is i am trying to display a multivalue fields in a view as a separate document :-(

Have a form "New" having a fields
e.g "A" which is set as 'Separate Value When User Enters'= Semicolon & Newline
which is set as 'Dispaly Separate Value With'=NewLine

and so on , these fields get appended each time the user clicks on a button and the value gets stored.
e.g: the value it stores is like this at present :
Field A Field B Field C
1 Lotus x
2 Oracle y
3 Java z
4 XML a
5 MS SQL b

Though its a one document when saved, my problem is how to display this multivalue field as different document when viewed in a view.

Any tips / idea would be appreciated.

TIA

scottrma

Have you enabled the design property "Display multiple values as separate rows" for your view?

scottrma

Sorry, that should read "Show multiple values as separate entries" in R5, and it is in the design properties (sorting or 2nd tab) of the column, not the view itself. Make sure you enable this and then it should be working.

Regards,

Scott

Arunkumar

Well, here is a limitation to your requirement, you can have only one field that can be shown as multiple entries. If you try to show three fields like you have listed it wont happen instead it breaks up each one into a category into itself.

The best way i could think of if your lelements is less than 9 is....

Showing three fields in three columns and allowing 9 lines per row and shrink rows to content in the view properties.

Or just pick one field and show it as separate document.

Interestingly you can do a list concatenation to add FieldA, FieldB and FieldC as

1 - Lotus - X
2 - Oracle - Y
3 - Java - Z

etc and show this list value as separate entry in the view.