copy item from own database to calendar in mail template

[Fret4u]

I have created a database which contains data that has to show up on a given date. In my mail template calendar I can copy a memo to the calendar as an appointment and in due time the alarm goes off. I want the same to be done with the data from my own database. Anybody knows a @Command or @Formula or agent which might solve my problem ? So that this particular data will be copied into my calendar from the mail template !

 

[pmonett]

The alarm functionality is, I believe, integrated with the mail db at the client level. In other words, I do not think you can copy that functionality to another db.
On the other hand, you can program an agent that will scan the db regularly and send out a mail to notify you when something is going to take place. An alarm, if you will, but that arrives via mail instead of via popup.
And given that many, many users have pop-up notification of new mail, you get almost the same result.

Pascal.

 

[Fret4u]

That would be an option. But could you help with the programming of such an agent. ? By the way, does this agent work on a database stored on a local drive ? Would really appreciate your help !

 

[pmonett]

Local dbs cannot run scheduled agents, so the answer is no, it won't work outside of a server.
Aside from that, I'd be happy to answer any question you might have, as will anyone in this forum.

Pascal.

 

[Fret4u]

I know that, Pascal, but it was my intention to run the agent manually from the menu. I thought that that would work. I already started with the formula's but I stranded when I was looking for a formula for selecting documents that meet criteria. This what I already brought together:
@If(Actiondate<=@Today; "(Formula for select document)";""):
@MailSend("abc.xyz@123.com";"";"";"Action required. Please follow this link";"";"";[IncludeDocLink])
Tell me what you think of that formula ? Can you help me to complete it ?

 

[pmonett]

Why store the database locally ? What is the interest in that ?

As for doc selection, I have found that if you want to control selection in code, it is best to use LotusScript - but that generally means that you go through the entire db (not good for speed).
If you want better performance, make a view that selects the documents for you, then your code can just cycle through the view on all documents - better speed and better reliability.

Keep the mailsend and make the view, and you'll be done.

Pascal.