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.
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
Rooms
Availability (Timeslots)
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.