I've decided to go with Fred's suggestion and just have the user click on a start time and end time as to when they are on call.
One question, have you had any problems with DST? Grooms, Frederick W wrote: > > No. None of the users have asked for that option (shhhh, Dont give > them the idea). Our on call data is like... > > Group User Start End > Remedy Fred 2/6/2008 8:00 AM 2/13/2008 8:00 AM > Remedy Fred 2/13/2008 8:00 AM 2/20/2008 8:00 AM > > Fred > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Thursday, February 21, 2008 1:48 PM > To: [email protected] > Subject: Re: On Call System > > > ** > Another question, do you have a recurring option? So someone could > enter a start date and end date (let's say 5:00pm to 7:00am) and then > "recur" that for 7 days or weeks or months? > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W > Sent: Thursday, February 21, 2008 2:39 PM > To: [email protected] > Subject: Re: On Call System > > > ** > What we do here is give the user's start and end fields so we don't have > to have a record per day. A group that may have 1 person on call for a > week would only have 1 record instead of 7. When displaying the on call > we show any record whose start <= $TIMESTAMP$ and end >= $TIMESTAMP$. > > To validate on Submit or Modify we check that the Start Date/Time = an > ending Date/Time for the same group (or this start is in between another > records start/end dates). > > Showing it in a calander is a bit trickier but can be done. > > Fred > > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa > Sent: Thursday, February 21, 2008 1:01 PM > To: [email protected] > Subject: Re: On Call System > > > ** > The application is going to cover a year. Each group is going to have > their own oncall schedule so that our help desk knows who to call after > hours for an urgent ticket. We are a 24/7 shop. > > It's all in Microsoft Access right now (a different access database for > each group that I tie in all together through a website). It's horrible > to maintain, so we are going to develop something in the AR System > (7.0.1 Patch 005, Windows 2003, Oracle 10i) > > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Ben Cantatore > Sent: Thursday, February 21, 2008 1:48 PM > To: [email protected] > Subject: Re: On Call System > > > ** > Lisa, > > Can you provide a little more information about your app? For example > how is the user prompted for his/her oncall schedule? What period of > time does this cover, week, month, reoccurring, variable? Just off the > top of my head, if you were getting the users to enter their oncall > schedule for let's say a month, then all you need to do is a tablewalk > check for days missing between the beginning and end of the month. > Assuming this was a 24/7 shop. > > > Ben Cantatore > Remedy Administrator > Avon > (914) 935-2946 > > > > "Kemes, Lisa" <[EMAIL PROTECTED]> > Sent by: "Action Request System discussion list(ARSList)" > <[email protected]> > > 02/21/2008 01:11 PM > Please respond to > [email protected] > > > To > [email protected] > cc > Subject > On Call System > > > > > > > ** > > I'm creating an on call system for our company and I would like to make > sure that the end user does not accidentally skip a date or a time. > > So when they are entering information as to who is on call I don't want > (this would be in a table): > > Feb 20 Lisa Kemes > Feb 22 Lisa Kemes > Feb 23 Lisa Kemes > > I would like them to see: > > Feb 20 Lisa Kemes > Feb 21 > Feb 22 Lisa Kemes > Feb 23 Lisa Kemes > > Is there any easy way to do this? (other than creating a separate table > with every hour and date on it). > > Just wondering/brain storming.... > > Lisa Kemes > AR System Developer > Tyco Electronics > 717-810-2408 tel > 717-810-2124 fax > [EMAIL PROTECTED] > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > Answers Are" html___ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/On-Call-System-tp15617543p20254264.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
