🎓 Glide Tutorial - Simple Booking App

In this video I explain how to create a simple booking app in Glide. There are plenty of ways to achieve this, but so far this seems like the simplest! It utilizes what is known as a "Helper Table" to check for double-bookings on the fly and only allows users to select time slots that are free.
🎓 𝗝𝗼𝗶𝗻 𝗟𝗼𝗾𝗼𝗱𝗲 𝗦𝗰𝗵𝗼𝗼𝗹 (𝗙𝗥𝗘𝗘) 🎓
👉 www.skool.com/loqode
A free community that helps people level-up their Glide skills & make $3-15k+ per app as a Glide developer. Join for tips, tutorials, scripts & more!
🛠️ 𝗛𝗶𝗿𝗲 𝗠𝗲 𝗧𝗼 𝗕𝘂𝗶𝗹𝗱 𝗬𝗼𝘂𝗿 𝗔𝗽𝗽 🛠️
👉 www.loqode.com/development
🔥 𝗔𝘄𝗲𝘀𝗼𝗺𝗲 𝗦𝗰𝗿𝗲𝗲𝗻 𝗥𝗲𝗰𝗼𝗿𝗱𝗶𝗻𝗴 𝗦𝗼𝗳𝘁𝘄𝗮𝗿𝗲 🔥
👉 bit.ly/loqode-screen-studio
⭐️ 𝗖𝗼𝗻𝘁𝗲𝗻𝘁𝘀 ⭐️
⏱️ (0:00:00) Introduction
⏱️ (0:00:05) Loqode Community Question
⏱️ (0:00:38) Demo
⏱️ (0:01:42) Tables Setup (Bookings, Booking Form, Booking Helper)
⏱️ (0:06:38) Booking Submissions

[@jpmarques2011]

Thanks a Lot! I was looking for this feature. Work's fine

[@farmtofamily2596]

Thank you! I am following along to create a booking app for tutoring. I don't understand the Row ID for the users. I see you refer to row id for the booking form. Why not just link to name? How do you have those folders at the top: "User", "Date & Time" ... etc? Also, how are the row id and user id numbers generated? Does the user choose their id? I would also like to add subject matter and a note for exact topic of the session that is posted in the calendar.

[@loqode]

You're welcome! The reason we use ID's to create relations instead of names is because row id's cannot be changed. If we created a relation based on the users name, and they changed their name, the relation would break 🫠 To create the folders, just add /. For example, User/Name would create the User "folder" and then any other column that you start with "User/" can be grouped. The row ID's are auto generated (Basic Column > Row ID).

[@davidjordan9365]

The project looks interesting but I've noticed a pattern of Glide tutorials where the app is explained in terms of WHAT it is, and not so much of HOW to actually do it. If there is a video of the how part, I'd like to be directed there. The projects are super cool and I love Glide. Thanks!

[@loqode]

Hi David! Thanks for watching 🤝 What are you looking for exactly? This tutorial explains the how with regards to the tables & logic, are you looking for how to configure the front end? Or more of a "build from scratch" style tutorial?

[@davidjordan9365]

@@loqode Hi, thanks for the reply. The "build from scratch" style would be amazing. Reason being, I can follow alongside a tutorial and then gain better understanding of the how, why, when, etc. Then I'm good to take what you teach, and start building. A lot of the tutorials on the glide documentation, the apps are already built out and it's tough to get started.

[@loqode]

Got it! Makes sense, I'll take that into account for my next videos! In the meantime, if you want to continue levelling up you're welcome to also join Loqode School 👍

[@ambern4393]

What if I need a calendar for each individual user? Some users will have different meetings is there a tutorial on that?

[@loqode]

You can simply add a calendar and filter to each specific user!

[@mAistersvideos]

I have tried to replicate this app but I am going through the issue that the time slot you add on the helpers table doesn’t match with the time slots on the real calendar. Why is it that? Or how to fix it?

[@loqode]

It could be related to time-zone differences? Try formatting the date first and see how you go (Experimental > Date & Time > Format Date).

[@apartmadeira]

Good afternoon, you have made a calendar in a very interesting way. But I have broken my head and do not understand how to modify your version, if I do not need to choose the time, but to analyse the booking with the start date and the end date. How to remove possible double bookings and what is the best way to store and filter in this case. Thank you

[@loqode]

For those that are curious, here's the answer I gave in Loqode School: www.skool.com/loqode "I use a list of dates between dates. For example, someone selects a start date, an end date, and then my helper table creates a list of all dates between these two dates. These dates are stored as a text list (text column) in the Booking when it's created as a simple list (e.g. 1st June 2023, 2nd June 2023, 3rd June 2023). The booking form looks up all of the dates, and if the user selects a start or end date that is already taken, it shows a notification saying "These dates are taken".

[@melvinjongen1697]

@@loqode 404 Error Sorry, this page doesn't exist.

[@loqode]

@@melvinjongen1697 Thanks for pointing that out! Edited the link 👍

[@melvinjongen1697]

Can you make a video how to set it up

[@loqode]

Hopefully the new video in Loqode School helps 👍

[@Misterunbothered]

​@loqode I'm in loqode School, but i don't see the video of how to set this up

[@loqode]

​@@Misterunbothered If you search Bookings in the search bar there are a few different videos that cover booking apps 👍

[@Misterunbothered]

@@loqode I found different booking videos but is there one that shows how you put it all together. Step by step guide so to speak.