Need a solution for tracking employees in the office
I have been tasked with creating a "calendar" in which our employees can sign up to be physically in the office so we can monitor numbers. Right now we can only have 25% of our employees in the office at any one time. I can do this in SharePoint but we are currently using on-prem so people need to be connected to VPN and there is no mobile option like we would have with SS.
- People need to be able to sign up for a date or range of dates. If someone is in for a full week we don't want them to have to fill out 5 forms.
- No more than X number of people can be in the office at any one time. This number is 12 currently but will increase as COVID rules relax.
- Once X number of people have signed up for a particular date we want to prevent people from picking that date (or give them a visual that shows a particular date is "full")
- Ideally we would like a calendar view that shows available slots for any particular day. We don't want to see 12 or 25 names on a calendar, that will get messy but we would like some sort of visual on a calendar for capacity for any given day.
Has anyone already cracked this nut?