Hi all, trying to build a table for instrument rentals at my workspace. I posted about this elsewhere thinking my answer lied with automations and formulas but maybe calendar view is my answer?
We basically rent instruments to students like a library would a book. I want students to be able to submit a form requesting an instrument, they select a request date and I have a formula that calculates the due date as 14 days past that. I would like instruments to be marked unavailable when requested, this needs to function in relation to the current date (ie, instrument requested for Sept 15-29, today is the 20th, so it should show unavailable) as well as to a future date (don’t want students to double book an instrument say, for October 15th).
Would calendar interact with a form in such way and allow me to do such a thing?