I want to implement a form to make reservations of resources, like a events room. For this I want a form, with a validation to restrict that the same reservation date can only be once o twice a day (to have a limit by day). For this I thought to count the reservation that have the same day, but I don't the this functionality.
Is there a way to implement this?
Also I can't set the reservation date as unique, as the same table can have multiple resources.
Thanks in advance.