Manage Learn to apply best practices and optimize your operations.

Displaying multivalue field value in view column formula as single document

If a multivalued field is used in a Notes view column formula , each value will be displayed as separate document.

By
  • Ilangovan Chandran
Published: 04 Oct 2001

If a multivalued field is used in a Notes view column formula , each value will be displayed as separate document.

Note: This problem occurs only if we use the column value as formula.
Solution:
Convert the list of values from multi value field into a string using @implode function and substitute the value in the formula.


 val := @Implode(Mfield); "<TABLE BORDER=0 CELLSPACING=0 CELLPADDING=0 width=100%> <TR VALIGN=top><TD WIDTH="120">"+ field1 + "</TD><TD WIDTH="180">"+ val +"</TD></TR></TABLE>" where "Mfield" is multivalue field .

Dig Deeper on Domino Resources - Part 3

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close