Hello community,
I created an application for booking rooms. The user selects the booking dates (the calendar I used is in the attachment) and goes on. Selects a location from a pic list and a room that still has free space. Before selecting a room, the application should check whether there are still free places in a given room on a specific booking date, which it has previously selected. A free room should appear in, for example, a gallery. When you choose a room, select it, for example, a chechbox. Then several book (Patch) and on the Sharepoint list, the Reservation Date and the Rooms and the remaining values are saved.
I have two Sharepoint lists:
- The first user reservation list contains the columns: Date of booking, Room reserved.
- The second list of rooms with limits includes the following columns: Room, Maximum room capacity, Occupation, Remaining available (calculation field on Sharepoint)
The question is: I'm stuck and wondering how to show the free space in the room on the day of booking and make it possible to book this space from the gallery level?
I will be very grateful for your help
