How To Create QR Attendance for Teachers in 2020 !! (Google Sheets and Google Forms)

[@krollb]

This is fabulous! So well conceived, so clearly explained, so on point for a specific need for the times we are in. I just implemented your technique to print ID cards with QR codes for 800+ students after testing. Flawless. We already were using google forms on a shared Chromebook to take attendance prior to COVID, and were 100% remote last year using the same form, but this year we needed a touchless alternative on site which could also be self-serve for remote students. This was perfect. Thank you so very much on behalf of our staff and students. Bravo.

[@HashAliNZ]

Thank you so much for spending the time to write such a supportive message. I really appreciate it, Bud. Good luck with your new approach!

[@fayyurockz2267]

Sir please explain me..how it can be done

[@AlexanderMcGruder]

My boss gave me a task and was expecting me to spend $4000 to solve it. Your video was the answer. So well put together. Explained so perfectly. I think I love you

[@HashAliNZ]

Keep sharing that love, Alex!

[@ahmadrisesatriawicaksono4191]

Wow, It's an amazing system Man. Your explanation is so detail. Thanks a lot for the tutorial.

[@HashAliNZ]

Hope it helps. Thanks!

[@Lootlamma]

This is exactly what I needed! I am using this to track my students office visits. My assistant can scan the code of the student coming to the office and we have instant timestamped documentation!

[@RAHULKUMAR-xj4hp]

Learnt a lot of things in very less time 👍 Please make more and more videos like this .

[@HashAliNZ]

Thank you, I will

[@marcblanco5472]

I used your "old" method for the 20th anniversary event of our highschool. It was quick and reliable. I see now that you have a better version of it. Can't wait to see how it works. Thanks a lot!

[@HashAliNZ]

Excellent! It's got updated formulas to take into account a bunch of different text types and even different alphabets!

[@ramonvictorviray2546]

The instructions are so clear and easy to understand. You helped me a lot, sir. Thank you so much!

[@HashAliNZ]

Glad it helped!

[@ഷാജിപാപ്പന്-ഹ8ങ]

i havent seen someone this thorough in google sheets & forms. Appreicated!

[@HashAliNZ]

No problem!

[@Jasmine-lz5yf]

Extremely clear in explanation, very detailed & helpful! Thank you so much

[@HashAliNZ]

Thanks!

[@evineiteljorge8920]

Really awesome video. Thank you for teaching me how to create bulk QR codes without going through a sketchy site!

[@HashAliNZ]

Thanks! There are some good sites out there, it's just tolling to research which ones are good

[@allisonbarker8082]

Thank you!!! You just saved me so much time this evening. I wanted to create something like this for contract tracing with seats, followed the instructions, and they look perfect. Thank you again!

[@HashAliNZ]

Glad it helped!

[@lauraperry6042]

@@HashAliNZ this is a great help. I too want to use this method for contract tracing. Except I plan to assign qr codes on seats and have students scan the seat when they sit down. I can't get the form prefill option to appear if I opt to collect email addresses? Any ideas there? We want to track what student sits in what seat (date, time, etc).

[@sudarshanms7822]

@TheMathLab NZ Thanks ! Please tell us how to resolve it.

[@jonchalk3855]

Just used the "join" formula on MS excel. Works exactly the same. Thank you.

[@HashAliNZ]

You got QR codes in Excel?

[@angelaquia1394]

this channel is underrated

[@HashAliNZ]

Thanks!

[@aumarivero]

agree

[@nischalsubedi4213]

Awesome Man, never knew you could do such things with Google Sheets and Forms! Thanks for the knowledge my man!!

[@HashAliNZ]

Happy to help!

[@mohanjayaraman9018]

Thanks, Very useful and time saving. What if any student scanned some other students QR by mistake or How can we stop proxy attendance?

[@sapkotadiwash]

Yeah, that's the challenge here. Otherwise it's just cool

[@faruqr8127]

Can try requires log in. That way can cross reference

[@raigledsosmith]

Exactly !!! that's what I thought when he 4 times scanned the QR code from his single phone itself. By this way 1 student can apply fake attendance for their classmates. How do we counter this hiccup???

[@HashAliNZ]

You can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit. Some people may scan for their friends. You do need to teach the students this is a trust-based model.

[@ValpasKankaristo]

You could also try giving/sending each student only their own codes. Requires a bit more effort and still isn't fool-proof, but it might discourage scanning others' codes!

[@bryanchristiansalvador826]

Dude you are a genius! You deserve more subs than what you currently have. Keep it up.

[@HashAliNZ]

Appreciate that!

