Creating a document through a scheduled agent that will get field values based off of another document
Posted on 2004-11-19
I have created database in Lotus Notes. The purpose of this database is to track scheduled ITV events. The simple side of the database is merely filling out a form with the pertinent information for the event. Fields in the event form are "EventTime", "EventLocation", "EventTech", "EvenEquip" and so forth. There are also several hidden fields within the form to compute values and such as well as send notifications to people when the are created, re-scheduled, or Canceled.
The part that I am having difficulty with is the following. I have created another form to be filled out and used in order to "automatically" create REGULAR, REPEATING events that occur, once a week, the 2nd Tuesday of the month and so on. I believe I have all of the coding that I need to have in this form in order to calculate it correctly. However, I can't seem to figure out HOW TO HAVE AN AGENT THAT WILL DO THE FOLLOWING:
At scheduled times, this agent will search the DB for all forms of name "Repeat1". The agent will then use that form to create a new form of name "ITV1". The field values of the "Repeat1" document will be used in the "ITV1" document that it creates. All scheduled ITV events use the form name "ITV1".
I am fairly proficient with Formula language. However, rather lacking with LotusScript experience. As such, the entire DB is done with Formula as of now.
Please let me know at your earliest convenience if you have a solution or a suggestion to this problem.