Time Table Schedule with Portals

[JohnnyZ]

Hello,

 

I am beginning a project that includes a time table schedule for employees, based on 15 minute increments.

The layout is for just one day at a time. Each employee is on a column, each row is a 15 minute increment.

 

I am contemplating the best strategy to provide the cleanest interface with the most functionality.

I was planning to use a portal for each employee column, and a separate field for each 15 min. increment (from 7AM to 9PM); but this seems like too many relationships, not to mention hard on reporting. I appreciate any thoughts you may have, as I am open to all ideas at this stage of development.

 

JohnnyZ

[Priyabrata]

Hi,

You can also use another related table "TaskSchedule" with the Employee table for the employees where new task can be scheduled every other day and the tasks scheduled can be related with the employees ID and the Current date.

And you can also use date field to filter the taskscheduled based on the date.

It would be a dynamic and easy to use and understand for any user.

 

I hope you like my Idea.

[JohnnyZ]

Thank you for your suggestion. Although there will be recurring events, most are scheduled ad hoc.

I was looking at a calendar solution called soSIMPLE. It seems like they went through a lot of trouble to make a modern calendar/timetable interface, but I was wondering if anyone was familiar with it.

Here is the link: http://www.paradisepartners.com/products/sosimple-filemaker-calendar/