Avoiding Overbooking using Smartsheet Calendar/DataShuttle
I am trying to create a booking system for a room with multiple stations.
Stations: 1 - 5.
Time slots: Morning, Afternoon, All Day
So far I have a dashboard with a calendar/form and separate sheet for the form submissions.
With the calendar, people are able to see other bookings, but ideally, I want to use DataShuttle to create a dynamic drop down in the form so that no one can choose a workstation and time slot that is already booked- either in the same time slot as them or if it was previously selected as "All Day."
Originally I had helper columns that would check a box if the station/date/time slot were the same. Then I was going to set up an automation to reach back out to the submitter.
But then I realized that it wouldn't work if someone has booked the station All Day so I've been playing with a few different attempts.
If anyone has any other solutions, I am open to any! Like I said before, I would like to use DataShuttle to only populate drop down options for the Stations/Time Slots based on the booking date and availability.
Is this possible with Smartsheet?
Help Article Resources
Check out the Formula Handbook template!