AnsweredAssumed Answered

How to create a resource scheduler

Question asked by user28397 on Oct 25, 2017
Latest reply on Oct 25, 2017 by philmodjunk


i made a really simple resource scheduler two years ago.

What i need to do is to mark the days of presence with a checkin field.

What i've done is 12 layouts, one for each month.

I have a table for people, a table for years and a join table. This join table link people and months and have

a repeating field (31 repetions for the days)

This way i can check, just visually, the presences for each person. But this is a great limitation.

Every year i need to make changes to the interface because for example one year the 1st of january is monday and the next year is sunday.

It's possible to have just one layout and the dates changes based on selected year?

And concerning the resources, what could be a database schema to do select a person's presence to a real date?