QRStuff.com - QR Code Generator

Creating Individual QR Codes Using Attendance Tracking Data Type

Posted: April 22nd, 2019 | Author: | Filed under: General | No Comments »

Monitoring attendance is an important thing to do in schools and in offices. This tedious process can be simplified by scanning a QR code for every student or employee arriving at school or office.

The common practice is to have one QR Code that each attendee scan and input his name, but In some cases, it would be better to generate a specific QR code for each student or employee, especially if they don’t own a smartphone that’s needed to scan the code. Just give them a printed copy of the generated QR code and have it scanned by the administrator when they arrive at school or office.

You can generate Attendance Tracking data type QR codes linked to a Google spreadsheet which makes it easier to record the name of the person scanning the QR code and the date and time of the scan.

To do this, a unique individual QR code should be generated for each employee or student. Every time a specific employee/student arrives at the office/school, the administrator scans the unique QR code assigned to that person. Each scan event saves the attendance of the employee/student to the spreadsheet.

In this blog post, you can learn how to create an attendance tracking individual QR code that tracks an employee’s attendance.

Create your Attendance Tracking Individual QR Code

  1. Under Column 1, select the “Attendance Tracking” data type.
  2. In column 2, click the “Google Sheet Name” field. Log into your Google account when the pop-up dialog box appears. After logging in, this allows QRStuff to create a new tracking spreadsheet in your Google Drive. Every time a user scans the QR code, QRStuff is also able to update the said spreadsheet. (Take note that this access authority is only limited to the said spreadsheet and doesn’t give us any other user privileges for your Google account.)

3. In the “Google Sheet Name” field, indicate the desired name for the tracking spreadsheet. Enter details for the next three fields under Event Details: Location Name, Action Description, and Event Description.

For an employee tracking spreadsheet, you can enter “Workplace Location” for the Location Name, “Check-in” as the Action Description, and “Employee Name” for the Event Description. This is what makes the QR code an individual QR code because a specific Employee name is set for a certain QR code.

To have an individual QR code for each of your employees, create a QR code for each employee. When creating the QR code, use the same spreadsheet and change the “Employee Name” in the Event description.

Once you create a QR code for another employee, just use the same “Location Name, ” “Action Description,” under the same Google sheet name that you used in creating a QR code for the first employee. Just change the “Employee Name” in the “Event Description” field.

Like in this example:

4. Check the box “Display an Attendee Prompt” under the “Attendee Prompt” section to prompt an identifier to the user scanning the code.

For this use case, an attendee prompt is not necessary because the QR code is already assigned to each employee. But if you want one, a good suggestion for an attendee prompt would be “Administrator Name” to record the administrator who scanned the QR code.

5. At this point, you can download the QR code by clicking the “Download QR Code” button.

How the QR Code Works

Upon arrival of each employee at the office, the administrator scans the assigned QR code to the employee. After the QR code is scanned, the employee is asked to enter the administrator name. After clicking “go,” they see the location name, and event description that you indicated for the QR code. It also records the attendance check-in details in your Google sheet.

With the Attendee Prompt:

Note: The date and time recorded is based on the time zone that you have indicated in your subscriber account setup.

You can also create an Attendance Tracking QR code without an Attendee Prompt. After scanning the QR code, the administrator or the person scanning the code sees the attendance check-in details.

Without the Attendee Prompt:

About Your Google Sheet

The spreadsheet containing all the attendance tracking data from the scans of the QR code can be viewed in the Google Drive of the account you used for logging in. To access the spreadsheet, log into your Google account at https://docs.google.com. The spreadsheet created for the attendance tracking data is in the list of available sheets.

When you open the spreadsheet, you see something similar to the following:

Make it a Bit Fancy

Paid subscribers are entitled to customize the QR codes they generate through the site. They also have the option to include a logo or image in the center of their QR code. The steps are the same as above but before downloading the QR code, you also need to click the “Style Your Code” button to be able to customize the look.

The QR code to the right is a preview of how a styled QR code can look after customizing it through our QR Code styling feature. The interface can help turn QR codes turn into a more visually appealing and distinctive QR code for its users.

Subscribers Get More QR Stuff!

Become a QR Stuff paid subscriber and get unlimited QR codes, unlimited scans, analytics reporting, editable dynamic QR codes, high resolution and vector QR code images, batch processingpassword-protected QR codesQR code stylingQR code pausing and scheduling and more, for one low subscription fee.

Full subscriptions start from just $11.95 for a 1-month subscription (lower monthly rates for longer periods) or you can set up a 24-hour trial subscription for $3.95 to check out what we can do for you. Subscribe now


Attendance Tracking QR Code: Geolocation Update

Posted: March 3rd, 2019 | Author: | Filed under: General | No Comments »

QRStuff has added a new feature to the attendance tracking data type! The new feature enables the QR code to get the exact user location of the attendee scanning the code.

