Register and calendar integration
I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by filling in the form based on the availabilities they see on the calendar. I have setup a draft dashboard. The form in the dashboard is looking good but the calendar not so good (see attached screenshot). The calendar needs to somehow show all the slots available (12am - 11pm) on a daily basis at all the 5 different locations. Is there a way we could achieve this?
I also have set up a sheet that's driving the calendar (see attached screenshot). I think we need to think of a clever formula in the sheet to achieve this. Please help!!
Help Article Resources
Check out the Formula Handbook template!