Often at companies and other work environments, employers lend out technology equipment and other tools to authorized staff for work-related purposes. Companies, schools, public facilities, and many other work settings need a reliable asset management system to keep track of equipment, view inventory available, and which devices are currently issued to authorized users.
The Netkiller Barcode Scanner is an asset and inventory management application that functions as a database to keep track of loan devices in real-time. With a custom-designed form and Google spreadsheet specific to your needs, tracking and updating the movement of equipment is easy and accurately recorded for equipment inventory management.
① Design Equipment Inventory Form & Spreadsheet
The sheet you design will function as a fill-out form with input fields each time an equipment device’s barcode / serial number is scanned. The exact fields created for the form will also be the columns in your Google Spreadsheet. This Google Spreadsheet that stores all information is auto-generated in your Google Drive when you press [Complete and Save] for your designed form.
Once you have finished your form design you can preview your custom form by clicking [Preview Form]
Check dropdown menus you have created on your form to make sure they appear as how you would like them to appear for actual operations. When an equipment device is scanned on a mobile device, the barcode number / serial number will automatically be inputted into the barcode section. The date and time will also automatically be entered into the field “Timestamp” created in this use case. The administrator loaning out the equipment then enters in information onto the form accordingly and the data will be instantly recorded onto the Google Spreadsheet located in the admin’s Google Drive.
Clicking [OK], and [Complete and Save] will create the form. The form is then ready to be used and will prompt for information input when equipment barcodes are scanned on a mobile device. In addition to the creation of your form, the Netkiller Barcode Scanner automatically creates a Google Spreadsheet in your Google Drive to record and track data from your mobile scans.
You may rename your Google Spreadsheet from the default title “Netkiller Barcode Scanner_2.0” to a title suited for your purposes.
② Scan Equipment Barcode
On your scanning mobile device, open the netkiller barcode scanner app and press “Click here to scan”. Next, the administrator in charge of the equipment scans the barcode / serial number of the assigned device equipment and fills out the form accordingly. The equipment barcode number and date and time of the scan will automatically be filled out on the form. The remaining fields fields such as Employee Name, Device Type, and so on can be manually entered by the administrator.
Text fields included in the design are simple to enter information into and dropdown menus are easy to select options. At the end of the form when the administrator issues the device to an employee and presses [Submit changes]. The information is recorded in real-time and automatically transferred onto the administrator’s Google Spreadsheet. On the spreadsheet in the “Barcode Scanner” tab, all equipment availability and information appears.
③ Rescan Device to Update Changes
Updating changes and tracking device movement can be done by rescanning the equipment barcode. When a device moves from the equipment room to being issued to an employee, or when an employee returns a device, equipment movement can be updated by rescanning the equipment barcode / serial number, updating the new information on the form, and clicking [submit changes] on the mobile scanner.
A rescan and submit on form changes will update the barcode number with the new information and the current status of the equipment is easily seen on the “Barcode Scanner” tab of the spreadsheet.
All previous scans and latest scans can be viewed in the “History” tab of the spreadsheet. This keeps an accurate record of equipment availability, movement, and equipment tracking.
The “History” tab records information each time any barcode is scanned. The “Action” column to the far right indicates whether the barcode is a new or repeated barcode. “Insert” action indicates that the equipment barcode is new to the system and is being inputted for the first time. “Update” action indicates that the barcode has already been scanned in the system before, and the existing barcode’s equipment information is being updated.
Cloud Integration & Aggregator