[@PaulsEnglishFukuoka]

Very clear instruction and a perfect result. Impressed. Following avidly from this point.

[@HashAliNZ]

Great to hear!

[@Lizellers]

I enjoy how the "student names" are characters from the Rugrats show. Awesome!

[@eileenlai6308]

Great video! So easy to follow and so clearly explained. Thank you for sharing!

[@mariaeddieferomero4368]

Thank you so much, please do continue making contents like this. I was able to create one for my class because of your concise explanation in this video. 👏👏👏 Have a great day ahead!

[@HashAliNZ]

Will do!

[@GloryApologetics]

Superb video! I followed all the steps but the QR Image wont show-Up. Any solution. The space looks blank where the QR image is supposed to appear. Appreciate your efforts.

[@franciscofretziec8251]

Same problem with mine appears to be blank

[@HashAliNZ]

Heya, Check if there's any spaces in the names. If there are, get rid of them.

[@HashAliNZ]

Heya, Check if there's any spaces in the names. If there are, get rid of them.

[@minirollsrule]

Also having the same problems. Checked and there are no spaces in URL

[@HashAliNZ]

@@minirollsrule Feel free to share with me and I can take a look: [e-mail]

[@tristanparsadh8601]

Subbed already 6min in and im learning more than my entire high school

[@HashAliNZ]

Thanks for the sub, but no need to put down your high school - there's no reason for them to teach this stuff. If you wanna go more in depth, I've updated this video with better and more efficient formulas: kzbin.info/www/bejne/lWeQi3d9g9mWiMk

[@jax.8.10]

Thanks. It's amazing! However, is there any way to restrict students to scan multiple times such as some students will scan the QR for their friends? And what if they scanned wrong? Just delete it in Google Sheet Response Form?

[@HashAliNZ]

Hi Jax, Yes you can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit. Some people may scan for their friends. You do need to teach the students this is a trust-based model. If scanned wrong, you can delete from either the Responses Sheet or from the Google Form itself.

[@christopherlawes9286]

Alternatively, you could give the students printed qr codes and get them to scan a webcam to register attendance. That way it doesn’t rely on them having internet/data and you can watch them so they don’t scan multiple cards.

[@Digital.Done.Right.]

this is such a great video! I did not know of the Google API we can use for this. I have been wanting a static code to print on my business cards and on stickers but didn't want to pay for it. Now with your tips and explanation I can code a QR code. Thanks for making this even if it was for a different audience.

[@HashAliNZ]

Glad it was helpful!

[@christinejelbert4676]

Thanks for this! It's absolutely brilliant and elegantly done. Can't wait to see how easy attendance is going to be:-)

[@HashAliNZ]

Can't wait!

[@TheJcperla]

Good for first day until kids start scanning each other’s codes. Cool concept though. Better if they have the code and teacher scans.

[@HashAliNZ]

@@TheJcperla Yeah, that's the way a lot of people have implemented it. But there's downsides to that too - for example students scanning the code at home. Check out this video for a more secure version: kzbin.info/www/bejne/o5KskqWjndmZmbs

[@TheJcperla]

@@HashAliNZ that is an awesome solution. Could the Google form be set up so only certain people could access it? This would prevent students from scanning?

[@YonadavTapuchi]

This is perfect! Exactly what I thought of making, but hadn't a clue where to begin... Thank you sooo much :)

[@HashAliNZ]

You're very welcome!

[@3101199]

Great! Is it possible to add the location where de scanned was made? To know where the person is in the Moment of the scan

[@HashAliNZ]

You have a few options. Option 1: Make a new QR code for each student for each location. Option 2: One QR code but then have another question which is manually filled out before clicking Submit

[@shadyworld1]

Option 3: Add 1 random Quiz Question only teacher got there answers. Each get the one word/code answer for there question from the teacher as they attendance approve physically! Whoever scanned and didn't answer the quiz is a skipper tried to cheat attendance. Basically it's the basic 2 Key Auth. Semi manual, based on military standards. No fancy gps required or biometrics! Always simplist methods works the best... By the way... Special Tip! You could make questions of Auth. IQ or Equations like SAT hardest Questions that would challenge them if they answered it they may have late entry for the effort once a month!

[@juviegonzalesgalutan73]

Wow im gonna do that to our staff since we have a new company thank you🙏🏻🙏🏻🙏🏻🙏🏻 more power

[@HashAliNZ]

Brilliant! Make sure you check out this video for a different method: kzbin.info/www/bejne/o5KskqWjndmZmbs

[@timteacher]

