Solved

Lotus Notes Formula

Posted on 2007-11-28
4
2,741 Views
Last Modified: 2013-11-16
Hi,
 I wonder why what's happening with this codes.. it's an old program. ( it allowed duplicate booking/clash time)

@If(ResourceType="1" & Capacity="";@Return(@Prompt([Ok];"Error";"You must enter the number of attendees before you can find a room."));ReserveDate="" | TimeRange=""; @Return(@Prompt([Ok];"Error";"You must enter a valid Date and/or Time before you can find an available resource."));ResourceCategory="";@Return(@Prompt([Ok];"Error";"You must choose a Resource Category. If one is not available, there may be no resources available for the selected site."));"");
@Command([ViewRefreshFields]);
@If((@Date(StartDateTime) < @Date(@Now)); @Return(@Prompt([Ok];"Error";"You cannot reserve a room for a date which has already occurred."));"");
Keyarg:="CN=*/"+@If(ResourceType="1";"O="+Site;"OU="+ResourceCategory+"/O="+Site);
ResNameCheck:=@If(ResourceType="1";@FindFreeResource(Keyarg;ResourceType;StartDateTime;EndDateTime;Capacity);@FindFreeResource(Keyarg;ResourceType;StartDateTime;EndDateTime));
@If(@IsError(ResNameCheck);@Return(@Prompt([Ok];"Error";"You received the following error when trying to find a resource: "+ResNameCheck));"");
FIELD ResourceName:=ResNameCheck;
FIELD ResourceName:=@If(ResourceName="";"No resource/room found for times and/or capacity requirements.";ResourceName);
@Command([ViewRefreshFields])

0
Comment
Question by:wzm
  • 3
4 Comments
 
LVL 31

Expert Comment

by:qwaletee
ID: 20377855
Is there a question somewhere in there?
0
 

Author Comment

by:wzm
ID: 20379332
somehow after upgrading to 6.5 this codes not working, is the sense that it allowed duplication, supposedly it reject same time booking.
0
 
LVL 31

Accepted Solution

by:
qwaletee earned 50 total points
ID: 20379434
I have no context. I don't know if this is a button, an agent, an action, or something else. I don't know you fields.

It looks like it is a customization to either a meeting form in a mail file, or a resource reservation database, EIther way, it doesn't prevent double-booking so much as it just checks for an existing freetime entry for a "range" of resources. If freetime is out of date or freetime booking is not set up correctly, it won't work. You can see whether it is booking free time correctly by doing a lookup for the specific room, and see if blocked ranges exactly match reserved times.

(I'm not 100% certain of this -- the operation of the freetime system in Notes is a black art, and resources and rooms within that is a blacker art. WHat I've said is based on what I've observed in Domino behavior in t he past.)
0
 
LVL 31

Expert Comment

by:qwaletee
ID: 20906002
What was your finding?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to change default font size and font in Lotus Notes 9 6,451
VBA Lotus notes 2 195
Lotus Notes default email application problem 6 115
how to install domino server on suse linux 18 78
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Edureka is one of the fastest growing and most effective online learning sites.  We are here to help you succeed.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now