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

**ATTENTION! QR CODES HAVE NOW STOPPED WORKING GOOGLE SHEETS! THIS METHOD IS NOW OUT OF DATE. USE THIS ONE INSTEAD: • How To Create A QR Att...
If you still want to use this old method, this spreadsheet shows how to implement it: docs.google.co...
Advance your analytics journey: Contribute here for expert consults and additional tools: ko-fi.com/hash...
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:
=ArrayFormula(if(B2:B="",,image("quickchart.io/..."&B2:B)))
You may need to adjust to the correct column if your spreadsheet is setup differently.
----------------------------------------------------------------------------------------------------
💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓

[@HashAliNZ]

Check out an updated, better (in every way), more advanced, simple set-up, more efficient and secure system here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@gerimiahmaribbay3460]

googleapi doesnt work

[@HashAliNZ]

Correct. Description has had that in there for a couple months now with a solution 👍

[@creadorstream]

I will do!! thanks from México I will let you know what I did :D thanks

[@Brutech360]

Check out an updated, better (in every way), more advanced, simple set-up, more efficient and secure system here:

[@HashAliNZ]

You one of them repeater bots?

[@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?

[@mzahran001]

I guess one of the issues with the current setup is I can scan my friend's QR code, and it will work 😅 It seems that we need some authentication to make sure that no one can cheat. Another idea is making a dynamically changing QR code based on the time the instructor opens the sheet

[@kenechipalabrica9602]

you need to disable the response hehehe

[@HashAliNZ]

Yeah you can make a dynamically changing QR code each day. Just add a date field to your Google form and add that to the Google Sheet with each qr code. Prefill as usual and you're good to go

[@alinachen8455]

@@HashAliNZ how to make a dynamically changing QR code each day?

[@HashAliNZ]

@@alinachen8455 Hi Aline, you don't need to. When the QR code is scanned, it records the date and time automatically. Just keep using the same QR code each day

[@cheeku998]

@@HashAliNZ but sir suppose attendance is happening in a school through qr code and on a same time a student which is not present in class but his friend share his code through social media and on same time the absent student also mark there attendance.....😢 i think sir for attendance system we need a private qr code scanning application or web so no one can cheat through it please sir work on it and give is a perfect attendance system 😊

[@JimmyBradley-yt9ue]

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

[@HashAliNZ]

I had no plans for that, but I'll give it some research. Thanks for the comment!

[@hsetin]

My QR code scan does not submit the form. It only shows me the form and I have to click on the selection to submit form. I see that my scannedlink truncates at formResponse? as well. Did anyone had this issue??

[@HashAliNZ]

Hey Joe, Don't worry about the truncated link - phones just do that to save space. The problem you're having could be down to a few reasons. If there's no error showing when you scan, then it's likely down to a small problem in the URL. However if the error showing is something like "The question has changed", then try using the BinaryEye app as your scanner. Stock cameras being used as scanners aren't great yet. They have code in them that prevent auto-loading to the final screen.

[@pft4lifegamer4]

I got the same issue and binary will only pull up and show the qr code. It doesn't record it. It almost shows it as if we are supposed to send a qr code to the student or client.

[@HashAliNZ]

@@pft4lifegamer4 In BinaryEye, click the three dots in the top-right. Click Preferences. Scroll right down the bottom. The 8th from the bottom is "Open immediately". Make sure this one is activated. Then you're good to go

[@lionelfaure85]

I like the idea but What prevent a student to scan his at code from home?

[@HashAliNZ]

Yeah, it happens.

[@HashAliNZ]

Google Sheets is *my jam* , and in 2023 I'm going all out! Leave your questions here and I'll make a video specifically for you ⬇⬇⬇ If you want a system with less work so you can get back to what you love doing, check out Beaconstac to do the hard lifting for you: www.beaconstac.com/qr-code-generator?fp_ref=themathlabnz&YT1& *Subscribe* to keep in touch and join TheMathLab community to learn together!

[@sathya8094]

What if someone scans in wrong name? How to let each person scans only his or her name? If it is not his or her name, the system won’t record. Please make a video about this! Thanks!

[@ivix5947]

hi how can we restrict some scanners . Can we use only 1scanner only ?

[@tanwhaaron3205]

Hi, I would like to ask if in the google form isself have multiple columns (e.g. Name & ID), how can i edit the pre-filled link? Cuz in your video it only pre-filled the "Name". Hope can get your reply soon, Thanks

[@HashAliNZ]

​@@sathya8094 Great questions. New system here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@HashAliNZ]

