I am recreating Calendly and looking to give the User (Host) the ability to set their Weekly Availability as well as their Availability on specific dates. Meaning they can say “I’m available Every Monday 9-5, Tuesday 9-2, Wed 10-4, etc”
I was able to do this successfully when showing the Calendar in the Host’s Time Zone, by creating 7 pieces of Data (Availability) representing each day of the week.
Day of Week Text = Monday
Day of Week Number = 1
Available Times = 2:00pm, 2:30pm, 3:00pm, etc
Host Time Zone id = xx
This works great when I put this availability on a Calendar that is in the Host’s Time Zone, because their Monday Availability will always be on a Monday. But because of Time Zones, these available times aren’t always a Monday to someone else in the world.
What I want is for the Availability Pattern to be Time Zone aware, which I think would mean structuring how I save and user Patterns differently. As in the example below on Calendly, a Monday Availability in Canada can easily be a Tuesday Availability in Japan.
Example in Calendly - Toronto:
Same Calendar, but in Japan’s time, notice how the times to book are the same but the days of the week are now different:
The only solution I have thought of is creating a Pattern using Date/Times for a long timeframe, such as Month Pattern, and saving each individual date’s availability as an actual item instead of a pattern, but this has obvious drawbacks (hundreds of List items)
Anyone have any ideas how to make a Weekly Pattern timezone aware?
I’ve been deep in the weeds thinking about this one, so if anything isn’t clear above, it’s me, not you, so ask away for clarification