How to Create a QR Code Attendance System in 2023 for Teachers

In this video, we'll show you how to create a QR code attendance system in 2023 using Google Sheets and Google Forms. With this system, you'll be able to track attendance and make sure that all students are following the instructions of the school. We've done it before, but this time we have more efficient, more user-friendly, and all-round better formulas and functions in Google Sheets.

QR codes are becoming more and more popular, and this attendance system is a great way to use them to improve school compliance. With this system, you'll be able to make sure that all students are following the instructions of the school and that they're able to attend classes safely and on time. So be sure to watch this video and learn how to create a QR code attendance system in 2023!

📋To create the QR code, just copy and paste this formula:
You may need to adjust to the correct column if your spreadsheet is setup differently.

----------------------------------------------------------------------------------------------------

💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[alisonhowd]

Your tutorials are so helpful! Thank you!!

I am working on a Google Form that I only want the name to be pre-filled. I was successful with making the hyperlinks and using your formulas. However, the QR codes would only take me to the blank Google Form - not the pre-filled link. I tried it with an iPhone and an Android. I also tried it with a form made with my school's Google account and then my private Google account. Same issue in all of the ways I tried.

Any suggestions?

[rimasdesigner]

It really appreciating to take time to study us,
Very Big thank you, It really worked...
Thanks Alot

[heathroddy]

After watching this video, is it possible to have our teachers have a district issued QR code like the one I created after watching this video, that is pulled to a google slide template. (Another video of yours I watched) They way, they can have the PNG qr code on their phone and be able to sign in to the PD I've created using your examples?

[iirfdhi]

Hi HAsh, The QR Doesn't work if have multiple fields for eg. multiple entry, can you please help with that. Thanks

[rhodney]

Thank you very much! This is exactly what I’m looking for!

[xcnixbd]

hey, Hash I did follow the instructions given but the QR codes did not appear can you help me with this?

[applecoresolutions]

Can I do one for arrangement in seating ?

[JimmyBradley-ytue]

Heya @TheMathlab NZ - I've been following your tutorials. Excellent thank you! I am keen to see how to convert your Attendance QR spreadsheet over to an AppSheet. Cheers Jimmy

[Flippss_]

Is there a way to get a general QR code upon scanning links each individual to their QR code?

[maine]

This is really helpful! Can I ask, how about if I also want to track the in-between time like out for lunchbreak and back, and I want it to reflect on my google sheet?

[hannahmaricarreon]

Thank you so much! this is super helpful, but can I ask we you can download the qr codes with names using the google sheet we use here?

[menakatharanga]

I looked at your methods. They are very good and can learn a lot. Thank you.

Everything related to this video of yours has been done properly.

I want to know how to send the QR code you made in Excel to the relevant students. I look forward to your kind reply.

[JiteshJassal-stxu]

Thanks. Anyway to make the data compare to who we should be expecting for each session (e.g. Monday AM, Monday PM). People are all the same

[rimasdesigner]

Same thing can you make a restriction on this attendance, Ex: 1 person can attend 1 time only like that

[adiahmic]

Great video Hash. Thanks for that. I have a question for you. Is it possible to trigger the action (for example, green light on Google form or any other visual effect) when attendee scan the QR code?

[cyrilleemmanuelaka]

Super Nice video, it's super cool.
I was wondering how to do the same using microsoft forms instead of google form. I checked but I didn't succeed. Can you plz tell me how to do?

[lnehuek]

Bro it can be possible one scan per day using qr code so they will not scan it again and again? How should I do?

[yoursoulfulstories]

Hi Hash Ali! I liked your video to keep coming to it when needed. I have a question: I have a school and 3 duration class time (30 mins, 45 mins and 90 mins). Is it possible to add a dropdown list with all 3 duration class times?

[vlwctzm]

Great video. I have a question on how to hide the section where we get our pre-filled link and directly display the section where they need to response. thank you

[zybfvxo]

Hey, after scanning the QR code it is not automatically submitting. It does select the person name on Google forms but is not automatically submitting it. How do I fix this issue?