Finding open or unused dates/times
I have a small school and have developed a Filemaker solution covering all aspects of it. I wonder if it is possible to create a script or self=join relationship that would give a report of all open dates and times. We use 4 rooms and an off-site studio for our classes. Many scheduling changes happen all the time and it would be a huge help to basically pick a room and have it show open times.
I hope this explaination is clear enough. I would like to either have "blank" fields populate themselves showing the in-between times available.
Is this at all possible? Thank you for reading and any help offered. Special thanks to Phil Mod Junk for consistently giving useful, practical advices.
How have you set up your database? What tables and relationships do you have?
How are the rooms reserved? By the hour? Can one reservation for a room span several hours? More than one day?
These details are crucial in setting up a system that lets you see what rooms are available.