Do you mean web-based app, LAN -accessible app or just computer with an internet connection ?
You can send SMS/email from a stand alone machine . Excel macros can send emails and I was doing it 3 years ago from a rota spreadsheet.
I saw the CLWRota at ASM. - PHP + PostgreSQL .
We use spinfusion. http://www.spinfusion.com
- java app and jsp backend
there are also some standalone desktop apps around as well.
When i was a registrar 20 years ago in Sheffield, there was a guy doing an MSc in computer science modelling anaesthetic service delivery. (this is how I know that as a registrar I was doing 1800 cases a year). The main conclusion was that there was no real point in getting a computer to do the rota because it took as long putting the weekly changes in ( leave of various sorts, meetings, other requests) and then letting the machine do the rota , as it did actually doing the rota manually. I suspect things havent changed much in the interim. And then there is the fuzzy logic around lists as well. Computerising is useful for basic error-checking (duplicate entries etc) , but you don't need to buy an expensive product to do that. A computerised rota is an administrative tool.
What we actually bought the expertise to configure a web-accessible form that lets you put names in boxes. And the user interface is really really awful. but there again these things dont exist for the users.
Our troubleshooting is done by people gathering round the rota pinned to the noticeboard by the dept door, and someone with a pencil and an undo function ( eraser). We've thought about doing this on the computer in real time so it would be LAN accessible, but the technology , probably a touch screen, isnt affordable ATM and Health and Safety told us we couldnt do what we wanted where we wanted to (the corridor is too narrow). 3 people looking at a computer screen isnt the same ( weve tried).
There is too much crisis management around rotas and too many variables around the country for any sort of generic solution and the workflow isnt straightforward.
eg some are happy to be changed and will just grumble when they arrive - unless its a day when they have something they need to go to in the middle of the list and therefore have to have a reasonably experienced someone else with them (where will this be documented ? ) . Some insist on being asked. Some are intransigent b*****s and wont change unless other requirements are met.
how often can you wait for someone to pick up their email before you can confirm rota changes ?
have they picked it up
Have they read it but forgotten about it
have they read it but need to check things before replying
are they just not replying yet
Grafting SMS/Email onto existing systems shouldnt be too difficult
Just use the swiss army chainsaw of the internet
perhaps what is needed is a common dataset and take it from there.
location, surgeon , surgical speciality
primary anaesthetist (how do you define primary)
skills required (eg can an SHO/SG do this list)