I am figuring out how to design the data table structure for my timeslot. The issue is that I prefer to do it TB and not by some external solution (like Calendly), but the thing is that untill now I haven’t found a way to set it up in such a way that it’s doing what I want.
So, the aim is to let users/ visitors make a booking (time slot)… They must select a date(1) and a timeslot (2). A time slot is a 45 min period, each day between Monday and Friday. Time Slots are predefined, so they are from 09:00-09:45 - 09:45-10.30 etc until 15:45-16.30
I want all visitors only be able to book in advance for a maximum of 3 weeks… Not longer.
Here are my choices, I think
Option )1, regarding the date, I can use the Calendar component and add some local sauce on it with the @Chem language options, to show it local language… That’s great.
However, when using this setup, it’s not possible to ‘load’ the timeslots… Because in this setup each user can select it’s own time… And that’s not good, since it can create double bookings and user don’t know how long the time is they should book etc…
Option 2) So, the next option is, watch the video from @tim.young, where he explains the booking calendar…
This is a great video, but there are 2 things.
→ The booking time selection shows a date and time in 1 field. This is good, but imagine that a user can select all the possible timeslots for each day for the next 3 weeks… The dropdown will be (too) long and presenting it like date (YYYY-MM-DD- HH-MM-SS) in a table is kind of overwhelming… Try to select a date on your tablet… That’s why I prefer the calendar component from Option 1.
So, the most likely option is create a table with Dates and Times Slots and work with dependent drop downs… The TimeSlots will then be Select (Option) Fields instead of Times. But that also means that filtering on Times is not possible.
Also, when someone actually makes a booking in this system, I cannot update it, since the TimeSlot which is selected cannot be used as a form value. E.g. when a booking is made, I want to update the Table and update the row with and (example) to ’ Unavailable’ …
Also, building this table will be very very time consuming.
Then there is option 4)
Use an external booking system like Calendly… It’s not the best option, since Calendly has to communicate again with TB regarding the availability and processing updates to availability.
So, the preference for me is Option 1, since the Calendar display (for the dates) is great, also with the local language sauce. But the time slot thing isn’t making this work.
I am hoping that it’s clear what I am trying to achieve and I am hoping I am missing some kind of step in my think process to get this thing to work