Calendar: double booking


I am in need of your assistance regarding an issue that I am facing on Adalo. I am currently creating a booking application for a common room that is shared among multiple tenants. I am using the calendar to make reservations. I would like to add a condition where if a user tries to book a date and time that is already booked, an error message will be displayed. It is probably a simple solution, but unfortunately, I have not been able to figure out how to proceed, and I have not found anything on the Adalo forums. I prefer to use the Calendar option instead of creating time slots.

Thank you for your help.

From experience, that won’t work.
Creating timeslots is the easiest way to go about this.

Calendar displays timeslots that are available.
Once a user books a timeslot, it becomes unavailable to others to book.

You would need 3 DB Collections

  1. Rooms
  2. Availability (Timeslots)
  3. Bookings

Rooms to have one-to-many relationship with Availability
Each Booking must be linked to a Availability which is linked to Rooms
Availability can have property as “Available Slots” which you can set to 1 if there is only one room. Or you can set it to 3 if there are 3 conference rooms that can be booked from 9 am to 10 am for example.

Hope this helps

Hi @NatJo ,

You might want to check this,

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.