I have an On Call system that I created that checks to make sure when someone adds a person to the schedule that it does not conflict with what's already out there.
I have them fill out Start Date and an End Date (these are Date/Time Fields). Have them click on submit that kicks of an active link Guide that loops through the table of the On Call Schedule. The first AL in the ALG sets the column Start Date and column End Date fields to temporary fields (from the on call schedule table) (tmp_StartDate and tmp_EndDate) Then the second AL in the ALG simply makes sure that the Start Date and End Date fields do not over lap ( 'Start Date' < 'tmp_EndDate') AND ( 'End Date' > 'tmp_StartDate') If they do, I have a tmp_answer field that says "Allow" or "Not Allow" The third AL in the ALG checks to see if that field (tmp_answer) equals "Not Allow" if at any time it does say "Not Allow" then an error message pops up and the ALG is exited. Hope this helps.... Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Tuesday, June 30, 2009 4:42 PM To: arslist@ARSLIST.ORG Subject: Re: Reservation/Scheduling in ARS ** Joseph, I had done something similar once. Its not that hard. For something like a reservation system you always invariably have an entity that you need to reserve, be it a room, a car, a seat in an aircraft or a bus, whatever, for a blocked period of time during which no one should be allowed to be able to access it. You need to check against both this entity and the start and end time that these do not clash with any combination of start and end time for the same entity. You also might want to design a wait list or a preferential queue, for customers requesting for the same entity, when it has already been booked in the event of a cancelation. And have this queue adjusted as and when they adjust their itenery, or the end date has passed whichever happens earlier. Joe ________________________________ From: Joseph Kasell <joseph_kas...@navyfederal.org> To: arslist@ARSLIST.ORG Sent: Tuesday, June 30, 2009 2:35:17 PM Subject: Reservation/Scheduling in ARS Hello! I wanted to canvass the group for ideas on the following scenario. One of our users is wanting to set up a scheduling/reservation system in Remedy for an application he manages, which has a finite number of accounts. What he'd like is a means for a user to sign up for account access to the app by blocking out a period of time. Should another person sign up for that account during that time block, he/she would get a popup indicating a conflict. I'm wondering if somebody out there has designed something which accomplishes this. Also, I don't have the funds to purchase a third-party solution, so that's out (things being what they are, our belts are tight here as well). We're using ARS 7.0.01 and ITSM 6. Appreciate the help! Joseph Kasell Senior Systems Engineer Navy Federal Credit Union _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
