I’m developing an app that should manage the booking of a definite number of resources (20-30). These resources can be rooms in a small hotel for example.
The aim of the business is to have these resources booked on as many days as possible.
I did see the Item Reservation sample app when I googled this (it didn’t come in the search inside the appshet.com sample apps list though-FYI), and learned from it how to prevent double booking.
But I need two additional features:
ability to show these resources on a Gantt-style calendar. Meaning that I need each resource to have a “line” in the calendar. How can this be done?
I did use the calendar view to show the bookings and set the resource id as the category, but only resources having actual bookings would show up. I need the calendar to show all resources, when those without bookings…
I thought of a workaround of running a scheduled report that would add a “fake” booking for yesterday if the property wasn’t booked then…
Any other idea?
There is a need to have a view/report to alert the user about any resource that will be/is free in the coming 2 weeks so that the user could focus more on marketing them.
Any idea how this could be done from queries perspective? “Find all resources that will have 1 free day at least in the coming 14 days”
Thanks a million