@@ivix5947I've got the system that's perfect for this: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@whoiambydefault]

it works ! thank you so much for sharing good Sir, much love from Singapore.

[@asopok]

I'm finding it difficult to know how it's works afterwards. Are the students suppose to scan their individual QR code to register them? If yes, do you leave the PC on for them to scanned each time or how?

[@HashAliNZ]

There's different options. You could create a student ID for each person and give it to them. Print off all the QR codes, have the students stick it on the inside of their workbooks, then when they come into school they get scanned as they come in. Or you could have the full list on your computer and scan them as they come in (but if you're doing it this way, it'd just be easier to have tickboxes!)

[@HIJLA2198]

@@HashAliNZ how do you print out the qr code from g sheets given that its a lot of numbers

[@Sonu-yt5re]

Sir I just need your number

[@Fakhrihilmi69]

​@@HashAliNZhurmm they could have copied the URL and use it even at home 😭

[@HashAliNZ]

@@Fakhrihilmi69 Yeah, that's an unfortunately downside to this method. That's why I made this updated one that is much more secure : kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@Sariah-t3y]

Hash, if the employee is on a medical leave or annual leave, how can I update this using the QR code?

[@supriyapol5336]

Hello Hash can you please help us how can we share 800 qr codes to each individuals?

[@EvelynGoetz-o2p]

You can make bog as long as you have a title, side bars, footers and the body,

[@allisondavis3588]

Thanks for your videos! I was able to recreate this last year, but for some reason I am having trouble this time around. I need to create a unique QR code for each class date rather than each student--we want to just show a QR at the beginning of class and have them scan, enter their name and hit submit. I got a pre-filled link that marks down the class date and when I click on that url from the google sheet, it will take me to a pre-filled form. However, when I use the code to create a QR code, the QR code will take me to the form without any prefilled date (so students would have to select). I've tried this with both 'viewform' and 'formResponses', but with no luck. Any help with getting the QR to link to a pre-filled sheet or generating unique QR codes without student names would be super appreciated!

[@heathergraham5380]

This is also my question! Thanks so much

[@bricehudson9541]

Yes. It only goes to my form. Doesn't automatically submit.

[@HashAliNZ]

How about sending each student their own student ID card, then have them come in and scan a dedicated device just for this purpose? Check it out here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@HashAliNZ]

@@bricehudson9541 New system here with auto-submit here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@HashAliNZ]

@@heathergraham5380 Great question. New system here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@cyL2801]

Great tutorial!! A quick question: I tried everything for hours but can't get my QR codes to appear on the sheet, it's just blank. I'm sure my coding/ formula is not wrong as i double checked and redo many times. Thank you!!

[@HashAliNZ]

Hi, Unfortunately Google Sheets took away the ability to use their QR codes about three weeks ago. Check the description for ways to go about it (including a copy of the Google Sheet with the new working formula), or check out my newer method where you can create your own app: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@janelleatteco5606]

Thanks so much for your video................ it all went really really well until there was a glitch and now the QR isn't showing names in response anymore and i really need help with this as i've already sent the invitation out!!!! HELP PLEASE!!!

[@HashAliNZ]

Oh no! I hope things worked out. If not, here's a better system! kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@emilybrown6518]