Previously, the attendance tracking data type could only record the name of the attendee scanning the code, and the date and time of the scan.

The new feature for the attendance tracking data type is beneficial for teachers in monitoring the location of their students when attending school events. Having the student’s location as part of the attendance monitoring ensures that the students are tracked scanning the QR code within the premises of the event.

Creating Your Attendance Tracking QR Code

  1. Under Column 1, select the “Attendance Tracking” data type.
  2. Under Column 2, click the “Google Sheet Name” field. A pop-up dialog box prompts you to log in your Google account. Upon logging in, this allow QRStuff to create a new tracking spreadsheet in your Google Drive and update it every time a user scans the QR code. (Take note that this access authority is only limited to the said tracking spreadsheet and doesn’t give us any other user privileges for your Google account.)

3. In the “Google Sheet Name” field, type in your desired name for your tracking spreadsheet. Enter the details for the next three fields indicated under Event Details: Location Name, Action Description, and Event Description. For example, you want your students to attend a school event at the Gym. You should enter “Gym” as the location, “Check-in” as the action, and “School Event” as the Event Description.

4. The option under the “Attendee Prompt” section is optional. You can check the box “Display an Attendee Prompt” if you want to ask the user for an identifier like name or ID number and enter the identifier needed on the field under “Attendee Prompt Title.”

5. Under the “Record Location” section, check the box beside the “Record Device Location” prompt.

Checking the box requires the user scanning the QR code to agree to provide their location. If they do not agree to provide their location, the attendance is not recorded in the Google Spreadsheet.

6. After completing the steps under the second column, you can proceed to download your completed QR code by clicking the “Download QR Code” button.

How the QR Code Works

Once the attendee scans the QR code, they see the location name, action, and event description that you specified in creating the QR code. The student scanning the QR code is asked to enter their ID number in this guide. Clicking on “Check-in” confirms their attendance check-in and records those details including the attendee’s geolocation in your Google Sheet.

Note: The date and time recorded is based on the time zone that you have indicated in your subscriber account setup.

About Your Google Sheet

The spreadsheet containing the attendance tracking data from scans of your QR code can be accessed in the Google account that you specified in the second step above. To access the spreadsheet, log in your Google account at https://docs.google.com. The spreadsheet created for the attendance tracking appear in the list of the available sheets.

This is what you see in the Attendance Tracking Sheet after you open the file. If other people need to see the spreadsheet, just click the “Share” button in the top right corner.

Notice that the spreadsheet now has another column containing the geolocation URL (street name and number) of the user scanning the QR code. Clicking on the link opens a Google Map showing the location.

via GIPHY

Make it a Bit Fancy

Paid subscribers are entitled to customize the colors of the dots and corners of their QR code. They can also embed a logo or image in the center of their QR code. Just follow the same steps discussed above, and then before downloading the QR code, click the “Style Your Code” button to change its appearance.

The QR code shown on the right is an example of what a paid subscriber can create after customizing their code using our QR code Styling feature. Using the interface, you can make your QR code more visually distinctive and intuitive by embedding a suitable image in the center.  

Subscribers Get More QR Stuff!

Become a QR Stuff paid subscriber and get unlimited QR codes, unlimited scans, analytics reporting, editable dynamic QR codes, high resolution and vector QR code images, batch processingpassword-protected QR codesQR code stylingQR code pausing and scheduling and more, for one low subscription fee.

Full subscriptions start from just $11.95 for a 1-month subscription (lower monthly rates for longer periods) or you can set up a 24-hour trial subscription for $3.95 to check out what we can do for you. Subscribe now.


QR Codes for Valentine’s Day

Posted: February 14th, 2019 | Author: | Filed under: General | No Comments »

This Valentine’s Day, you are probably thinking of a unique way to show your partner some appreciation. An unusual way that your special someone will surely love.

Here at QRStuff, we came up with an idea to make the typical Valentine’s Day card a unique one. Just send your loved one a QR code, and upon scanning the QR code, your partner will be shown the Valentine’s Day card that you prepared.

This trick will be a surprise as they will be not expecting that the QR code will show a Valentine’s Day card!

Are you interested in knowing how to pull this off?

First, you need to prepare a Valentine’s Day card. You can prepare one at home and take a picture of the card or you can prepare one online through websites like Canva.

After you create the card, you can create a QR code for your Valentine’s Day card on QRStuff.

To show you how to generate a QR code for a Valentine’s Day card, we’ve prepared a Valentine’s Day card through Canva.

Generating a QR Code for a Valentine’s Day Card!

Using the Valentine’s Day card that we prepared for this guide, let’s create the QR code for the card on QRStuff.

