We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Javascript for changing field values when doc saved through web

Dev2003
Dev2003 asked
on
Medium Priority
235 Views
Last Modified: 2013-12-18
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
Comment
Watch Question

Groupware Consultant
CERTIFIED EXPERT
Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
JavaScript is very handy when you want to validate field values in the browser without having to call the server to do that.

Author

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]));"")
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
Check the Designer Help database, you have to set a different type of agent. Sorry, got to go...
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
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.

Author

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

Author

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
Sjef BosmanGroupware Consultant
CERTIFIED EXPERT

Commented:
:)
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.