I would really like to use this version of the QR attendance system, but I cannot get the form to automatically submit when clicking the link. (I haven't gotten to the QR code yet). When I click on the link, it takes me to the form with the answer populated, but the user still must hit submit. I've changed viewform?usp=pp_url&entry. to formResponse?entry. There is only one question and it is not required. The form is not collecting addresses. Is there anything else I can try?

[@halimabdullah7878]

hi, a very helpful video, however, when i pasted the formula to generate the qr code, the link from qr code did not go to the page "your response has been recorded" instead it went to the list of attendance where i have to manually tick n the names. Could you kind enough to check why?

[@SriNugrahaniRK-if3nq]

I'm currently facing the same issue, still looking for help tho

[@HashAliNZ]

This is usually one of two reasons: 1. You've selected "Collected emails" 2. You've created more than one question in the Google Form. Here's a better system: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@HashAliNZ]

@@SriNugrahaniRK-if3nq This is usually one of two reasons: 1. You've selected "Collected emails" 2. You've created more than one question in the Google Form. Here's a better system: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@Variety8th]

if not binary scanner, u will need to submit manually

[@henryeffiom7610]

Hello Hash, please I have a URL generated Qrcodes which at scan shows up student’s Biodata screenshot with theIr registration number as the QRCode name. Please how can I use this for attendance?

[@HashAliNZ]

Have you seen the features of the new method? Check it out here: kzbin.info/www/bejne/fpLckGVsfc-DnqM&lc=Ugyy1Vt43_HEAIY3_iF4AaABAg

[@christophermanglona5390]

My problem is when scanning the QR code, it asks to sign in to an email. How do I fix that setting so that when the code is scanned, it automatically submits the response?

[@HashAliNZ]

Use the updated system linked in the description. It's better, more secure, and less likelihood of messing things up.

[@auggiedomingo7888]

I tried this and it's working on the desktop. But when I tried using the qr on my phone I got this message: "The question has changed. Please revoew your response." I am not sure what this means

[@HashAliNZ]

Hi Auggie, Download BinaryEye. It's free and opensource, and much better than stock cameras on phones. For some reason a little over a month ago phones stopped accepting these QR codes from their stock cameras so we now need to move over to third party apps. No idea why it happened 🤷🏽‍♂

[@ferdzosio2420]

Can u help me fix the time when u try to view it in spreadsheet coz im having a hard time doing it..can it be adjusted to the time u scan it....coz there's been a 3-4 hrs delay...hehehehee...

[@HashAliNZ]

That's probably due to your locality settings set incorrectly. Check out this new system to bypass the issue: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@RocketSpaceStudio]

Hey! your video very helpful and very inspiring. However I try to scan the QR Code, but somehow it wont submit automaticaly in the google form. It is automaticlly open to pre filled page. Do have any idea to solved the issue?

[@HashAliNZ]

Hey! Make sure you've changed the URL to formResponse?entry. as shown at 4:10

[@rosaliemendoza4113]

Good day. I'm having a problem using binary eye. It does not connect to my google form. Can you please help me? thanks!

[@HashAliNZ]

Hi Rosalie, In what way does it not connect to your Google Form? As long as you have internet connection there should be some kind of connection to the Google Form, even if it gives an error.

[@abdalraoufalmahmudie9510]

First of all, thank you and I want your help, please I did all the steps, but the QR code does not appear, and the field remains empty, what is the solution, please?

[@HashAliNZ]

Hi Abdalraouf, If you're using the method in this video then the QR code should appear. If it's not, then the most likely cause is the formula being incorrect. If you're in Europe, try switching out the commas in the formulas for semicolons

[@NurulAinnisa-d9c]

Hi. I would like to ask, why do I have the same qr code for all names? for example, if I scan the qr name Kat, the other qr code is also the name Kat.

[@HashAliNZ]

Hi Nurul, I'm guessing this is to do with the arrayformula. It's likely that the beginning of your formula is correct: =arrayformula(if(B2:B="",, but then the next time you see B2, it should be B2:B See the formula at 7:45. Thanks!

[@NinjaPaintsOnStars]

Can you please just tell me how to scan a QR code with my phone in order to add points to my club members account. This video had too much intro and too much stopping and starting telling me descriptions of things that do not pertain to creating the QR codes or to using the codes to scan on my phone and then add points to my members accounts.

[@HashAliNZ]

Hey bud I think you may have clicked on the wrong video. The title of this video is how to create an attendance system for teachers. It walks people through creating the system from scratch. This isn't a video for adding points to your member accounts, however there is a way to use this system to do that. Just do what's on the video - it shows how to create qr codes and shows how to scan them. It also talks about the limitations which would apply to your scenario. If you're still wanting to use this system despite the limitations, then just open up a new tab and use a formula similar to: =query('Form Responses1!A1:A, Select A, count(A) where A is not null group by A") Everytime a name gets scanned it adds a point to their name.

[@bafa4984]

hi my friend, thanks for your vids. I have a question : anayone can access to the qr code can scan and add names to the attendence, how to fix that? thanks a lot and excuse my bad english

[@HashAliNZ]

Anyone can access the QR codes, which is a downside to this method. That's why I made this upgraded method: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@brainonfire2324]

Why QR Code does not automatically submitted response? I still have to fill in the questionnaire.

[@HashAliNZ]

The most likely reason is you didn't setup the Google Form correctly. If you have more than one item in the Form or you have made it require sign-in, then it'll send you to viewForm rather than formResponse. Here's a new video showing a better system: kzbin.info/www/bejne/fpLckGVsfc-DnqM&lc=UgyxNUV3hwtp2aXXH9B4AaABAg

[@chaijuighee3817]

How to apply or send it to the students to scan the qr code themselves? Did i need to send it one by one to the separate students? Sorry for asking a stupid question, first using it.

[@HashAliNZ]

Not a stupid question at all! I've actually been struggling to find a solution for three years. I literally just found one last week, and I have a video in the works to come out hopefully next week. Stay tuned!

[@bassammohamed2225]

thank you . but I want to scan another QR without first I should exit from the submit the first form . another meaning Automatically reopen the scanner after scan the first QR

[@lloydkusi793]

Hi, great video, but i have a challenge, the qr code image isnt showing you can see the code when u click on the cell but no qr code image.

[@HashAliNZ]

Hey! Google recently got rid of the QR codes in Google Sheets, but you can use this formula to get them back: =image("quickchart.io/qr?text="&B2) Check out the example spreadsheet to see how to implement it: docs.google.com/spreadsheets/d/1KCepywgslgZhFmxUywOyJ-LooslIRuAcPqMrAR8chUI/copy

[@EttienneWahl-kn9fy]

Good day, if done everything like in your video, but the QR codes don't show. What do I have to do to get them to show?

[@HashAliNZ]

If you're able, hold on for about a week because I've got a new video coming out with a completely different process that'll save you time, effort, and any confusion!

[@GamboKaweIbrahim]

The way you speak is too fast that it would be difficult for one to grasp the concept, please improve to be a bit slow while explanation .

[@oyunaabat9119]

Thank you. Is there any way that I can make QR code to collect my students' food eating numbers from the cafeteria?

[@HashAliNZ]

Hmmm interesting. I'll work on that!

[@chauminh3507]

how can i download the QR code as a jpq. or any image type of file? Thank you for your guidance

[@HashAliNZ]

Don't use this system. Here's a different system that allows you to send out the QR codes in emails automatically: =kzbin.info/www/bejne/fpLckGVsfc-DnqM&lc=Ugyh0X_0uTQrfnlOrlF4AaABAg.9zg9NV49Gxn9zgLztLPzCG

[@anhmong5119]

Hi, Thanks for your great content. How can create a QR code which is scanable by specify devices/ email?

[@heartyeaterkh]

I follow every step of yours, but the QR code is disappeared. What's happen?

[@HashAliNZ]

Disappears? In what way? If you see some QR codes and not others, it's likely your computer isn't powerful enough to show all at the same time. Copy and hard paste (Ctrl+Shift+V) the ones that did load, then refresh the page, then use the formula on the ones that didn't work the first time round

[@maine1626]

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?

[@HashAliNZ]

The way we've done it in the past is to just scan the same qr code and filter out the times. It has some issues but it's super easy

[@gaganwadhwafreelancer]

Is it possible? If i paste all the QR code of every student into their id cards. Only specific authority user i allow to scan that qr code and mark attendance. Because for every user they can attendance from there homes also. Give me some suggestions.

[@HashAliNZ]

Absolutely. Check it out here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@qeissi7015]

Great video, but what if little Jimmy scanned his own QR code? Is there a way to restrict it so that only 1 device can scan student's QR codes.

[@HashAliNZ]

Security can be an issue with this method. Unless you're willing to pay big $$$ for an app, you can't restrict using this method. If you've got Power Apps as part of Microsoft Suite, you can use that

[@mohammadhijazi2367]

Can we make on on microsoft forms and excel without using google apps??

[@HashAliNZ]

No, not with Excel. You can with Microsoft Forms + Sharepoint + PowerApps but to implement it would take understanding of Azure.

[@NoisybeanS]

After the qr code has been generated, can it be copied and pasted on a document like for instance a wedding invitation

[@HashAliNZ]

Not using this method, but I have a new video coming out in the next week so stay tuned!

[@adusei-amofahakwasi8]

It didn't work for me. I need it badly but unfortunately, it didn't work for me.

[@HashAliNZ]

Hey! I've got an updated system that's much better, more secure, and more efficient. Check it out: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@gemechuberhanu5276]

Bullshit. If you're targeting to teach us why not you show us step by step.

[@HashAliNZ]

Which step did you not get? Every step is shown, but this method is old and some things no longer work within Google Sheets, which I've addressed in the comments, description, and updated methods (which are also linked in the description). If you're a grown up and teacher, it's also a good idea for you to learn to take what you see and make additions and changes for your own skill level and requirements. Don't just call something BS because you can't figure it out when thousands of others have.

[@kumonmtedeneducationcentre9478]

Can you add sms alert for parents so they know if their child reaches or leaves the class?

[@HashAliNZ]

Not using this method, but you could using Google App Sheet

[@meddwlarea9013]

I can't reach the url you used (you say in description but couldn't find it)

