Best way for Calendar Capacity Calculatio

Get Help
1

Hi,
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:

e.g.
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.

Jorge.

2

Hi @sebastas.

I would not use separate collections for these things. You should try to minimise the different amount of collections if possible.

You could for example have a Restaurants collections. In that collection you could have the “capacity” and “opening hours” as properties. Then another collection for Reservations that has a relationship to the restaurant. “A Restaurant can have many Reservations. A Reservations belongs to only one Restaurant”.

3

Hi Colin,
Thanks for the input, i tried that, but the capacity “refreshes” everyday. Also I need in the reservations to have a drop-down indicating Number of people (user will not write the quantity, it is bad UX).

Ideally flow should be:

1.Chooses the number of people X
2. Chooses available hour (ideally it should be filtered already hours that allow X number of people)
3. Chooses available day (ideally it should be filtered already days that allow X number of people)

Or

  1. chooses the date
  2. chooses the available hour
  3. Chooses the available people

This iteration (multi-step) is ideal for UX.

If I have 22/08/2020 10:00 booked for 10 people ( max capacity), so should not be possible to book for that hour. but if they book for 23/08/2020 for 10:00, the 10 should be there again.

Maybe I am over-complicating this, but so far I cannot relate “refreshing the capacity” according to the Reservations done already and the Date chosen.

I tried in one unique form, but if multi-steps works better (by using updates and calculations) I am also ok with that.

image
image636×772 87.7 KB

Thank you very much.

4

Hi Colin,
I used the Nested Collections to test what I wanted and it partially works, I wanted to use an api to update number of people

image

But if I export the CSV the Nº of People seems not to be exported, and that is the field I need to update. Is this a bug or is this due to have an Array of values?

Thx.

5

This is unfortunately due to being an array of values. We are aware of this problem but have not resolved it yet.

6

Hi Colin,
Thank you for the feedback, will this be resolved soon? this ideal would solve capacity/relationship calculations.

7

It’s something that is already in the works but I do not have a concrete date for it.

1 Like
8

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