Evening all, Just starting out on an app idea for a local business. Have spent most of the past 2 days on the forums trying to find some inspiration. They want to have booking slots available for people to book their service. I am happy with the data logic behind booking out the slots, dealing wit…

What kind of issues are you running into regarding daylight savings?

Well, none as yet. I had a new thought about how to produce booking slots more efficiently than in my test app above. If I booked an appointment today, for the April 2nd 11am, that would be a specific point in time (maybe with Epoch). Once we arrive at that moment with the clock change would that n…

I can’t speak for epoch or specifically the ins and outs of it. My guess is that it has no knowledge of daylight savings. I spent some time a couple weeks ago converting a date to epoch to do some further calculations, but ran into some unrelated roadblocks because I was trying to convert year/mon…

That was pretty much my thought. For me the key was to have the booking slots viewable to book, rather than trying to book and it showing as unavailable. I am thinking of having a day laid out in 5 or 15 minute chunks, using the date picker, and then looking up what slots are available that day to …

I guess with what I mentioned above, you would be limited to looking at only one day at a time, but it would be easy to flip through days and have the template table update on the fly. With what I was thinking, you could conditionally show only the open slots as an inline list. So really, the way …

Yup. At the moment I have a sheet sitting there with 288 rows, thinking 15 minutes are probably ok, although I guess there logic would work with both. I was considering Epoch as I had come up with a way of blocking out multiple slots from 1 submission, but had a discussion and came to the conclusion…

Here is version 2. Thank you to @Robert_Petitto for his video on opening hours maths. Got me out of a frustrating hole. This app could really do with a time picker, or at least a restriction on the date/time picker to default to time view. Now time for the fun part with the booking logic, and preve…

[image] Mishta_P: Any advice about how to deal with privacy of bookings whilst also having data available to search for overlaps? I think your best bet would be to have a secondary “Add Row” action that adds the date and times to a separate sheet (without the identifying information of who su…

That was my initial thought, but might it not make things difficult of people want to change/delete their appointments?

Booking slot Calendar

Ask for Help

kyleheney February 28, 2021, 7:58pm 13

Hey! I’m rebuilding this app in Glide Tables and hope to get it submitted as a Template in a couple weeks. I think it does what you’re looking for — basically, I take the start and end time and figure out what times are before the start and after the end — those times are still available as choices, while the start, end, and times between them are not. My logic and use case uses 15 minute increments as times.

Topic		Replies	Views
Meet with Me: A Booking App that Prevents Conflicts Project Showcase	76	6552	June 30, 2021
🗓️ Simple Booking App Tutorial (No Double Bookings) Community Resources tutorial	35	2980	September 13, 2025
🎓 Advanced Booking App Tutorial (Step-By-Step) Community Resources booking , scheduling , tutorial	33	2589	January 18, 2026
Coming Soon: Reserve a Room w/ Recurring Daily, Weekly & Monthly Events Project Showcase	69	3283	September 6, 2021
Room Booking that prevents conflicts Ask for Help	34	3085	April 22, 2020

Booking slot Calendar

Related topics