[@HashAliNZ]

It's still there, but check out this new and improved version: kzbin.info/www/bejne/fpLckGVsfc-DnqM&lc=UgwDU6yGASJwARYnZdp4AaABAg

[@JeneillWollaston]

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?

[@cyrilleemmanuelaka3893]

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?

How do you show the qr codes for students to scan? I have 40 in a classroom. Showing one by one qr codes is not an option. Neither Ms power apps (actually i did one but students don't have power apps).

[@cjdbrink]

I have printed the qr codes for students to use. Laminating the printed cards hasn't interferred with scanning them. When I'm feeling really fancy I use our school ID printer to produce them. I still put a piece of packing tape over the top of the code so they don't get scuffed with use. So far, so good!

[@HashAliNZ]

Some people haveade little fobs or student IDs. When it's made to look like a Professional student ID the students don't tend to play with them much. They come in get scanned and sit down

[@KarenJones-i4n]

Is there a way to email or text each QR code to the appropriate individual?

[@HashAliNZ]

There is! I'm actually working on a video right now that should be coming out next week. I've been attempting to do it for the last three years and finally figured it out, so stay tuned to find out the fairly simple method!

[@THigh-fy2cs]

Can this be done with Excel 365? The problem I run into is printing the QR's with mail merge. My organization does not permit the use of the Google Docs mail merge extension.

[@HashAliNZ]

I wish! Nah, it can't be done. I've tried so many different options and found nothing that works unfortunately!

[@TyraHigh]

@@HashAliNZ thank you

[@Flippss_]

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

[@kensab4065]

I must've done something wrong because every time I scan, the 'Forms' page displays and just lists the names and says that 'the question has been changed. Review your responses.' Can you help please?

[@HashAliNZ]

There was a recent change with stock camera apps that means the scans don't go directly to the submission page. Try downloading the BinaryEye app and scanning from that. Let me know if that works.

[@kensab4065]

@@HashAliNZ, yes it worked. Thank you!

[@DamberSMongar]

Hello Hash Ali, could you please send me QR image copy past link

[@HashAliNZ]

Hi! Unfortunately you can't copy-paste directly from the Sheets cells. You can, however, snip using Windows+Shift+S. It's tedious and sucks to do, so it's best if you format everything the way you want it in the Google Sheet and then print directly from there.

[@CITPTravelPlanner]

How can I retrieve the absent name from the QR Attendance please?

[@HashAliNZ]

I've just released exactly what you need: kzbin.info/www/bejne/oJLIkIl7bK99etk

[@ralphmaalouf5601]

Is there a way we can do the same with Microsoft Forms and Excel?

[@HashAliNZ]

Not at the moment. However there is a way to do it with MS PowerApps. It's actually a good method, but I unlisted it from my channel because I'm not great at answer questions about PowerApps. There are tutorials around if you search for PowerApps Attendance System

[@MarketMarket-e6j]

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?

[@descended8406]

Hi! This was really helpful! But a quick question, can I extract the qr code from the excel as a photo? Thanks a lot! Also can I make the qr scan offline?

[@HashAliNZ]

You could using the snipping tool to create a jpg out of it. You can scan the qr code offline, but it won't submit anything since Google Forms requires internet to submit.

[@cortneeoreilly5364]

I got an error when it came to enter a2:a for the array formula is there any work around for that?

[@HashAliNZ]

What's the error?

[@nemsowathanak7400]

I input everything as you taught, but the QR column is not pop up.

[@HashAliNZ]

Here's a better system that will work for you: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@justsamuel5593]

This just gave birth to a business idea i had for years.

[@HashAliNZ]

Fantastic! Let's see it come alive with this system instead: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@kathleentetwiler7925]

my QR codes came out identical instead of individual...?

[@HashAliNZ]

Weird! Check this system out instead: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@الارشاداليطريبالخرج]