Excellent video. I'm surprised you don't have more followers. You explain everything in a concise and logical way. I've followed your video and adapted it slightly. My students here in Seoul have both English and Korean characters in their 'name' field. This morning I tested QR attendance with the students and everything worked, except that only 3 (out of 10 or so) responses had names attached to them. The timestamps showed all of the students were able to submit their attendance using QR codes though. Is there anyway that Korean characters could be screwing something up, or is there another issue that I'm not aware of? I'd be happy to share the spreadsheet with you or anyone else who is willing to take a look. From one Kiwi to another.

[@HashAliNZ]

I've never tried with Korean characters. My email is [e-mail] if you wanna send it to me

[@ndunyumarketplace]

This is honestly the best tutorial

[@HashAliNZ]

Thanks!

[@moriahdamian4542]

Can you create a video dedicated to shortkeys for Google Docs, Sheets, etc.?

[@HashAliNZ]

Interesting idea!

[@campbellneeson1650]

Can I say this video is exxactly what I was looking for and explained really clearly -thank you. A couple of questions if I may? 1. Can the same QR code be resused on another day? 2. What is the process for emailing the code to a student, rather than printing it out. (I'm thinking about contactless use - as almost all students have mobiles these days anyways!) thanks

[@HashAliNZ]

1. Yes, absolutely. We can use it for years and then filter out the details we want (like filtering by day). 2. If you're on a Windows machine, use Windows+Shift+S to open the snipping tool, then snip the code, then email it to the student.

[@tajuddina2455]

Thank you. A clear as glass explanation! Subscribed! Though I am not a teacher, never the less appreciated this work very much. We were able to create the attendance sheet as per video first time correct (including the part of printing, laminating and producing the QRCodes!). I wonder if you could help someones in further need and expand the functionality of this sheet. I noticed on the last segment of your video...Create A New Spreadsheet - it is able to detail the timestamp of who attended, and at what date and the time. Could you create a formula that is able to pull the data and identify who was a little late (ie 15mins) or very late (ie 30mins) or didnt make it (not checked-in) at all for class or work (ie >60mins) ? And send out and email reminder(s) to the student/worker and/or Supervisors? Thanks. Tajuddin

[@HashAliNZ]

Absolutely. I have an old video somewhere that goes through latenesses. I'll see if I can find it

[@HashAliNZ]

Here you go! kzbin.info/www/bejne/pYq6YoePntdspLM It's an older video so the quality is not so great, but it has the basic details. Let me know if you get stuck

[@tajuddina2455]

Thank you. Will look into this

[@haythembenhmida9695]

great video; i m wondering if the in and out time could be implemented thank you

[@BeLikMike23]

This is an outstandingly well thought out and detailed tutorial. I followed everything exactly and was able to generate a full attendance tracker for my students. I am having an issue though where some scans are coming in without the students' names, and therefore they are being marked as absent. I'm not sure why this would be happening, and it isn't always the same students that are coming in scanned without names. I verified that the names match the Google Form perfectly (I copied them and pasted so everything matches), and if I personally scan each QR code myself, it comes in with the names as expected. I just can't seem to figure out what to do to solve the blank name problem. Any help would be greatly appreciated. Thanks so much for putting this video out. I'd have been lost without it.

[@HashAliNZ]

Thanks for the kind words. Just so I'm on the right track: - Student A signed in but it scanned without a name attached - On a different day, Student A was able to scan no problems but Student B signed in with a similar issue - The names on the Google Form match exactly the names on the Google Sheet and you have tested each one The next step would be making sure the URLs are correct. Find a student whose name did not scan but their scan did register. Go to that student's URL that's next to their QR code in the Google Sheet. Read the URL to make sure it's correct and then click on it to make sure it registers properly.

[@BeLikMike23]

@@HashAliNZ Thanks so much for the reply. That's correct. I just checked what you suggested and it registered as expected when clicking their link, also I can personally scan these students' QR codes using my own phone and it will register perfectly fine when I do it, so based on that I can't seem to understand what the issue could be.

[@HashAliNZ]

@@BeLikMike23 That's a new issue for me. I haven't come across that one before. It's possible the QR scanner being used has a problem. I recommend using BinaryEye for the scanner

[@BeLikMike23]

@@HashAliNZ I appreciate the recommendation. I'll suggest it to the students and hope it solves the issue. Thanks so much for your replies and for your superb video.

[@khalidkhadim1854]

the video was super great and strait-forward. well done

[@ronniehayes4199]

You make it look so easy!!! Thank you for a great tutorial. Now I know what I will be trying for the next 24 hours!!

[@HashAliNZ]

Good luck!

[@purpleheart8491]

@@HashAliNZ hi can ask how to make qr code for organization thank you in advanced i will wait for your reply

[@HashAliNZ]

@@purpleheart8491 Just follow the same steps as in the video, but the URL will be the URL for your organization

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

[@danaviv]

Well explained! Quick Q: Where does the student access the QR code? Do you share the Google Sheet with the class and they scan in each time with the same QR code?

[@HashAliNZ]

Hi Dan, Yes it's the same QR code each time, but each person gets their own QR code. At the end of this video I have a quick clip showing how I did it for my students.

[@9947198312]

It was just amazing. But, while scanning a QR code, the whole list of students is coming for selection and submission. How to resolve this. Thank you

[@HashAliNZ]

Hi Faisal, There's a bunch of reasons this may happen. Usually it's just down to a mistake in your URL or in concatenating the names. Double check you have the names correct, you have a plus symbol (+) between names, and your URL matches the one shown in the video. Thanks!

[@kevinadriansyah8513]

Yoooo, it was a nice system. i will come back later if theres more update.. thanks a lot more sharing

[@HashAliNZ]

No problem 👍

[@pawaliamit]

i want to automate this for time in and time out. how we can do that?

[@HashAliNZ]

Check out this new video, and then duplicate the App so you have one for checking in, one for checking out: kzbin.info/www/bejne/fpLckGVsfc-DnqM&lc=UgwDU6yGASJwARYnZdp4AaABAg

[@Abidali-qi3xj]

I have done this

[@lazarereznik4854]

Thank you so much TheMathLab NZ! I really like your presentation and the clear explonations you provide. Well done sir. Sure it'b be great to limit the ability to flash to one single account, to prevent anybody to flash their code when they please. Yet it's a usefull method you gave the world ;-) Cheers!

