I am creating a basic site with the purpose of scheduling to use a company truck, and to see whether it is currently available or not.
I currently have my main dossier, which has one Item that opens a display form. Opening this form shows the page below: This form contains a sub-list called "Truck Calendar", which has the columns; Check In date, Check out Date, Employee, and the Current date (The date the item was added).
I need to figure out a way for the "Currently Available" column to update based upon whether the present time of viewing the form collides with a scheduled time someone has setup to use the truck, and if so, mark it as not currently available.
Please sign in to leave a comment.