How can I set a password for a form so that only the admin can use the form

[@HashAliNZ]

With this new system, you can just install it onto admin's device: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@cjdbrink]

Hash! My qr codes have disappered???? help! Have been using this version of QR attendance for my work sites, and it has been amazing. The already printed codes work swimmingly, but they are not showing in my setup sheet.....I was able to backup to a previous version last week to restore, but no longer. Any advise would be appreciated!

[@HashAliNZ]

Heya, Without seeing the Sheet there's no way for me to know what's going on. Feel free to email a copy of the Sheet at [e-mail], or you can set up a more secure version of the attendance system here using this tutorial: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=s1Wjsn79_dNUY1tl

[@ludwigvanallanybanez4102]

very helpful video...but when other phone is scanning (android phones) the list appears and need to select and submit the response

[@HashAliNZ]

Hi Ludwig, There was a recent change with stock camera apps that means the scans don't go directly to the submission page. Try downloading the BinaryEye app and scanning from that. Let me know if that works.

[@ludwigvanallanybanez4102]

hello Hash Ali, The App worked...thanks a lot

[@rimasdesigner9471]

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

[@heathroddy8631]

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?

[@rainierdulay5475]

good day sir, I found your video useful, but can I ask how to add another column for age of the person in attendance and also have it exported when you need the excel file report? this will be a big help, thank you.

