Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Lotus Notes Formula

Posted on 2007-11-28
4
Medium Priority
?
2,766 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 200 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

[Webinar] Cloud Security

In this webinar you will learn:

-Why existing firewall and DMZ architectures are not suited for securing cloud applications
-How to make your enterprise “Cloud Ready”, and fix your aging DMZ architecture
-How to transform your enterprise and become a Cloud Enabler

Question has a verified solution.

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

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…
Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

916 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