Is there an intuitive or functional way to use SharePoint (office 365 version) to manage employee weekly shifts?
Instead of just spreadsheets, SharePoint can allow our dispatchers can find an available tech by searching all of the metadata such as regions or cities.
I have already built a list to do this, grouped by region and subgrouped by week, and our dispatchers are loving it because it allows them search the name of the city they need service in and find a list of available techs (from over 100 techs)
However, it's currently very frustrating to manage by our managers because each tech's shift changes every week. That is currently the biggest challange because it consumes a lot of time of our managers to add each tech for each week, months worth of shifts for a 100 techs.
I tried looking into workflows that can duplicate weeks worth for each submission, but that's work in progress.
I was hoping there is a better way, such as the SharePoint Calendar app or InfoPath+Workflows that can add multiple weeks ahead. I've also tried Microsoft StaffHub, but it has no search function.