I am developing a solution to see schedule resources (about 200 Cleaners) on weekly schedules. Almost all taks are repetive on a weekly or sometimes daily basis. I have assigned them all a customer etc. I have the basic structure of Client, Cleaners, Cleaning jobs (repeating jobs each get their own record).
What I am trying to do is to create a list layout which sorts the jobs by week and then cleaner, and then ideally a portal for each day of the week listing the jobs in time order. But I can not figure out how this would be designed in a simple way. Any ideas? It would be much appreciated.