We have a SharePoint calendar that our customers use to create job requests which we do for their department. We can only do a certain amount of jobs per day, and of those only a certain amount per time zone. I want to make it so that when we have confirmed our max of 7 per day, users will not be able to create a new job request for that day. Also, during certain times of the day they can't do concurrent jobs.
Basically, when people are creating a new request, the date/time they put in needs to get validated against the master calendar. If it is at a certain time of day and there is another event happening, it gets denied. If we are maxed out for the day it gets denied. If it is maxed out for the time zone it gets denied.
I am doing this so our team doesn't spend so much time rejecting these requests if we can prevent them from being submitted in the first place.
As well, I am familiar with creating validation for the various fields, but I do not know how to make it reference the calendar to check what has already been confirmed.
Anyone done something similar to this?
Thank you in advance.