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.

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

SearchWindowsServer
Search400
  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/Search400.com community. These cheat ...

SearchDataCenter
SearchContentManagement
Close