Staff Availibility Calendar

[Dion1score]

I have a simple sharepoint list I plan to populate with about 30 employees. I need to generate a dashboard that displays a staff schedule for a given day in a pay peroid. A manager wants to click on a particular day, or support area and see the level of support they have for a given day. This is mean to be a static schedule not a calendar.

Should I create 2 separate pages for the 2 weeks in a payperoid? or should I have all 10 days in a table with 30 employees names in the first column?

This is the sharepoint dataset that I plan to have staff populate with their normal work schedule of teleworking, in office, or out of office. I also plan to group by Support Area.

[Anonymous]

Hi @Dion1score ,

First, let's analyse the case when all 10 days are in one table:

   1.Putting all 10 days in a table with the names of 30 employees in the first column is an easy way to do this.
      Pros:
          Comprehensive view of the entire payment period at once.
          Easy for managers to plan and adjust schedules.
          Allows filtering or sorting by specific dates or support areas.
     Disadvantages:
          If there are many employees or other information, the table may become large and less readable.
          May require horizontal scrolling to view all dates.
          Limited customisation options for individual dates.

  2.Two separate pages (one per week):

     Pros:
         Smaller tables make it easier to focus on specific weeks.
         Less cluttered interface.
         Customisation options for weekly layouts.
     Disadvantages:
        Manager will need to navigate between pages to view the entire payment period.
        May require additional clicks to compare different weeks.
        Design and setup work may be duplicated for each page.

I think you could choose a single table containing all 10 days and add filters to it to allow customers to select the corresponding dates

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.