Lotus Notes – Move infomation from one field to another in selected documents

25 pts.
Tags:
Database
Lotus Notes
Lotus Notes Formulas
I have been attempting to write an agent to copy information form one field (e.g., Location A) to another field (e.g., Location B) for selected documents (some documents need Location B filled in where others don't in a Lotus Notes database with a large number of documents). I first tried the following (but this coding made a copy of the entire document, instead of copying the information from the first field to the second):
@Command([EditGotoField];LocationA);@Command([EditCopy];LocationA);@Command([EditGotoField];LocationB);@Command([EditPaste];LocationB);@Command([FileSave]); @All
Then, I found the @GetField command in IBM's help which looked promising. However, there are limited examples (none of which seem to be what I need). I tried the following, but it did not yield the desired result (it shows a search box which appears to show what was last pasted to my clipboard).
@GetField(LocationA);@Command([EditGotoField];LocationB);@Command([EditPaste];LocationA)
As a newer developer, I would appreciate any tips on how to accomplish this in formula language. Thanks in advance!


Software/Hardware used:
Lotus Notes
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Try @SetField( “LocationB”; @GetField( “LocationA” ) )

 

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: