I am setting up a reservation system to reserve equipment, and the reservations are made for a date range specified by the user.
How do I check to make sure that there isn't already a reservation for that equipment that overlaps with the dates of the requested reservation?
Note: I'm new to this, so don't hesitate to bombard me with details. I have Object types setup for Equipment and for Reservation, and I have them connected. I also have the Reservation connected to a User Role to keep track of who the Reservation is for.
I have a module I've previously made for a client that accomplishes just this. When it finds a conflict, it displays an error message and prevents the form from being submitted (screenshot: https://i.hmnd.io/xsifsY0M.png). It is currently implemented for room bookings in an event management platform, but it can be used with any records that have dates.
If you're interested, feel free to email me at david@hmnd.io to discuss.
I’m trying to set up a similar system for rental equipment. I’ve got an Object for Inventory, one for Orders and one for Order Items. Each Order Item record has a start and end date from the order reservation and is connected to the Inventory table.
I’ve been breaking my head on how to restrict inventory availability based on the maximum quantity available and reservations’ start and end dates?
Any help or guidelines on how to achieve this would be greatly appreciated!
Hi David, do you maybe have more information about this or an example you could share? Like Adam I’m also working on a similar reservation system for rental equipment. Thanks!
@hmnd I am working on a room reservation app for our school. I used to the calendar booking app template from Knack and now need to add in whatever is needed to block out dates as well as to not have overlap. Very new to Knack so any help is highly appreciated! Thanks!
