Posted on 2006-03-22
I have the following formula in the QuerySave event on a form in my database:
txt:=@If(Comments!= "";@Text(@Now)+" "+Comments+" ("+@Name([CN];@UserName)+ ")"+@NewLine+UpdateHistory;UpdateHistory);
the form contains two fields......
'Comments' is editable and allowing users to enter a message
'UpdateHistory' is computed with a value of 'UpdateHistory'.
When the document is saved in a client the comment is added to the 'UpdateHistory' field as well as some extra information. The 'Comments' field is then emptied ready for the next time somebody opens the document.
This code works perfect through a Notes client but it does not work over the web which i really need.