INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Brilliant! Your site is great...and saving me hours of time at work and making my boss think I am brilliant too! I also picked up on a thread that will potentially save us a lot of money in the future..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > MIS/IT > Groupware & Mail Products > Lotus/IBM: Domino Forum

Execute Notes field default formula from agent

Read More Threads Like This One

Alan327 (Programmer)

6 Oct 11 15:54

Domino Development - I have a form with total fields that derive their value from a @Sum(DBLookup) default value formula.   The totals update whenever the form is opened.  However, I want to update the totals WITHOUT opening the form.  I tried the following code in an agent with no success.  Can this be done?

Set viewC = db.GetView"(StudentProfs)")
Set docC = viewC.GetFirstDocument
Do While Not docC Is Nothing
  Call docC.ComputeWithForm(True, False)
  Call docC.Save(True, False)
  Set docC = viewC.GetNextDocument(docC)
Loop

pmonett (Programmer)

25 Nov 11 5:54

When you open a document, the form you use has access to the UIworkspace object.

When you run an agent, you cannot access the UIworkspace, thus your @Sum(@DBlookup) cannot execute.

You can use an agent, but you will have to replicate the calculation in the code and enter the result in the document for the result to correspond to your wishes.

Pascal.

I've got nothing to hide, and I'd very much like to keep that away from prying eyes.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Lotus/IBM: Domino