How to block the data&time on calendar

Hi Bubblers,

I am struggling with this for a while, so please help me out if you can.

I am trying to build a calendar, where users can select date&time and reserve a room for selected time slot.

I was able to built the calendar and store the starttime and endtime.
However, disabling to reserve when there is already another reservation is not working.
i had the condition and data base set up as screenshot,

Am I doing this completely wrong?

スクリーンショット 2022-04-14 8.56.31

Remember always. The Bubble checks and returns only exact matches, until a second.
For example, if your client reserved on at 04/13/22 12:54:44 and the second one also reserved on at 04/13/22 12:58:13.
The Bubble will say it’s okay there are no matches.
To avoid this and find matches you need to save dates with the same hours.
Like a: // Current cell date: change hour to 12 //

1 Like

Thanks! i have tried several things and managed to do what i wanted to do!