Displaying a multi-value field along side single value fields

HCL Domino Domino Forum
1

This is a bit of complex one to explain.

I’ve got a form that has a button on it to create a comment. this button creates a new document with 3 fields on it: Name; Date; Comment.

I have a view with a column that concatanates these three fields to give

me - 11/11/03 - my comments

Then in my form I display this column using an @DBLookup

I want to make it so that you can have multiple lines in the comments and show it all in the same column.

eg.

me - 11/11/03 - line 1

          - line 2

          - line 3

My problem is that when I allow the comment to be multiple value (the others are still single) my formula does this:

me - 11/11/03 - line 1

me - 11/11/03 - line 2

me - 11/11/03 - line 3

My formula is:

@Name([CN];HDUser) + " - " + @Text(@Day(hddate)) + “/” + @Text(@Month(hddate)) + “/” + @Text(@Year(hddate)) + " - " + hdcomments

hduser & hddate are single value fields and hdcomments is a multivalue field.

I’ve tried everything I can think of to try and get it to only show the user and date on the first line of the comments and just run out of ideas.

Any ideas anyone

thanks

Tony

2

Subject: displaying a multi-value field along side single value fields

Hi, Tony!

What if you use you key as the name & date only? Your view would be categorised, and the 1st column would be “me - 11/11/03”. Place your “hdcomments” field in the 2nd column.

HTH!

Steve in Montreal =8D

3

Subject: Try: @Name([CN];HDUser) + " - " + @Text(hddate; “D0”) + " - " + @Implode(hdcomments; @NewLine)

4

Subject: RE: Try: @Name([CN];HDUser) + " - " + @Text(hddate; “D0”) + " - " + @Implode(hdcomments; @NewLine)

Thanks a lot bill, that worked a treat. I should have thought of that one!

Thanks for the answer Steve, but Bills answer was the one I was after.