Hello. I wanted to ask some advice on how best to collect information from team members to understand where they will be working for the following week (selectable from wfh, planned leave, offsite, office, etc).
The goal is to create a shared team calendar where each member of the team could see where everyone else was on any given day the following week. The entry in the calender would simply be a string - HR persons name followed by where they will be (eg Monday 1st might contain John Smith - wfh, Jane Doe - Office etc).
I dont know the best way to structure/capture the date info. I was thinking of using a simple form (I dont think UR would work as we would want a historical record of where the team was and a UR would overwrite this each week). but I would need to capture their whereabouts for 5 days of the week, not just 1. And the calendar view only allows you to select one field to display dates so I cant create 5 dates fields named monday date tuesday date etc as this wont display in the calendar view.
I suppose I could prepopulate the base sheet with their names and dates complete for them to select whereabouts for 5 lines but thats not really elegant and Im sure there must be something better. We dont have the calendar app but would consider if this was something that it could support?
Any help/suggestion appreciated. Thankyou