Search code examples
lotus-noteslotus-dominolotuslotusscript

Which folder a document is in Lotus Domino


Is it possible export (@whichfolders) from Lotus to excel?

I created a view, with column "folder", with function @whichfolders.

On lotus view this configuration returns the correct info but, when i try export this view to excel, excel "print" a strange characters...

Lotus: "Inbox/resolved"

Excel: "c^_"

tks!


Solution

  • According to the docs, @WhichFolders is a very specialized formula intended only to be used in the mail template. It may not be built to support exporting properly from a view.

    I would try, however, wrapping the formula in a call to @Text, just to see if that helps.

    @Text(@WhichFolders)
    

    http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=%2Fcom.ibm.designer.domino.main.doc%2FH_WHICHFOLDERS_FUNCTION.html