• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

Javascript for changing field values when doc saved through web

Hi,

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);
@SetField("Comments";"");
@SetField("UpdateHistory";txt)


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.

cheers
0
Dev2003
Asked:
Dev2003
  • 5
  • 3
1 Solution
 
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.
0
 
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.
0
 
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);
@SetField("Comments";"");
@SetField("UpdateHistory";txt);
SELECT @All

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:

@If(@IsDocBeingEdited;@Do(@Command([FileSave]);@Command([FileCloseWindow]));"")
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Sjef BosmanGroupware ConsultantCommented:
Check the Designer Help database, you have to set a different type of agent. Sorry, got to go...
0
 
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.
0
 
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
0
 
Dev2003Author Commented:
thats it......

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

works perfectly,

thanks sjef
0
 
Sjef BosmanGroupware ConsultantCommented:
:)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now