Javascript for changing field values when doc saved through web


I have the following formula in the QuerySave event on a form in my database:

FIELD Comments:=Comments;
FIELD UpdateHistory:=UpdateHistory;
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.

Can somebody supply a method of doing this, im guessing it will involve javascript.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sjef BosmanGroupware ConsultantCommented:
As you might know, a lot of events don't work from a browser. In this case, where you don't actually test anything, you can create an agent with the same code, and put the name of that agent in the call prepared under WebQuerySave. The agent will be executed when the web-form is saved.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sjef BosmanGroupware ConsultantCommented:
JavaScript is very handy when you want to validate field values in the browser without having to call the server to do that.
Dev2003Author Commented:
ok have done that....but now when creating a new document through the web the document wont even save now.

the call in WebQuerySave is this:

@Command([ToolsRunMacro]; "UpdateHistory")

and the agent code is the same:

FIELD Comments:=Comments;
FIELD UpdateHistory:=UpdateHistory;
txt:=@If(Comments!= "";@Text(@Now)+"  "+Comments+" ("+@Name([CN];@UserName)+ ")"+@NewLine+UpdateHistory;UpdateHistory);

which is set to 'modify documents'

when the save button is clicked it closes the document but the doc does not appear in the view. it has not been saved.

the save button code is:

Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Sjef BosmanGroupware ConsultantCommented:
Check the Designer Help database, you have to set a different type of agent. Sorry, got to go...
Sjef BosmanGroupware ConsultantCommented:
From that Help database:

Setting up a Web agent
Using the Agent Properties box, do the following:
- Check the "Shared" option when you create the agent.
- Set the agent trigger to "On event" and either "Agent list selection" or "Action menu selection."
- Set the agent target to either:
   - "None" for agents that work on the current document such as those launched from
      WebQueryOpen or WebQueryClose, or a form action or hotspot that works on fields
      in the current document.
   - "All documents in database" for agents that work on existing documents such as those
      launched from the OpenAgent URL or a view action. The actual documents processed
      depend on the agent code, for example, the SELECT statement in a formula or the
      UnprocessedDocuments property in LotusScript.
- Check "Run as web user" on the Security tab to run the agent using the browser login name. Otherwise the agent runs with the rights of the agent signer.
Dev2003Author Commented:
does anybody know what security settings and/or type the agent should have?

the database is only accessible from the web once a user has logged in
Dev2003Author Commented:
thats it......

set the agent as:
agent list selection
agent target as 'None'
and 'Run as a web user'

works perfectly,

thanks sjef
Sjef BosmanGroupware ConsultantCommented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.