Web Based Staff Availability Form

[FLATcura]

Hey everybody

I am trying to figure out a way to have a document on our internal web server that the staff can use to submit what shifts they would be available for each month, and whether it would be for nights, days or evenings

Ive played with adobe live cycle, but the HR lady would need to have acrobat pro and have to import xml files attached for each employee email each month, shes a little old lady and i dont think shes gonna want to do that

basically im looking to have a php based form, pull the dates from a calendar so it shows each week in the selected month of that year, and listed as Monday to Friday, each day having a check box for nights, evenings and days

then the staff can enter their name, and click a button which will email the data to the HR lady as a similarly formatted easily readable document/email

i can handle the designing of the form, and i have a decent sendmail.php script. its referencing a calendar to call up what days of the week ie
January 3 - January 9 2011 is a Monday - Friday
January 10 - January 16 and so on

i might be biting off more than i can chew, but if anyone can help point me in the right direction, or knows of some tools or applications that would do a similar task, that would be greatly appreciated.

thank you very much

 

[RavinDJ]

Go with PHP... did you ever do any PHP coding?

Something like this shouldn't be too difficult, just make the form in normal HTML and the calendar is the only thing that will need PHP.

 

[PTNL]

I see many potential gaps in this plan...
- Email is "fire and forget". Is the system tracking a workflow that can be viewed later?
- Is it up to the HR person to find the best fit of everyone's availability, or would the system give choices for possible scheduling matches from everyone's factored availability?
- A user can submit their availability, but does the system evaluate any "temporary" or "approved" time periods to only show where coverage is missing?

Whether or not the above points are legitimate concerns can only be answered by the OP.

Regardless... Without knowing your skill level for implementing business rules and writing data calls (in any language), we can only speculate on whether this is too much... or even too much given a requested delivery date. Without doing a basic level of business analysis of the desired application, you can only speculate on whether this is too much.