Hello I did something similar to this a few years back. It was for an on call rota (our system is totally bespoke). We have a separate interface for user creation and adding/removing users from groups, it just uses string functions to amend the group list and keeps a separate audit record up to date.
Our on call rota has elements of what you outlined and has the option of saying that between <Start Date> and <End Date> the user could be available only on specific days of the week or only at specific times. e.g. User 1 only works Saturdays and Sundays from 9am to 5pm, for the whole of June and July Manager 2 is on call every day of the week, from 5pm to 11pm. There was a radio button for each day of the week for data entry and that information would then be transferred by filters to a character field, which would contain all the weekdays for that record (e.g. for Sunday and Monday it would contain "12" and for Tuesday, Wednesday and Friday it would contain "346" . The workflow (or table qualification, depending on what you need) would work out today's date and today's weekday then look for records valid between start date and end date where the weekday field was LIKE "%"+today's weekday expressed as a number. That's just a very brief overview - but it does sound as if what you are suggesting would be useful to have. I suppose an additional thing we don't have would be the idea of a recurring rota - e.g. you could automatically add data for every other week, same kind of idea as recurring calendar appointments in outlook. You would probably need to have more than one on call person for any given time period so you might want a field to use as sort order as well. It'll all become clearer as you work out all the different scenarios you need to cater for. Sounds like a fun thing to develop! All the best, Isabel From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Cantatore Sent: 14 April 2016 19:39 To: [email protected] Subject: Group Management \ Oncall Schedule ** List, I'm fishing for some ideas and/or guidance if someone has built something like this already. I was toying with the idea of building Group Management \Oncall Schedule function within Remedy. I was thinking useful features would be to: * Request user to be added to group - auto creates a ticket to my team * Remove user from group - removes user from group * Set Oncall Schedule * Export Groups with Members * Export Oncall Schedule * Right now this is just an idea in my head, no one has actually asked for this, but I'm thinking this could be highly useful. Of the features I listed above, I'm not sure how the oncall user interface should work. Easiest would be providing a start / end date, but ideally I'd like the user to be able to pick some sort of rotating schedule. I'd appreciate feedback from the list on any of the above. _ARSlist: "Where the Answers Are" and have been for 20 years_ Glasgow - UK Council of the Year 2015 ***Disclaimer**** This e-mail and any attachments are for the intended addressee(s) only and may contain confidential and/or privileged material. If you are not a named addressee, do not use, retain or disclose such information. This email is not guaranteed to be free from viruses and does not bind Access in any contract or obligation. SERVICE GLASGOW LLP trading as ACCESS Registered in Scotland. No: SO301705 Registered Office: 220 High Street, Glasgow, G4 0QW _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
