I know that when moving a document to one or more folders, the field $FolderRef is populated on the document with respective UNID from the folder, ( The database must be setup for it, see → http://eknori.dyndns.org/knowledge/kbnv11.nsf/0/ac9eb8542e403d6485256a8f005cac5d?OpenDocument )
The problem is that you can only reference the FIRST value in that list using @formulas.
For example. A categorized view could give me all the documents that resides in each folder:
But using @Text($FolderRef)only gives me the first value, all the others are missing.
I know that i can use lotusscript methods to accomplish this, but isnt there any way using @functions?
Whats the magic with the “Response Reference List” - List?
Subject: $FolderRef - A List of “Response Reference List” ?
Are You using R5 or ND6? If ND6 - have You tested to loop through the field with @For() and reference each found item by $FolderRef[0], $FolderRef[1] etc…?
Just a thought…
Subject: RE: $FolderRef - A List of “Response Reference List” ?
Yes, i’ve tried that - it doensnt work.It seems that it cant be done, the only thing that seems to work is via LS and thats a pity i think.
Thanks anyway!
Subject: RE: $FolderRef - A List of “Response Reference List” ?
Have You tried to use @Implode?
If You get the full array as a single string, You could then @Explode it to have all the separate values accessed with the brackets format… Just an idea…
Subject: RE: $FolderRef - A List of “Response Reference List” ?
Thanks Kenneth for your time!
I’ve tried using variuos @fomulas for example: @implode,@explode, @text, @absctract without success.
It seems as if i have to work with lotusscript in either a wqo agent or calulating the relations whenever docs are saved.
I’ve seen a new @formula i R7 that displays what folders a document is residing in, nice feature, but not available/suitable for me.
Again, thanks!