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!