Would you buy an expensive inventory software if you knew you could track your job’s site inventory for free? You probably won’t from now on if you have a free google account, an internet connection, and a little bit of time.
Google Drive is a cloud based system that allows you to create, store, and update documents, spreadsheets, presentations and forms from anywhere that has internet access, whether it be your phone, tablet, laptop, or desktop. In order to create your inventory, you’ll use Google Forms and Google Sheets, two functions of the Google Drive umbrella.
Forms allows you to create a custom input form using text boxes, multiple choice, lists, scales, and more. This data, once submitted, is then automatically sent to a linked Google Sheet, in real time. Sheets acts exactly like Microsoft Excel, complete with many of the same functions that Excel provides. Most importantly, for this application, formulas and pivot tables.
Summary of Process
3. Share with your team and implement process
In Parts 2 and on, I’ll be giving much more detailed information on the steps above. Stay tuned in the coming days for the follow up posts!