In this guide, I will show you how to create a QR code using QRStuff’s “Image file” as the data type.

  1. Go to www.qrstuff.com and log in to your “paid subscriber” account.
  2. In column 1, select “Image File” from the list of different data types.
  3. Under column 2, upload the image of your Valentine’s Day card. Keep in mind that the image should either be a JPEG, PNG, or GIF file.
  4. Column 3 allows you to customize your QR code. Click the “Style Your Code” button to customize your QR code. Change the color of the dots and corners and include a logo for the code if you like. You also have the option to change the size, resolution, file type and the error correction of the QR code.
  5. When you’re done, click the “Download QR code” button and your QR code is now ready to use. Remember to test your QR code before downloading it.

Make It A Bit Fancy!

As a paid subscriber of QRStuff, you are entitled to enjoy styling options for your QR code. To do that, simply click the “Style Your Code” button that you see in Column 3. Upon clicking the button, a dialog box will appear. From the dialog box, you can choose a different color for the dots and corners of your QR code. You can also include an image that will be embedded in the center of the QR code.

The image on the right shows what your QR code looks like after customizing it through our QR Code Styling Feature.


Subscribers Get More QR Stuff!

Become a QR Stuff paid subscriber and get unlimited QR codes, unlimited scans, analytics reporting, editable dynamic QR codes, high resolution and vector QR code images, batch processingpassword-protected QR codesQR code stylingQR code pausing and scheduling and more, for one low subscription fee.

Full subscriptions start from just $11.95 for a 1-month subscription (lower monthly rates for longer periods) or you can set up a 24-hour trial subscription for $3.95 to check out what we can do for you. Subscribe now.


QR Codes for Sharing Audio Files

Posted: February 11th, 2019 | Author: | Filed under: General | No Comments »

Audio files can be a useful format for business people in sharing information with their clients. Consultants can record their consultations with their clients and give them a copy of the meetings through an audio file. Doing this can provide value to the clients knowing that they can always listen to the recording of the meeting through the file.

Not only business people benefit from using audio files but teachers as well. Audio files can be a useful tool for teachers. They can use it in different ways:

  • Giving assignments to students in the form of audio files;
  • Including audio files as teaching materials for hearing performances, case study materials, etc.;
  • Saving lecture recordings in an audio file;
  • Having a recording of interviews with experts saved in an audio file;
  • Asking students to provide audio diaries or student reflections saved in an audio file;
  • Providing a recording of meetings, discussions, and tutorials through audio files.

Now, QRStuff.com has created an easier way to access and open audio files by just scanning a QR code. QRStuff.com allows you to create a QR code for your audio files.

Here’s a step-by-step guide on how you can generate QR codes for your audio files.

QR Codes for Audio Files Saved in Google Drive

Google Drive is a widely used cloud storage device and file hosting service where users can store and share files like documents, images, videos, and audio files with different users by giving an access link.

Before you can generate a QR code for your audio file, you need to upload the audio file first in a file hosting service like Google Drive.

Uploading Audio Files in Google Drive

First, go to drive.google.com and log into your Google account by typing in your username and password.

1. To upload an audio file in Google Drive, click “New.”


2. Choose “File Upload” from the drop-down menu.


3. After selecting the audio file, the upload begins and may take a few minutes to finish. When the upload is complete, you can see the audio file in the file list.

In order to create a QR code for the audio file, you need to get the shareable link.

4. Select the audio file from the file list, then right click on it. When a drop-down menu appears, click “Get Shareable Link.”

5. Another dialog box appears with the shareable link. You need to copy that shareable link in order to generate a QR code for your audio file in QRStuff.com.

Generating the QR Code

Now that you have the shareable link of your audio file from Google Drive, you can proceed to creating the QR code for the file on QRStuff.

  1. Go to www.qrstuff.com and choose “Website URL” from the list of data types in Column 1.
  2. Paste the shareable link of your audio file into the input box that you see in Column 2.
  3. In column 3, you can customize the color of the QR code. Hover over the box and choose the color that you like. You can see what the QR code looks like in the “QR Code Preview” section on the right side.
  4. After you finish creating your QR code, you can then proceed to download it. You also have the option to print or email it to yourself or to your desired recipient. Just click your desired output type under Step 4.

Make It a Bit Fancy

Paid subscribers of QR Stuff can enjoy more styling options for their QR code through clicking the “Style your code” button under Column 3. Once you click the button, a dialog box appears that allows you to customize the shape and colors of the different corners of the QR code. There is also an option to include a logo for the QR code.

The image shown on the right is a preview of how your QR code could look after styling it with different colors. Just remember to test your QR code to make sure that it works.

Paid subscribers also have the option to vary the QR code image size, resolution, file type, and error correction level of the QR code.

Subscribers Get More QR Stuff!

Become a QR Stuff paid subscriber and get unlimited QR codes, unlimited scans, analytics reporting, editable dynamic QR codes, high resolution and vector QR code images, batch processingpassword-protected QR codesQR code stylingQR code pausing and scheduling and more, for one low subscription fee.

Full subscriptions start from just $11.95 for a 1-month subscription (lower monthly rates for longer periods) or you can set up a 24-hour trial subscription for $3.95 to check out what we can do for you. Subscribe now.