[@HashAliNZ]

Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@drdalewisely]

Great stuff, but I feel like I'm missing something "big picture." Is the point of having individual URLs and QR codes for each student is that they don't have to select their name from the list on the Google Form? I share a classroom and can't think of a good way to have individual QR codes in the classroom. I don't think asking students to click on their name on a list of 30 students is much of a burden. Or am I missing something obvious?

[@HashAliNZ]

Hi Dale, This method was introduced in the midst of the pandemic when classes were low contact to prevent the spreading of the disease. The QR system provided a way to get students to scan in without touching any screens and without a teacher calling out people's names and sending out their spittle 🤮 An alternative way to do it that has been popular has been to give people a Student ID card with their QR code on it and sign in - similar to how you'd swipe your code at an airport. I have a few other videos coming out over the next month covering different options. Thanks!

[@SunilKulkarniSK]

how to ensure duplicate attendence won't get marked.. i.e. once we scan one QR code & if we scan the same code again, it should not create another record.

[@HashAliNZ]

Check out my newest qr video I released yesterday for how to deal with duplicates

[@SunilKulkarniSK]

@@HashAliNZ Thank you very much Ali for the response.

[@Zeek-Tomo]

Totally did not understand. Way too complicated.

[@HashAliNZ]

I've got a course for beginners if you need help. In the meantime, here's another system: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@madushbimsara]

Sir good morning. My qr is not showing in the sheet why is that

[@HashAliNZ]

Usually because your formula isn't right. Check this out instead: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@DamberSMongar]

I would be grateful if anyone can help me with the QR image copy paste link as mention by ali in the videos

[@HashAliNZ]

Hi! Unfortunately you can't copy-paste directly from the Sheets cells. You can, however, snip using Windows+Shift+S. It's tedious and sucks to do, so it's best if you format everything the way you want it in the Google Sheet and then print directly from there.

[@DamberSMongar]

@@HashAliNZ Thank you. I finally did it with your videos.

[@InviolateTree]

I have set this up but when ever I scan the QR code it adds it as a note

[@HashAliNZ]

There was a recent change with stock camera apps that means the scans don't go directly to the submission page. Try downloading the BinaryEye app and scanning from that. Let me know if that works.

[@GS-gv8km]

Question? You have to stand by and babysit the app per each student? As I see or think I see you have to click back page to do a new scan ... in otherwords ... 30 students should be able to stream line into class with their id qr code and that is that ... however it appears and I may be wrong hence question ... however it appears after each student scan you have to reset the app to take a new scan? is this correct what I am seeing? or am I incorrect? thank you

[@HashAliNZ]

Yeah, was a good option back during pandemic. I have come up with a better, updated, more secure version of QR attendance that just uses a spare phone (most people I know have an old phone lying around): kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@GS-gv8km]

@@HashAliNZ Thank you and yeah you did it! you enable no save button, no babysit app, you enable what many have not which is set the phone down and keep scanner on and allow students to stream in, scan and get to work, very nice. Little much in configs however but still nice ... and you showed me a few things as well in this update on thoughts and options as well thank you!

[@GS-gv8km]

@@HashAliNZ One little question on/off topic if you can help me please ... two questions ... 1. I have a qr code scanner hooked to my computer which is what I will use not iphone ... that said, a usb scanner will dump data like a keyboard into any app, like text, excel etc. The question is, is there any software that you can recommend that is simple and not overloaded that will allow me to dump simple data and organize it with name, date and time ... as I find nothing out there and may have to create simple page in excel on my own ... if you keep excel open or any text app ... the scanner scans the data into it. So that brings me to my next question 2. which you did it but you config it to work with your software and configs ... my question of 2. is can I create a cell in excel that when data is dumped in it records the time stamp and date? more so if so then that should work even manually ... example ... say I type the word hello world into a cell ... as soon i hit enter i want a cell next to it to populate date and time. Be it a keyboard or scanner dumping data into it .. .both are one in same ... thus is there a way to dynamically auto generate the date and time. Thank you again!

