🗓️ Simple Booking App Tutorial (No Double Bookings)

[Darren_Murphy]

@Eric_Penn

What about making the slot unavailable because someone is simply looking at it…”reserved” if you will… same process? That could be a lot of rows?

Same situation still applies, yes. Reserving the spot still happens locally, and has to sync back to Glide and then to all other users. So there will always be a small window of time where collisions can occur.
The busier the App, the more likely it is to happen.

[Loqode]

@Darren_Murphy

So every user could perform that check, and because they all haven’t synced up yet, they all pass…

Yep had a feeling that was the case, hence my comment at the end…

@Loqode

Not sure how quickly the Lookup column would be updated with the newly added booking…

Interesting Idea delegating the the booking submission to Make though

And @Eric_Penn thanks for clarifying. In that case, I’m not really sure how you’d block/reserve a spot someone has selected/claimed before submission… Seems like a bit of a tall order

[Bhavana]

Hi, tried the Simple Booking App please reffer to the screenshots though the array contains the date and time same as full selection the taken checkbox is not checked because of that I am
able to Book the same slot many times what can I do to correct this

[madhu]

@Loqode
Hi Marco I tried this simple booking app, but I am not able hide the already booked time, in the backend the taken column is not affecting, please refer to the below screenshots, Please help correcting this.

[Loqode]

@Bhavana @madhu Your Full Selection doesn’t contain a comma, but the items in your All Bookings array do.

[madhu]

@Loqode , Thank you , that was silly mistake, didn’t notice it properly.

[Bhavana]

Hi, I have a column in a table in that I have lookup column but I have to show coachnames column its not showing while displaying the name

[Eric_Penn]

Is your lookup via the “UserRelation”? Check your “UserRelation” column… it needs to be a SINGLE relation for your lookups to display on screen properly.

[Bhavana]

Thank you ,Its Working

[nathanaelb]

@Darren_Murphy , @Loqode

I had missed your exchange. Thanks for this, it was very valuable. The repetition of these explanations in different use cases really helps grasp the topics.

[nathanaelb]

@Darren_Murphy

When you open the form, you use a Show New Screen action. Whilst that is fine, it does limit you to only being able to create bookings whilst in the context of that screen. What I like to do is create a Single Value → First → Helper Table → Whole Row in the User Profile table, and then use a Show Details (not Show New) screen via that column. Doing it that way essentially gives you a reusable Custom Form that you can call from anywhere in the App.

Would you agree that the same is achieved when using a Global Settings table instead of the Users table, where this Global Settings table is the data source of every tab (and therefore every custom action)?

In effect, in your method you use the Users table as a Global Settings table. In Paris a few weeks ago, Oscar encouraged me to set up a Global Settings table instead of what I was doing, which was to create a dedicated single-row table per tab just as the data source.

[ThinhDinh]

@nathanaelb

In effect, in your method you use the Users table as a Global Settings table. In Paris a few weeks ago, Oscar encouraged me to set up a Global Settings table instead of what I was doing, which was to create a dedicated single-row table per tab just as the data source.

Is there any plus of doing this though? I always build my tab level screens on top of the Users table, and helper screens on top of single row tables like Darren suggested.

[Darren_Murphy]

@nathanaelb

In effect, in your method you use the Users table as a Global Settings table. In Paris a few weeks ago, Oscar encouraged me to set up a Global Settings table instead of what I was doing, which was to create a dedicated single-row table per tab just as the data source.

Yeah, I remember Mark telling me about this a couple of years ago. I can see how it might keep things nicely organised, but I still prefer to keep this sort of stuff in the User Profile row as you can access it directly from anywhere in the App without doing anything extra.

[jia]

hii thanks for the amazing vid & tips!!
im currently facing this issue where the Taken column is not ticked when the first slot has already been booked:

do you have any advice on how i can mitigate this issue? Thank you!

[ThinhDinh]

I think there’s potential for something to go wrong if you approach date/time that way.

I would use a math column to convert the date/time into numerical values:

YEAR(D)*10^8+MONTH(D)*10^6+DAY(D)*10^4+HOUR(D)*10^2+MINUTE(D)

That would give you 202503251000 for March 25, 2025 10.00 am.

Then, proceed with the Array Contains Element approach to see if it makes a difference.