Solved

Lotus Notes Formula

Posted on 2007-11-28
4
2,740 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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
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…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

757 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