Hi,The user wants to run a command from a view, to send selected documents to a person. But the report sent to the person, should display a doc link to the selected docs and some other fields.
For example, the report should containt.
Doc # | Doc Link | Client(s) | Comments | Responsible Person(s)
Where Client(s) is a multi-value fieldin the document and Repsonpsible Person(s) is also a multi-value field.
So the report must look, something like this:
Doc1 | Link | Client ABC | This is his comment | Lexi Bruwer, Joe Soap
Doc2 | Link | Client DEF | This is your comment | Jennifer X
etc
I thought of restricting them to select only 10 at a time, and then to create a Report form with 10 rows for each column, and populating those fields with the info above, but how would i do the Doc link?
Thanks in advance
Subject: Advice on Report Please
If you are going to create a report form with a limited number of ‘set of fields’ to store information for each document, you can create a hidden field for each document that stores the UNID of the document. Create an action hotspot serving as link to open the document based on UNID (value of the hidden field). You can use GetDocumentbyUNID of NotesDatabase class for the action hotspot to get the doc.
But why not write the information in a rich text field? that way you don’t need to limit the number of documents.
Also look at the cool built-in feature: select documents in the view, go to Edit | Copy selected as table and then paste in a rich text field (e.g. body of a new memo). This automatically creates something near to what you want
Subject: RE: Advice on Report Please
Thanks guys, I can do select and copy as table, but they would need to know which ones they have sent on to the relevant people. I know how to get the collection, but wasn’t sure about the doc links. Would need to dig a bit more.Thanks
Subject: Advice on Report Please
It would be intermediate-level Lotuscript programming to grab the document collection of selected documents, create a new email document, create a rich text field on it, create a table in the rich text field, and populate the cells with the corresponding data from the documents, including a document link.
However, for a quick and simple solution: have you looked at ‘edit>copy selected as table’? The user could select documents, click edit>copy selected as table, open a new mail memo, and paste into the body. You’ll get most of what you are looking for without any programming…
hope that helps…
Subject: RE: Advice on Report Please
I have found this on the forum, very helpfull and worked wonders for me! Thanks guys!
http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/e80b2cbf2c39ba538525711a006a57b7?OpenDocument