[@HashAliNZ]

Thanks, Lazare! Yeah, it would be good to do that. There are ways to create apps specifically for that, but that's beyond my capability!

[@lazarereznik4854]

@@HashAliNZ Yours seem fine enough to me ;-) The check out would be nice too. Thanks again, hope to read more exiting tricks from you soon.

[@IrfanKamil]

brilliant idea and love the simplicity on it, cool bro, thanks for sharing these!

[@HashAliNZ]

No problem 👍

[@safiyyahdiep3913]

That's so awesome. Can you suggest how we can use this to organize an attendance for multiple days or even a month. Perhaps just by incorporating another variable field to specify a date?

[@HashAliNZ]

No need. The Google Forms automatically collect the date, so when we've collected the info we can filter by whatever date we want. It'll work for years with no need to update it (unless someone changes their name, but maybe that just means we should be using student IDs instead of names?)

[@slrussell0116]

This is great. This is almost what I am looking for. What I need to do is take the generated QR codes, attach it to an email so I can email the codes to attendees so that they can be scanned as they enter the building. Is that something that can be accomplished? Any tips on how to do that?

[@HashAliNZ]

Not a problem. Just screenshot the QR code and email it to them. If you're on Windows, it's the Windows key + Shift + S to snip the area you want.

[@mindtalktv3379]

Thank you so much for this. really amazing...I am a teacher here in thePhilippines. I can use this..Thank you

[@HashAliNZ]

Glad it was helpful!

[@khalidQureshi]

Excellent and amazing.....simple and robust. Thank you.

[@HashAliNZ]

You are welcome!

[@mozmr]

Excellent video and very easy to follow

[@HashAliNZ]

Glad it was helpful!

[@harsh5942]

Can we create only one qr code for all students attendence?

[@ritumali3753]

Really very helpful , it will lessen the burden of a teacher as well student also

[@HashAliNZ]

Thanks!

[@kiduseshete4391]

Hello, Thank you for the video, this was very helpful, I was hoping I would adapt this to my office, but I have a concern, that is, can my employees take a picture of the QR code on the wall, print it out and scan it from anywhere else without having to show up at the office?

[@HashAliNZ]

Yep, that is a concern. There is a bit of trust required. Alternative, if you have Microsoft PowerApps then check out this video: kzbin.info/www/bejne/o5KskqWjndmZmbs

[@fahimhussain1495]

Excellent Informative Videos, & Very nice person I have ever seen in my life. Thank you again TheMathLab NZ...😊

[@HashAliNZ]

My pleasure!

[@rpitpatel1004]

Great video, looks like you are master of Google products. Thank you for sharing.

[@HashAliNZ]

Thanks for watching!

[@kerryseip9044]