[@MELISSAONG-k8s]

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

[@ShivKumar-i1i5d]

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

[@SuperNoble09]

Hi bro, My QR code not show . it was error how to fix it?

[@HashAliNZ]

Here's a better system that will work for you: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@1rolfejo]

Great info Hash. I have watched all the videos on using QR codes for attendance. I do have a question, though. Is there a way to easily see which students DO NOT scan the QR code showing their attendance? Looker Studio does a great job of showing who checks in each day but I can't see who does not. That would be helpful in a large class so I know who I may need to reach out to and make sure everything is okay.

[@HashAliNZ]

Thanks! Here's exactly what you need: kzbin.info/www/bejne/oJLIkIl7bK99etk Import that list into your Looker Studio and you're good to go!

[@1rolfejo]

@@HashAliNZ Thanks! Great info!

[@HakdogDoggers-uf4gn]

Hi, when I press the link after putting the =" thing, my responses keep being blank, it still needs to answer the response and needs to be submitted. How can I fix it? Thank you!

[@HashAliNZ]

I'm guessing you have enabled the "Collect emails" setting. This will require input from the person scanning. You have two options: Either get rid of the "Collect emails" setting. The problem with this is lowered security as you don't know if the right person is scanning. The other option is to leave it collecting emails, but get rid of the name question and change it to something the students will find fun to answer like "How many holes does a straw have? Give your reasons and we'll discuss your answers as a class!"

[@KhimaBibbins]

Hello. Thank you so much for sharing details on how to do this. It is working, however, I would like to have the attendance scanned by QR Scanner, instead of using the phone or ipad camera. It is scanning, but instead of sharing a timestamp and the name, it's sharing a google link. Can you please help? I feel like it's a setting issue, but I can't figure out how to fix it.

[@HashAliNZ]

Thanks for the question. That would be based on the se

[@MsJudyCullen]

After i copy the prefilled link and go to edit the url to the &encodeurl stage, the prefilled link stops showing a response. The name of the first student is no longer "prefilled". Anyone know how to fix this issue?

[@HashAliNZ]

This is a common issue usually related to not entering names correctly. Here's a better system that bypasses this: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@heathroddy8631]

Your videos are outstanding and so helpful. Is it possible to generate individual QR codes for each teacher that go to different PD sessions offered during the day? Everything I have watched from your videos works but I can't figure out how one individual assigned QR code can be linked to multiple PD sessions.

[@HashAliNZ]

Thanks for the kind words. Unfortunately there's no automated way to do that using the method from this video. If you want a less automated way using this method, there's two options: 1. Create a different Google Form for each PD session, then send out the QR codes for each one. That'll be a total pain in the butt. 2. Put a field in the Form for attendees to select their PD session they're attending. This could be problematic because they'd have access to the list of attendees. Fortunately I've got a different method. Just create your own all using App Sheet for one PD session, then duplicate it for each of the other sessions. The teachers can sign in using the same QR code kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=Up609SXdF-7guh6E

[@TanNguyen-hq6nb]

how to deactivate QR code after using it?

[@HashAliNZ]

If you want to disable all QR codes you can go to your Google Form and click the Responses tab, then uncheck the "Accepting responses" slider. If you want to disable individual names, delete them from the Google Form

[@twodayslife]

**** your video is diturbing from next time show screen only not your video we don't want to see your face we want to see screen only. Thank you

[@HashAliNZ]

Absolutely! My newest videos don't have the small screen so you can see more of the spreadsheet. Thanks!

[@twodayslife]

@@HashAliNZ its my pleasure .. we love your videos. sorry if I spoke ridely.Thank you

[@HashAliNZ]

@@twodayslife Totally cool! We're all here to learn and improve. Thanks for you input!

[@jobelgeorge5143]

after typing array cmd i get parse error what to do ?

[@HashAliNZ]

Hi Jobel A formulas parse error means the formula you've written is incorrect. Perhaps spelling is off, or commas aren't in the right place, or the brackets aren't correct, or if you're in Europe you may need to change commas to semicolons

[@kael5912]

Hey! I found this video very useful, is there any way I can include what time they scanned the QR code into the graph in Looker Studio? Thanks :)

[@HashAliNZ]

There is the Table view in Looker Studio that doesn't aggregate (like sum or count would in a pivot table). This will be able to give you their times. It might be easier just to do this in Google Sheets, though. It won't look as pretty but it'll work faster.

[@reynanteyu7741]

tutorial plss@@HashAliNZ

[@patriciastewart2719]

