I have routines to do edit history on the web and client, and I am now trying to put all the code in one place. I do thank all the people who have posted their ideas in here, since I do get a great many. In any case, this is concept - but it is still untested.
In the form on the web, the open event will take a copy of the document and place it on a iframe (not sure in the agent or the JS header. when the document gets closed, it will retrieve the document from the iframe and check to see if any fields have been changed I guess this would go in the webquerysave in a lotus script agent.
If any body has done this before, have you had any issues?
If this logic is flawed, can you tell me.
Note: I am not looking for the code, just posting an idea.
What i did to audit the fields was to create a new Temp document with web query open and place all the field values on this form. This doc would sit in a view using a random number and username as the key (place this value on your working form for retrieval purposes)
On submit the doc is then retrieved via webqueryclose agent and values compared.
To sort out the fields i wanted to audit from fields that were not necesary to audit. i created a profile form that contained field names with Field Explanations i.e. e.g. NoOfUnits~~Number of Units Left being fieldname and right being explanation.
All changes would then go into a history field at the bottom of the form.
The Temp forms would be deleted automatically via an agent after a couple of days
Anyway it works quite well for me and is easily adaptable to ther forms
That is what I did as well. I just did not like the fact of creating documents in the dB, and then deleting them. More so, because I had a user who once had the document opened over the week-end, and got an error when saving. I fixed the issue, but I am just looking for a more elagant way or storing the original document in the form.
If you do go ahead and do it your way, i would be interested in seeing the result or code or even offering suggestions as i often have to do audit control on formsyou can contact me on adslotgr(AT)tpg(dot)com(dot)au