This is a brainstorming question. Should be easy. I'm writing a scheduling program and I can't conceptualize how to accomplish what I need to. Here is the scenario:
1)You have a group of electricians, carpenters, and plumbers who log onto a RadSchedule and enter their various available days and times.
2) A person submits a request. "I need a plumber for 3:00-4:00 on 9/17/2010."
3) A coordinator gets the request and needs to be able to see that on that day and time, plumbers Joe, Ralph, and Veronica are available.
4) The trick is how do you show that Plumber Veronica is scheduled to work from 8:00 to 5:00 and then schedule her for the 3:00-4:00 slot while showing that she is still available for the remaining 8:00-2:00 and 4:00-5:00 slots? You would be deleting and recreating 3 different appointment records.
5) I need the database to simultaneously tell me that Veronica has an 8 hour block "available" and these are the parts of that 8 hours that are taken up already.
BAD ANSWER: Here is my current idea which really isn't a good solution. The plumbers, electricians, and carpenters all log onto the system and with radscheduler, they select their available schedules. I mark these with a resource named "Available". Now I can ask RadScheduler to tell me "Who's available on this day?" I then see that Veronica is available and I create a NEW and SEPARATE 3:00-4:00 appointment which shows up along side her "Available" appointment. Now I can see Veronica's usual schedule and those parts of it that are taken up already. Here is the kicker. This gets to be a mess when there are 19 plumbers available at the same time. You then must either toggle various appointments on and off or go through each person available and look at their schedules separately.
ANOTHER IDEA: I don't know how to do this because database programming with DateTimes is Hell on wheels but maybe Joe Electrician could log on and choose 8:00-5:00 on Tuesdays as being available. Then behind the scenes, you grab that 8:00-5:00 appointment and replace it with 18 separate half hour appointments between 8:00-5:00. Then the Coordinator receiving the request for 3:00-4:00 could just delete the "little" appointments and replace them with the new appointment time being scheduled.
I'm writing this here because I hope I'm missing something totally obvious in using RadScheduler. Maybe there is some combination of resources I could use that would accomplish this. I can' think of it though.
Thanks and Best to All!
1)You have a group of electricians, carpenters, and plumbers who log onto a RadSchedule and enter their various available days and times.
2) A person submits a request. "I need a plumber for 3:00-4:00 on 9/17/2010."
3) A coordinator gets the request and needs to be able to see that on that day and time, plumbers Joe, Ralph, and Veronica are available.
4) The trick is how do you show that Plumber Veronica is scheduled to work from 8:00 to 5:00 and then schedule her for the 3:00-4:00 slot while showing that she is still available for the remaining 8:00-2:00 and 4:00-5:00 slots? You would be deleting and recreating 3 different appointment records.
5) I need the database to simultaneously tell me that Veronica has an 8 hour block "available" and these are the parts of that 8 hours that are taken up already.
BAD ANSWER: Here is my current idea which really isn't a good solution. The plumbers, electricians, and carpenters all log onto the system and with radscheduler, they select their available schedules. I mark these with a resource named "Available". Now I can ask RadScheduler to tell me "Who's available on this day?" I then see that Veronica is available and I create a NEW and SEPARATE 3:00-4:00 appointment which shows up along side her "Available" appointment. Now I can see Veronica's usual schedule and those parts of it that are taken up already. Here is the kicker. This gets to be a mess when there are 19 plumbers available at the same time. You then must either toggle various appointments on and off or go through each person available and look at their schedules separately.
ANOTHER IDEA: I don't know how to do this because database programming with DateTimes is Hell on wheels but maybe Joe Electrician could log on and choose 8:00-5:00 on Tuesdays as being available. Then behind the scenes, you grab that 8:00-5:00 appointment and replace it with 18 separate half hour appointments between 8:00-5:00. Then the Coordinator receiving the request for 3:00-4:00 could just delete the "little" appointments and replace them with the new appointment time being scheduled.
I'm writing this here because I hope I'm missing something totally obvious in using RadScheduler. Maybe there is some combination of resources I could use that would accomplish this. I can' think of it though.
Thanks and Best to All!