troubleshooting Question

Lotus Runs Formula Agent on Selected Documents

Avatar of abissa
abissaFlag for Switzerland asked on
Lotus IBM
7 Comments1 Solution4498 ViewsLast Modified:
Hi to everyone,

Here's my problem: I have two database, one old and a new one created using old one's template.
In the new one, I have added several fields in the Request form.
I have to import a lot of documents from the old one to the newer one.
Copy/paste works fine, yet I have to update all those documents to integrate the new fields.

I created an Agent called "UpdateRequest" which uses Formula Language.
One of the formula is a DbLookup.
The agent works perfectly on a highlighten document when, as Target, I select "None", but fails if I select "Selected Documents" (Lotus prompts a message saying that certain @Functions cannot be used when "Selected Documents" is the agent's target chosen.

so, I want to create an agent in lotus script that runs for each selected document my "UpdateRequest" agent. I did but got the same error message (@Functions cannot be used....)

I have tried putting my formula language in a script agent. yet the Evaluate function fails. It works fine with formula like @Word, @Contains...yet it fails with the @DbLookup.

If someone knows either how to Evaluate the @DbLookup formula in lotus script, or how make the formula agent runs on Selected Documents, it would be appreciated!! (otherwise I will have to launch the agent manually on each document...more than 3000...no way!)

for information, my DbLookup is used to retrieve from the Domino Directory the mail server dpending of the user name (i.e for a specified user, check on which server we have registered him) - so basically my DbLookup returns the name of the mail server.

Okay, if you need more info do not hesitate to ask.

Thanks by advance to all of you!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 7 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros