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.

1 Like

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

Booking slot Calendar

Related topics