The user needs to be able to select a number of documents from a picklist and then a table for each selected document needs to be created using a subset of information from the selected document(s).
Is there a way to create fields on the fly? I know how to create and format a table containing data, but I don’t know how to create the fields.
I need to have the fields as this document containing the tables, is being sent out as an email and the recipient needs to fill in a couple of fields per table and send it back.
Cheers for the help, my solution is as follows for anyone who is interested.
I’m using a form that just has the table in it as a template. So for every selected document, I am creating a new doc based on the template and then copying it into the document as a rich text item using RenderToRTItem. This is then repeated for all selected documents.
Subject: Creating tables and fields on the fly…possible?
I suppose the people who receive the e-mail all use Notes clients.I would create a document in a database and mail a link to the document. In the document’s form, I would use an interface like the database ACL window. This allows you to work with one ACL at a time. I would make a similar interface that allows the user to work with one document at a time. The fields are reused for each document, so there is no need to create fields on the fly.
If there is a genuine need for the users to work in their mail database, then I would use DXL to create an e-mail containing hotspots that collect the user input with input boxes.
It is possible to create fields on the fly using DXL or HTML. In either language, you simply generate the required tags. With DXL you might be able to use a form stored in the memo or a form that you generate in the user’s mail database, or a combination of the two. With HTML there are limitations on how you can get the data back, as you cannot use JavaScript to send a Notes memo in the back end.
This is way beyond the scope of the normal classes, which do not allow design manipulation. I guess in a real stretch you could do this with DXL, but I think you waould waste much more time than it would be worth. If a third party product is a possibility, our Midas Rich Text LSX will let you do manipulation of a stored form, which is what you would need to do, then you could send the stored form along with the message so the recipient could fill out fields.