Avoid overbooking

hello help me please. I’m trying to make a rental app and I have for example a maximum of 5 products that I offer per hour by which means can I avoid a 6th user reserving the product because obviously there are no more thank you

I need more information on how a user reserves a product and what your database looks like but you can add a condition to whatever a person reserves from and query ur database to see if the number of people who reserved a product is >= 5 and if it is make the button unclickable or the listing not visible

1 Like

To elaborate abit, just have a field in your Product thing that will store the User which has reserved the Product. You can then use a condition to apply in a suitable workflow.

thank you i will see if i can do it

thanks I will try

I have the user in the database who reserves the location

I also have the number of people who book with the date of reservation
would it be possible to ask bubble to count for the same reservation date the number of people who reserve?

It depends on your database structure but yes. Search for reservations and filter it to make sure all the reservations are on the given date and then do :count. So it would be like Search for Reservations:filtered (date= given date):count

i tried this
serch for reservation filtered:number of participants join with search for reservation each item’s stays’s date of reservation:count formatted as 1029 converted to number.

but it didn’t work as I wanted :frowning:
I don’t know how to word the command.
as a reminder I would like

display in an input for each reservation date the number of participants in this stay

everything is in the reservation database

do you have any idea how to word it?