Tracking and keeping updated with what your staff is the topmost priority. And many-a-time, you also have to keep records of maintenance activities such as washroom cleaning, machine inspection and servicing, vehicle inspection and servicing and patient check.
This could be for various reasons such as attendance tracking, efficiency check, or to identify challenges. And for this, you generally create paper forms which have to be filled by the respective maintenance staff at regular intervals.
But, most of the time, the data is filled manually. So, it becomes a task to calculate and analyze the data.
Plus, you would obviously need the sheets in bulk. This means a lot of printing costs.
Another challenge is to actually collect and store the sheets after a particular time period (a week, a month, and so on). This requires a lot of space and sometimes become cumbersome to handle.
And you are, of course, looking for a solution to resolve these challenges.
The best part is that there is a solution— QR Code technology. QR Codes are advanced barcodes that can easily be scanned via a smartphone.
And there is no need to be dependent on paper forms anymore. Create Google Forms instead and then further create Google Forms QR Codes to manage tasks easily.
A. Why use QR Codes for Maintenance logs
Here are two major reasons why you should use QR Codes for maintenance logs:
1. Link unlimited information
QR Codes can link unlimited information. In your use case, you can easily link a Google Form in a QR Code.
2. Occupy limited space
QR Codes can encode large amounts of information and have a small size. Plus, you can print and paste them anywhere. You can also create QR Code labels and print it on places that suit you best.
All you need to do is to—create a Google Form with the relevant information. And encode the link of the Google form in the QR Code.
You can then paste a unique QR Code on each entity that needs to be maintained (such as washroom, machine, and vehicle). Your maintenance staff will scan the QR Code during each maintenance and will be redirected to the Google form link. Here, they will enter relevant information.
This information will be automatically recorded in a Google Sheet. Thus, it will be possible to now analyze data easily.
Hence, Google form QR Codes make it easy to track, analyse, and handle maintenance logs. All you need to do is create a Google form and then encode the link of the form in the QR Code.
B. How to create Google Forms for maintenance logs
Before proceeding to actually creating a QR Code, it is very important for you to know how to create a Google Form.
You need to follow some simple steps:
a. How to specify questions
1. Sign-up for a Google account or go to the Google forms app.
2. Choose a readymade template or start with a blank form.
3. Now, you have to fill the following things:
- State the form title and description
- Specify the questions
- Choose the type of questions you want to ask (such as multiple choice questions, short answer type)
Note that the date and time of service input field is not required as Google Forms will automatically add this in the response sheet.
Your Google form with the questions will be created. You can also get a link of the form— click on Send in right hand side of your dashboard and select the URL icon. You can then copy the link.
b. How to get responses
Once you create the form, go to responses and create a response spreadsheet. You will be able to see the responses of your maintenance staff here. Here, you can also see the time when your employees filled the form.
c. How to get a pre-filled link
Let’s say in the Google Form that opens for the maintenance staff (after they scan it), you need one of the input fields pre-filled. Say the washroom unique ID that helps you identify which washroom was serviced but you don’t expect the staff to remember such IDs. For such cases, you will need a pre-filled unique URL of the Google Form.
Here is how to get it:
1. Click on the three dots in the extreme right of your Google form dashboard.
2. Select the option of Get a pre-filled link.
3. Specify the response you want to be pre-filled when your maintenance staff opens the form.
4. Once specified, click on Get Link
Your Google form link with the pre-filled response will be generated.
But now, since you have a pre-filled link, the link of every Google Form will be different (since the washroom code on each form is unique). And to create the pre-filled link one-by-one using this system will be tedious if the number of washrooms is high.
So, how do you do it?
d. How to create unique links for each Google form
Taking forward the example of washroom maintenance, you will need to fill the washroom unique code on every form. In other words, the pre-filled link of each form will be unique.
And since there are a number of washrooms, with each washroom having a unique code, the number of unique pre-fill links generated will also be multiple.
And you can easily create multiple unique links by following these steps:
1. Create a spreadsheet. The first column should be the unique Washroom Code. And the second column should be the link of the google form. (the link of the first form you created with the pre-filled response)
2. Segregate the part of the link that will be common to all links i.e. the part of the link without the unique ID
3. Now, apply formula CONCATENATE and specify the value of two cells that you want to merge. For example, value of cell in column A and row number 1 will be A1.
4. Your cell will merge and link will be created. Now, vertically scroll the ‘plus’ sign on each cell to likewise create the number of links you want.
5. Paste the links under the column Google Form link on your spreadsheet.
This way, you can create multiple unique links of your Google forms.
And now, since you have to create QR Codes of Google Forms, the next step is to create QR Codes.
C. How to create QR Codes in bulk
Since you have Google form links in bulk, you need a bulk QR Code generator to create QR Codes in bulk. You cannot create QR Codes on-by-one.
Using QR Batch for demo purposes, here are some steps that you need to follow:
1. Create an account on QR Batch and via the dashboard, click on the category of Website URL
Note that you can sign up for free. You have to pay only when you generate QR Codes
2. Upload the spreadsheet you created (as mentioned in the above section) in the given option
3. Review the data extracted by the tool
4. Match and confirm the Filename as per the data you encoded in the spreadsheet. Similarly match the URL
5. You can add design to your QR Code. That is, you can customize the QR Code by adding your company’s logo and colors. And make your QR Code personalized
6. Choose from the two export options that pop up
- As images zipped in a folder—define image format and size
- As printable QR Code labels PDF—specify page layout
7. Review all specifications and price. If all looks fine, proceed to make payment
8. Your QR Code batch will start processing. It should be ready for download in a few minutes or a couple of hours, depending on the size of the batch . When ready, proceed to download the batch. You will be notified about it both via an email and the notification button
To know more about creating QR Codes in bulk, refer to this detailed guide.
So, you just read comprehensive guide of how to create QR Codes for maintenance log.
With QR Code technology spreading rapidly across the world, it’s time to adopt QR Codes for maintenance logs to easily track maintenance and reduce printing costs.