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 that have to be filled by the respective maintenance staff at regular intervals.
But, most of the time, the data is filled manually. So, respective personnel has to spend more time on paper filling alone.
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 becomes cumbersome to handle.
After all this, you still have to analyze the data. So, you are obviously 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. Damage resistant
QR Codes can resist up to 30% damage. That means QR Code can scan well even after it gets damaged, distorted, or dirty by up to 30%.
3. Readable from any direction
QR Codes can be scanned from any direction. For example, if a QR Code is printed upside down. It will still scan and show the encoded content to the end-user.
4. 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 them 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 the 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, analyze, 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 the formula CONCATENATE and specify the value of two cells that you want to merge. For example, the value of the cell in column A and row number 1 will be A1.
4. Your cell will merge and a 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. Next, select the Website URL QR Code from the QR Code categories
Note that you can sign up for free. You will have to pay only when you generate QR Codes.
2.Now click on Upload File and upload the spreadsheet you created (as mentioned in the previous section)
3.Click Review Data. On the page that loads, review the data by choosing the correct column name from the drop-down menu and clicking on Confirm against every matched column
4.Now, you’ll see three design options to choose from- Standard design, Custom Logo design, and Custom Background design
Standard Design: It gives generic black-and-white QR Codes.
Custom Logo Design: It allows you to add your company’s logo and color to the QR Code.
Custom Background Design: It helps you place the QR Code on an image.
Here’s how you can add design to your QR Codes.
5.Once you’ve finalized the design, click Select. A window will pop up, prompting you to select QR Codes’ export format (images or labels)
QR Code Images: It allows you to export QR Codes in formats such as PNG, JPG, EPS, SVG, PDF, and DXF.
QR Code Labels: It allows you to export the QR Codes as print-ready labels as PDFs or DXFs. You can also select the labels’ layout.
6.Once you’ve decided on the QR Code batch’s format and layout, click Continue. On the page that loads, click on Proceed to payment
7.Once you’ve made the payment, 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 inside the web app.
To know more about creating QR Codes in bulk, refer to this detailed guide.
So, you just read a comprehensive guide on how to create QR Codes for the 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.