We have a couple of unusual use cases that I have no idea how to solve and would appreciate any feedback.
The scenario... A Service Desk for submitting requests for Security Escorts at a Museum. Currently, users can request any date/time using two fields for start and end. This presents a problem for the security managers in charge of scheduling as there can be a large variance in requests from day to day. So they'd like to limit them somehow.
Is it possible to limit the number of issues created per day? Doesn't seem likely but gotta ask.
One of the form's fields is 'Number of guards', would it be possible to validate that against a static limit per day? For example, only allow users to book x number of guards per day? But would need to be cumulative based on all the requests for the day.
And lastly, glancing at the data, most requests appear to come in with a short timeframe. Meaning Create Date and Request Start Time may only be a couple or few days apart thereby making it very difficult to anticipate/fulfill demand. Can Request Start Date be validated against some pref-defined scheduling limit? Like it has to be at least a week out?
Any suggestions would be greatly appreciated.
Thanks, Michael J