This is A-MAZING! Thank you for this!!!! I do have some problems, hopefully you can help. When one teacher scans the QR code, the Google Form shows that a response has been received, but nothing shows in the list or outcome. But another teacher scans the same QR code and it works as it is supposed to. Should there be a difference between Android and iOS? I have also set the Share status to "Anyone with link" and someone else has to "ask for permission" when scanning the code. Any help would be SO wonderful!

[@HashAliNZ]

I honestly can't answer anything about iOS. I know nothing about those devices. My thought when reading this is that perhaps you created it with your school account, and it's possible that your IT department may have set the access to domain-only. Meaning anyone from outside your domain (whether it's your school or district or whatever) won't be able to access it without another set of permissions.

[@yulnavdb]

@@HashAliNZ I have the same problem with some names and not other. Even if I copy and paste the link - it still do not register as a name in responses

[@soomeng831]

This is so clear for your guidance. However, I wonder why either I click on the URL or scan the QR code both show all name from the form instead of one which you show us.

[@deshdaw3514]

same problem, and it says "The question has changed. Please review your response."

[@deshdaw3514]

Oh wait, I got it. In the URL , &A2&"+"&B2 I instead gave &A2&"="&B2

[@soomeng831]

@@deshdaw3514 thanks for your reply. I will tryout later.

[@soomeng831]

Still show all name instead of particular name.

[@soomeng831]

Why you can scan the QR code for particular user to directly check in? But I can’t

[@azim3685]

Thank you so much for the video, Sir! It's really helpful. I've a question. From the video, it shows the students that is present on that day. Would it be possible for me to see who's absent on that day from the name list?

[@heleenreid7140]

This has been great! I've been trying to streamline attendance for 138 students for ages and this might just work. I have followed all your intstructions and some rows are not filling in the QR code. Most have filled automatically but some are empty. Any advice? Also any idea when you might do another useful video on how to take this attendance for multiple weeks in a course? separate response collections?

[@HashAliNZ]

Fantastic! I'll be making a video that covers all of this today. Hopefully I will have it ready to be released this week!

[@surabhirathore8947]

Hello, loved your video. Just need to know how to print these QR codes separately for each student?

[@HashAliNZ]

Here you go: kzbin.info/www/bejne/l2rIXoOmbLqHec0 Print them all in one go, then cut them up and laminate as you please

[@irfanfatoni5976]

amazing video, i want to ask someting.. is there any way to save spreadsheet into excel format without losing QR code? because i want to use QR code as part of my mailing.. (if possible) (basicly invitation with QR code.. but for 1000 people in ms word)

[@HashAliNZ]

Stock Excel doesn't have QR capability. There must be a way to mass email from a Google Sheet, but I'm not sure how to do that.

[@renamora3583]

Your video is great and easy to follow. Is there another way to do instead of clicking the link after scanning the QR code? I want that the student will just scan their QR code and google forms will automatically get their attendance without clicking the link. Thank you.

[@HashAliNZ]

Hi Rena, Download BinaryEye. In the settings of BinaryEye you can set it to automatically go to the website without clicking the link. Thanks!

[@saquibm6446]

Thank you.. looks amazing. can you track down like in and out time also?

[@HashAliNZ]

Sure. Here's an example: docs.google.com/spreadsheets/d/1Rf3YOD7ly8Jz_TdFISUBDQImTRjo5xIkOpRj3hW9IOo/copy

[@glenjohnwong9020]

Found the problem with the ones not generating a QR code - it's when some of the student names has two name .. for example Glen John , you have to put an underscore between the 2 names Glen_John

[@HashAliNZ]

Nice! That'll work!

[@4988raja]

Does this QR format allows attendance taking for multiple days or just a single day? Please advise. Very interesting tutorial!!

[@HashAliNZ]

As many days or months or years as you need. You can then filter based on what date you want to see. Here's how to filter: kzbin.info/www/bejne/q6GrZoaJrdCqhbc

[@hobbytime1502]

Awesome tutorial keep it up bro. That goes a long way. Thank you very much.

[@HashAliNZ]

Thanks!

[@minamaged1688]

Thank you so much I just wanted to what if I want to make for my students along the whole semester.. Am I gonna use the same link or what?

[@HashAliNZ]

Yes, the same link. You can then use the data and some spreadsheet magic to filter your data depending on which date you want to see. See here on how to do that: kzbin.info/www/bejne/q6GrZoaJrdCqhbc

[@cherriemaecopioso8836]

Thank you for sharing. What application did you use to scan the QR code? Thank you

[@HashAliNZ]

Binary Eye

[@patriciashawwatkins2901]

Thank you. Remarkable! I enjoyed following along. It worked on the first try.👍

[@HashAliNZ]

Thanks Patricia!

[@sageerc1381]

Great Video...Very Helpful...expect more like this...thanks ...Subscribed

[@HashAliNZ]

Thanks for the sub!

[@camiloparadarojas3830]

Great video. I am thinking how can we use this to rate subjects in a study by just scanning the QR code. Any idea of how can this be set up? I wonder if adding another layer to the form would help.

[@HashAliNZ]

Interesting idea. Is there any reason you want to do a QR system instead of a basic push button?

[@aaronsievewright4576]

Fantastic video really easy to follow. This may have already been asked but is there away where we can track students signing out as well as signing in.

[@rowenapablico6229]

Thank you very much for this. How does this look like from the student view? If I am the student do I look for my name from the google sheet and scan the QR code?

[@HashAliNZ]

That's a possibility - another way is to have physical copies. Just print out the Google Sheet alongside the corresponding name

[@noumankhan5205]

Amazing Video !! I have created exactly same QR Code and Google sheets and It's working completely fine with Iphone QR Code Scanner But with android QR Code Scanner it shows the URL which we use in Excel sheet. Can you please tell me how will it work in android too !!

[@filmtokstudio9099]

Pls any tips on doing 3-5 Multiple choices with radio buttons, checkboxes. Every time I create it, and click submit form I created it only allow first two option to go through, but 3rd, 4th, 5th and so on option just wont go through for both multiple choices and checkboxes. In affition if you have any tips on file upload would be amazing!!!

[@CubbyBaumann]

Thank you for your help! This was so informative. My predicament is as follows, I would like to assign and provide participants in my program 1 QR code. I would like to scan the QR code for their attendance as you explained in your video but I would also like the option to somehow scan their code to keep track of their meal pick ups as well as for a linen exchange system. I would like to use separate google forms for the meal and linens. How would I go about expanding the access to the multiple forms with one QR? thank you for any and all advice.

[@HashAliNZ]

You'll need two QR codes per person. One will be for meal picks, the other for linen exchange. If you really need just one QR code, then you'll have the person scan then select either meal pick up or linen exchange then submit.

[@harutanaka3647]

@@HashAliNZ I also have similar problem. One QR code need be able to distinguish Task 1 or Task 2 or Task 3. Print out end result who are in each Task at end of day. I was thinking add a question in Google form prior to pull up google Lens, then select Task 1, 2 or 3 before scan. How to do about doing this ? Is this too much coding ?

[@HashAliNZ]

​@@harutanaka3647 What if you set up each student on their task first, then give them the QR code that autofills both the task number and their name? You can semi-automate the setup process using some more advanced techniques in Google Sheets. Here's a big project that someone on Reddit was working on that allows you to select the information first, and then you can create a QR code based on the final URL docs.google.com/spreadsheets/d/1Jm71h1zWXim8rds4-mytnU4V5jifwDCxeG9uw5AcGbw/edit?usp=sharing

[@nicolegeorge8975]

Hello how would I implement this with different classrooms and the same students? Like if a student goes to a different class, but attendance needs to be put for that new class on the same day.

[@aitorgallastegui5200]

Thanks for sharing!!! I apologize for the simplicity of my question but when putting this into use in class, does the professor use their own phone to read the student's QR codes or doe sit work differently? Thanks!

[@Rafaelnin]

Great video!! Question: Is it possible to use the qrcode a single time? I want to make sure that I have no gatecrashers in my party

[@cindygarrido8102]

Thank you for this very informative discussion on using QR code in tracking attendance of students. I just got a problem with my MacBook it wont show all of the qr code. i don't know why? what should I do?

[@HashAliNZ]

Hi Cindy, The most common reason that QR codes don't show up is due to spaces before, within, or after the person's name. Here's an easy fix: Select the column(s) with the names Press Ctrl+H In the Find box, type a space Leave the Replace With box empty Click the Replace All button. You should now see your QR codes

[@darrylbersalona4887]

Hello TheMathLab NZ. How about adding some info aside from their names like home address, age, contact number and the like. Thank You...

[@HashAliNZ]

Not to the Google Form. This info should already be part of your school's Student Management System. If you want it in your Form Responses sheet, you can create a new tab and import the info from your SMS, then use it however you wish.

[@ma.cristinamejilla2462]

What must be the appropriate scanner? Thank you!

[@ahmadkhairil2932]

Google lense

[@HashAliNZ]

Google Lens works fine. A lot of phones have a scanner built into their regular camera. I recommend BinaryEye. It's open source and has additional options so you don't have to click as much

[@RiiiiNNN]

hi. great video sir. I just want to ask if you have any idea on how to separate the time in and time out? thank you in advance

[@HashAliNZ]

Check this out: kzbin.info/www/bejne/q6GrZoaJrdCqhbc

[@vishalparkar]

Insanely great yet simple.

[@HashAliNZ]

Thanks!

[@beaufortcorporateservicesp5525]

Hi @TheMathLab NZ ! This is a very good video. The only problem I had was the 1st Row QR Code image did not show up. When i copied to the rest of the rows, they all showed up. I'm not sure why this is happening. Also, is there a way to register and recognise the phones IMEI to ensure that friends don't cover for each other to scan on their behalf? I'm not sure whether you are still replying to comments. I hope so. Thank you. David

[@HashAliNZ]

Hi David, Thanks for the question. I've replied to your email. Cheers!

[@FortAbrahamLincoln]

Hi This was very helpful, one question, when it comes to the generating the QR Code. Only one line of data creates the code image. the other lines of data don't ever create. Any thought's why these particular cells won't generate? I've reviewed the formulas and everything seems to be correct. Thanks

[@HashAliNZ]

Hi! Check if your names have spaces in, before, or after them. If there are any spaces it won't work.

[@FortAbrahamLincoln]

@@HashAliNZ Thanks, that is exactly want the problem was!

[@siddheshveer]

Hello, this system is well thought through. I am trying to build one for a convention that I am planning. We have 4 events at the convention. The attendees have paid for the choice of their events. Do you think it will better if I make 4 separate google forms and 4 google sheets for each of the events? Some attendees will bring in 2-3 guest (they hv mention in their rsvp) with them during the events, how do I collect the response or calculate the guest count that an attendee brings with him/her? Any solution will be very helpful! Thank you!

[@HashAliNZ]

Hi Sidd, It sounds like you're doing this with adults. Adults are bit more easy to work with, so I think a better option would be to have a Google Form (linked via QR), then ask for the person's name and how many people they brought. In the settings, change the General options to include collecting emails, sending responses, limiting to 1 response, and allow edit after submit. To make sure they are signing in and are entering their details properly, perhaps have a raffle at the end - a random person selected from those that sign in. Here's a quick example: docs.google.com/spreadsheets/d/1vRycBEK7owlbTkBhvD4HwDZTi5N8LNcUkqC2UBBUAq8/edit#gid=0

[@siddheshveer]

​@@HashAliNZ Appreciate the prompt reply. We are placing Ipads at the entry door for each event. So I can keep the QR code image open all the time. One other solution I thought of was using your video tutorial for students' check-in to set up the G form and G sheet and sending an email containing the unique QR code (associated with their names) to our attendees. (the event manager requested a solution that involves sending QR codes to the attendees). On the day of the event, the attendees arrive and the convention volunteers will scan the QR codes of the attendees. The response for that attendees' QR code scan will be collected on the G form. But going further, can we add a formula so that when a QR code is scanned that name or row on the G sheet which has the prefilled attendees list gets strikethrough? And can we ask the attendees to use the same QR code associated with their names for the rest of the events during the convention? I may have to update the G sheet before each event with the attendee list. I am open to listening to any other simplified solution for check-in that involves sending QR codes to attendees as a ticket from your end. (perhaps using zapier). Thank you!

[@exoticexplorationtourssdnb9303]

hi its a great video. very informative. i would like to ask that is it possible to create staff automatic location detect attendance during check in via the scan code? means that staff will check in attendance using their location.

[@user-io8rz8rr7u]

Is there a way to do a check in check out bathroom pass system with this? And have it organized by dates? Or something

[@HashAliNZ]

There is. It gets a bit messy because there's so many parts. I've explored using a touchscreen instead, but that does involve touching something which some people want to avoid due to bacteria and viruses

[@JoshuaDometita]

How can automatic generate the duration, example if the student time in and out? how can calculate it? manually? or there is another option?

[@allan.adimoolah]

What about some form of QR attendance register for persons coming to an event to simply scan a code upon entry and be registered with their basic contact details

[@shastatiwater5686]

I am trying to use this in my classroom for attendance as well. My iphone is doing a great job scanning but when I use a barcode/qr scanner gun it is documenting the link instead of the information.

[@HashAliNZ]

Yep. Works exactly the same way. One way others have done it is to print out and mail a lanyard with the QR code when they register for the event. Then when they come to the event, their lanyard gets scanned.

[@rozitabintimohdzainiekpm-g7193]

Hi Hash, I tried to create a pre-filled google form with sections but didn't manage. The user has to select an option in section 1, before being directed to the next (e.g. section 2). Based on the selection in Sec.1: - In section 2, the user has to select his/her name (from a dropdown menu) and the following fields are supposed to be auto-filled. What should I do?

[@denysefelix19]

Hi, Your video is amaizing. Thank you for sharing. I am trying to use this method for check in tickets for an school event. I am trying to copy and paste the QR code on the tickets but it always comes out as a white box. I tried copying in google docs but I get a message that the image couldn't be retrieve. Any idea on what it's happening? Thanks!

[@HashAliNZ]

Hey Denyse, unfortunately the images of the QRs can't be copied and pasted. Instead, use the snipping tool. If you're on a Windows machine you can press Windows+Shift+S to get the snipping tool working

[@AjithVenkatesanBhuvana_]

Thanks for the Clarity Brother

[@HashAliNZ]

Any time

[@AjithVenkatesanBhuvana_]

@@HashAliNZ Sure I will ask Once again Thanks Brother

[@KKHSPGN]

Great video. Some of my QR codes don't show up. The formula is in the cell but no QR code.

[@samialkendi4862]

This is awesome, I suggest if there is only one QR code for the class. so every student scan that code will be recorded. If you could do it, please just upload the steps. Thanks a lot.

[@HashAliNZ]

Hi Sami. If there is one code for the class, you wouldn't be able to find out who is scanning, unfortunately. It is possible to create an app with this function but that's above my abilities at this point!

[@samisonkr]

@@HashAliNZ you have done so great, buddy.

[@tuugamusu]

Hey This is awesome!! But I am trying to create the same thing for my bootcamp business. Any possibility you could do show us how to do this with members to sign in via just one QR Code?

[@HashAliNZ]

Absolutely. Try this: kzbin.info/www/bejne/o5KskqWjndmZmbs

[@chiengnee1]

I need this. I got to try it out. Thanks for the tutorial. The Qr code is forever can scan? What will effect the QR code not effective?

[@HashAliNZ]

The QR will last forever. There's many things that can go wrong, but make sure you follow the tutorial and you should be good to go. Feel free to ask any questions.

[@chiengnee1]

@@HashAliNZ yes ...afraid the command goes wrong. Hahaha..will try to follow it slowly. I always has prob to keep the attendence tracking.

[@becalvin]

Nice! what do you think if I want to qrcode scan and record the check-out time as well? Thanks!

[@HashAliNZ]

Absolutely doable! I just made an example for someone else not too long ago. Check this out --> docs.google.com/spreadsheets/d/1Rf3YOD7ly8Jz_TdFISUBDQImTRjo5xIkOpRj3hW9IOo/edit#gid=882512917

[@sydneyingram9039]

@@HashAliNZ is there any way you’d be able to make a quick tutorial on to do this? Lol I’m not exactly google sheet savvy.

[@HashAliNZ]

@@sydneyingram9039 I can but not anytime soon, sorry. I'm in the middle of selling and moving so no videos for a little while

[@zhanielynnagmata4874]

@@HashAliNZ could you make a video tutorial for the check-out time as well?

[@bluestallion1984]

Thanks for the video! When I try this, my QR code links don't match up with links in the cell. The link in the QR code ends with usp=pp_url (so no "entry") even though the URL in linked column has all the information. In the end, all of my URLs go to the form with no entry. Any ideas? If I take the same URL from my sheet and plug it into a "one-at-a-time" QR code maker, it works fine.

[@HashAliNZ]

Hey Lee! This sounds like I'm going to have to jump into your spreadsheet to see what the issue is. Feel free to share with me (either editable or just viewable, I dont mind which): [e-mail]

[@okfaith4360]

@@HashAliNZ I'm having the same issue.. My links work in great from the sheet. As soon as I scan the QR code thought it links to the link but ending at formResponse? So you still have to check a name

[@HashAliNZ]

​@@okfaith4360Hey! It seems there was an update in camera apps that cause this to happen. It still works for some people, but others seem to be having this issue. Fortunately, I've created a completely different method for QR attendance that is simpler, allows for Student ID sending, and has been security: kzbin.info/www/bejne/fpLckGVsfc-DnqM

[@deliarivera9868]

It looks awesome and it was easy to follow. How not sure why when I scan qt it does not register the response on Google forms? Could it be that my share is locked? If so, how do I unlock it?

[@HashAliNZ]

Hmm I haven't come across this issue before. A common issue is that people forget to delete the pp_url part at 6:40