@@HashAliNZ Love the video. I created everything you showed in the video other the Looker Studio. How do you make it so that when the kid scans their code it show a date and time that they scanned it? I run an after school program and I want the kids to scan their code to check in, but I need it to show the day and time they scanned it. I don't want to create student ID cards I want to take what you created in this video and have it record the day and time they scanned the code. Thanks

[@arteezykaisen8699]

How about with Time out sir? thanks.

[@HashAliNZ]

Just make another copy of this and call it 'time out' instead of 'sign in'.

[@lotaesmale4464]

I'm really very thankful when I saw this video and it really works but lately all qrcode is not displaying. please help me. what will I do.

[@HashAliNZ]

Hi! Unfortunately QR Codes have stopped working in Google Sheets this last week. Here's a different (and better in every way) method: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@PaulSb1]

can I do this with Microsoft excel online

[@HashAliNZ]

No, but it is doable with a mix of Microsoft PowerApps and SharePoint if you know how to use Azure

[@damianosimeone4936]

Hi Ali, great video and I have already implemented it. However, I keep getting entries even during nights or from people who were not actually attending the class. It looks like someone else is simply using the URL to submit responses but I don't know why and what they can get out of it. Is there a way to "secure" the scanning to only those people authorized to do so? I know I can collect the emails but I don't want to add this extra "manual" steps. Thanks

[@HashAliNZ]

Hi Damiano, Unfortunately there is no way to add super security to this system. I am working on other projects that will improve on this one, so hopefully that will solve the issues.

[@ethnicdancer]

I noticed that when I set my form to collect email automatically , it recorded the scan as coming from my email, no matter whose code I scanned...could be a great way if students have to be signed into their school google account or network when scanning. just having someone else's qr code will not help. you'd have to have their phone or sign in information... @@HashAliNZ

[@johncarlestella3071]

When i click the link it says can't open file 😔

[@HashAliNZ]

This link? docs.google.com/spreadsheets/d/1UhchGNcIKf5IpoYoyXVzSKpOAL9_V2shWPhWT2H7tbY/edit?usp=sharing

[@tdkotobo6522]

Good but my scanner cannot scan the QR code

[@HashAliNZ]

Try using BinaryEye

[@nickster0007]

I have setup this up and have it working. A question though: How would/could it be setup so an iPad automatically scans the QR code when a kid holds their badge under it, processes it, and returns to scanning for the next code?

[@HashAliNZ]

Hey Nick, I wish I had a good answer for you. That's a feature that QR scanners avoid because someone could be malicious in their scans. If you use BinaryEye you can auto-scan, but you'd need to push the Back button to get back to the camera.

[@islamchihabeddinchebha8164]

thaaaaaaaaaaank you

[@shawnprather]

Will The QR code be the same for everyone? Wanted to print the code on a ticket that we can scan to track those who show up. Thanks !

[@HashAliNZ]

No, everyone gets a unique one. Check out my newest attendance video for a better, more secure system: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=6fC_FiytUy0fPP0H

[@ahmaddakalbab7548]

how to transform QR Code to a link ?

[@HashAliNZ]

Nah, the other way around. The link transforms into a QR Code. Check out this new system that doesn't require a scanning link: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@heathroddy8631]

This is outstanding. I used what you I've learned from you videos to create PD sessions for our teachers. I have it working well. However, if I have a QR image for each teacher in my spreadsheet, is it possible to build an app that pulls the qr code from spreadsheet and sends to each teacher in our district?

[@HashAliNZ]

Great work! This method maybe be completely useless now because it looks like the new Sheets rollout had completely gotten rid of qr codes. Luckily I've got this new method that can help send out qr codes to each of your staff: kzbin.info/www/bejne/fpLckGVsfc-DnqM

[@BrittaniNelson-o2k]

hi there, thank you so much for this tutorial! its easy to follow, not too long, and very useful for the program that i manage. only ONE thing, WHYYYYY won't my QR code pop up? i started from the very beginning 5 times and its still not working.

[@HashAliNZ]

There's a couple reasons - first is that the formula could be wrong (this is the most common), second is it could be a lack of processing power in your computer. Here's a better system that will work for you: kzbin.info/www/bejne/fpLckGVsfc-DnqMsi=wTzUFBBzKsuy3dnA

[@savedthroughbelief2847]

Is it possible to have it sheets display those who HAVENT scanned their QR? I would like to track those who are absent

[@HashAliNZ]

Absolutely. You'll need a full list of all students, then compare who is on the full list with who isn't on the scanned list. =UNIQUE(FILTER(, ISNA(MATCH(, , 0))))