Lisa, While displaying this, make sure you expand the keyword before you use it in table fields if you are using ARS V 7.
I had to bite my head off where I was getting a wrong output despite a correct criteria, in a table field qualification, because the keyword $DATE$ was not expanding to the correct value. Its a known bug.. I believe its the same problem with using the keyword $TIMESTAMP$ in the qualification in table fields.. Incidiently I was working back then on the same requirement! A On Call scheduling system.. Joe ----- Original Message ---- From: "Kemes, Lisa" <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, February 21, 2008 1:48:15 PM 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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)" <arslist@ARSLIST.ORG> 02/21/2008 01:11 PM Please respond to arslist@ARSLIST.ORG [EMAIL PROTECTED] cc SubjectOn 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] ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
