How can insert an alert an Resources Database

KevinSoong
KevinSoong used Ask the Experts™
on
I want to add an email alert function in the resources database for a same user continous and fully book room for 2 days or more.
Anyone can sent me any idea how to calculation this function.

Kevin
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Create an agent in our resource database.

Schedule the agent to run "After new mail has arrived".

Formula:
SELECT (CalendarDateTime - EndDateTime) > 60*60*24*2;
sendTo:= "John Doe/ou/o";
copyTo:= "";
blindCopyTo:="";
subject:="Resource booked for more than two days";
remark:="Document link to resource reservation:";
bodyFields:="";
@MailSend( sendTo ; copyTo ; blindCopyTo ; subject ; remark ; bodyFields ; [IncludeDocLink] )


NOTE: I wrote this just now in 3 min. Have not tried it. Its for you to test and explore.

Author

Commented:
The agent seem not fullfill my reqest, the calculate cannot cal for multi value on Caldatetime and Enddate time.

If some can told me how to list the multi-value minus multi-value last valus in View then you will win 200 points
Commented:
If you just want to compare the last values in the a mulitvalue list then change this line in the exampler:
SELECT (CalendarDateTime - EndDateTime) > 60*60*24*2;

To:
SELECT (@Subset(CalendarDateTime; -1) - @Subset(EndDateTime; -1)) > 60*60*24*2;

If you want to test all values in a multivalue list, then you need to use LotusScript - since @commands does not support looping (supported in R6).

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial