I’m new to Coda and looking for making a smart & automated employee scheduling app (if possible).
Could you provide some help?
A) Here is more information about what we need as an employee scheduling app:
At this time, we manage our employee schedule in Excel. It is not always obvious to schedule 60 employees and many departments by using a static Excel spreadsheet!
Below is how our spreadsheet is currently configured:
Top row: the 7 days of the week
First column: Employees names
Second column: Shifts are identified as; Morning, Afternoon and Evening and a Total row as well. Therefore, there are 4 labeled rows next right to an employee name.
There are 2 columns per day of the week. The first column indicates at what time the employee must begin to work. The second column indicates when the employee must pause working for lunchtime or for end of work.
Lastly, there is a Total labeled column at the far right of the table; to indicate the total number of weekly scheduled work hours per employee.
There is a Total row at the bottom of the table; to indicate the total number of daily scheduled work hours.
This would reproduce our current spreadsheet…
Next, how to make it smart and automated?
How to allow as much time saving as possible?
B) Interesting features to obtain:
For example, each employee has schedule constraints. Some employees can’t work in the evening, while others can’t work in the morning… Most employees are available to work only a few hours a week and some during the evening only, etc.
In addition, how about if an employee can’t work tomorrow morning or if he an employee requests leave? How to automatically notify the other employees in order to replace this employee?
Hence, is it possible to create something having such features while being as smart and automated as possible?
Thanks for your input!