Inventory tracking: link items to dates and locking them out during already selected time frames.

Zmiller08

Inventory tracking: if an item is selected in 1 column and there are check-in and check-out dates in their own separate columns, I would like the availability column linked to that item, and if the item is already booked for a date or date range that someone else is not able to select said item if any of the dates overlap.

Also would like this to work through a form and also want to approve the form request before it goes onto the sheet.

Paul Newcome

Are you able to provide some screenshots for context?