Looking for some brainstorming and finding best way for this.
I have created a booking tool and I have now a collection “Number of People” where restaurant can set the max number of people per hour when creating the restaurant and aonother collection with Reservation hour collection where I have the opening hours and capacity:
11h00 - 10 people
10h00 - 10 people
what the best way to incorporate that when someone chooses the 11h00 and Number of People = 4 the Reservation hour collection will be update to 11h00 - 6?
I know I can do this with Airtable by updating fields back and forth, but is there way of doing directly in Adalo? Thank you.