We’ve built a tracking solution which utilizes:
- SQL database for tracking what equipment items are currently checked out - checked out items are shown on the main page
- SQL database for recording a log of all in/out transactions - click “View History” on the main page to see log
- Automated email alerts when an item is checked back into the shop - the office is alerted to details of the rental in order to bill correctly
- Password protected so only those with the credentials can access the site and make submissions
This provides quick and easy tracking and communicating of equipment rented between multiple shop/field parties and the office.
Check Out Item:
Simply fill in the form fields on the main page and click submit. All fields are required except the “Pricing Scheme.” Once submitted, the data will be displayed on the main page under “Items Currently Out.” Refer to this section to keep track of all rented items out.
Under the “Item Currently Out” section, each item has an associated “Check Item In” button. Click this button to be taken to the check-in page. Here, simply enter the date of check-in and click the “Check-In” button. The item will be taken off the “Items Currently Out” section.
To view a log of all transactions in and out, click “View History” at the top of the main page. This will take you to a page showing all past transactions. Each rental submission has a unique ID number assigned to it. You will see the same ID number when the item is checked out and checked in so we can track which entries correspond with each other on the page. Transactions are sorted chronologically.
An email is sent to the office when an item is checked back into the shop.
Time Saved by Millstream Solution: 20 minutes/rental