(not sure if this is possible) We have limited equipment stocks, at the moment the cameras for example are a custom field and the operator says if they are being used or not. This then feeds a report of yes' so we can then see if we are over stock numbers however this is a very manual and almost too late situation. The ideal would be setting that we have 8 cameras therefor if 8 are booked that day and you go to select "yes" on the custom field it's not allowed.
Not sure if this is possible via some automation or even at all, i've been scratching my head with it for a few hours so thought now was the best time to ask some experts!
Thanks in advance for any suggestions and ideas.