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

Рет қаралды 177,893

Жыл бұрын

**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.com/spreadsheets/...
Advance your analytics journey: Contribute here for expert consults and additional tools: ko-fi.com/hashalinz
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/qr?text="&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 ↓↓↓

Пікірлер: 472

@HashAliNZ 8 ай бұрын

Check out an updated, better (in every way), more advanced, simple set-up, more efficient and secure system here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@gerimiahmaribbay3460 Ай бұрын

googleapi doesnt work

@HashAliNZ Ай бұрын

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

@creadorstream 4 күн бұрын

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

@rimasdesigner9471 5 ай бұрын

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

@rimasdesigner9471 5 ай бұрын

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

@rhodney7 10 ай бұрын

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

@HashAliNZ 10 ай бұрын

Great!

@HashAliNZ 8 ай бұрын

If you want an even better system, check this one out: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@alisonhowd 4 ай бұрын

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?

@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!

@heathroddy8631 3 ай бұрын

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?

@musajohnsesay6663 10 ай бұрын

Thanks for the information

@HashAliNZ 8 ай бұрын

You're welcome! If you need something better, check this one out: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@JiteshJassal-st3xu Жыл бұрын

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

@HashAliNZ Жыл бұрын

You could add filters. It is a little bit of work, but it can be done!

@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

@MCS.VEDIOS 3 ай бұрын

thanks for video 😇

@user-ii6rf4dh5i 6 ай бұрын

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

@jbdelacruzdigital Жыл бұрын

THANK yOU SO MUCH very helpful

@HashAliNZ Жыл бұрын

You're welcome!

@whiteredi14 Жыл бұрын

Happy New Year mate. Keep it up

@HashAliNZ Жыл бұрын

You too! I look forward to learning some top management techniques from you this year!

@hannahmaricarreon1486 4 ай бұрын

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?

@HashAliNZ 4 ай бұрын

Hi Hannah, check out the latest QR attendance video for a better, more secure method that includes downloading or sending out the QR codes as student IDs: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@abubakarimamlawal1205 Жыл бұрын

Nice work thanks you so much, this is exactly what I want.

@HashAliNZ Жыл бұрын

Excellent, thanks!

@jenetau Жыл бұрын

HI, Firstly I want to thank you again. Your first QR code attendance video really helped us during covid and we are still using the same system. Wondering now if there is there a limit of the number of names (under question) you can put in a google form?

@HashAliNZ Жыл бұрын

Hi Jenetau, I just tested it out. I managed to get mine to 5000. It took a while to paste in all the data, but it got there eventually. I did it in three parts: The first 3000 took about 30 seconds to load. The next 1000 took about 15 seconds to load. Same for the last 1000.

@jenetau Жыл бұрын

@@HashAliNZ Thank you very very much

@kruonline9737 9 ай бұрын

Hello It's very good. Thank you.

@HashAliNZ 8 ай бұрын

Thanks! Here's a better way: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

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

@HashAliNZ Жыл бұрын

Hi! Sorry for not getting back to you sooner! I have a video that describes how to do this, but without the use of QR codes. Check it out here: kzfaq.info/get/bejne/Y7Jyd5OTvbSqmYU.html

@applecoresolutions 6 ай бұрын

Can I do one for arrangement in seating ?

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

@HashAliNZ Ай бұрын

Use the method in this video: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=K6MDFSFfl_8Y7MlA And overall, that new video is a better method. More secure.

@Flippss_ Ай бұрын

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

@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: kzfaq.info/get/bejne/oMeVkrl2nLCudKs.html Import that list into your Looker Studio and you're good to go!

@1rolfejo Жыл бұрын

@@HashAliNZ Thanks! Great info!

@adiahmic8534 9 ай бұрын

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?

@HashAliNZ 8 ай бұрын

How about a beep? New system here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@rainierdulay5475 11 ай бұрын

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 8 ай бұрын

Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@user-xc7ni4xb5d 6 ай бұрын

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

@user-vl8wc7tz4m 8 ай бұрын

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

@HashAliNZ 8 ай бұрын

Hey! This usually happens when you require someone to sign in or if you have more questions to answer. If you're requiring someone to sign in then just wait until tomorrow evening cos I have a video coming out with a video that has a much more secure way to do your QR attendance.

@SIOCONJetaime-cm6pg Жыл бұрын

Great video.!! May i ask for the scanner preferences/settings for it to automatically go to the google form without clicking it. Thanks!!

@HashAliNZ Жыл бұрын

Absolutely. First, make sure you are using BinaryEye. It is open source and it's the only one I have reliably found that does instant scanning. Once open, click the three dots in the top-right. Click preferences Go right down the bottom. The eighth option from the bottom is "Open Immediately". Turn that on. Scan away!

@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 7 ай бұрын

tutorial plss@@HashAliNZ

@patriciastewart2719 6 ай бұрын

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

@RolodexRex Жыл бұрын

Such a great Vid, H. : ) Thanks for the excellence and resource. -New Fan.

@HashAliNZ Жыл бұрын

You're very welcome!

@lindav4786 Жыл бұрын

I'm new to this And an old lady But excited to learn It may be just me But do you think you can slow down a bit And be a little more beginner friendly I really want to learn But am slower than others! Non-the-less Thank you for your teachings!

@HashAliNZ Жыл бұрын

Absolutely! All my future videos I will aim to walk through everything slower, and in each of my videos will be several levels for people of different skills levels. Thanks for the comment!

@ronaldkuykendall6163 Жыл бұрын

Great work, thanks for sharing

@HashAliNZ Жыл бұрын

Thanks for watching!

@allisondavis3588 11 ай бұрын

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 10 ай бұрын

This is also my question! Thanks so much

@bricehudson9541 9 ай бұрын

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

@HashAliNZ 8 ай бұрын

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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@HashAliNZ 8 ай бұрын

@@bricehudson9541 New system here with auto-submit here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@HashAliNZ 8 ай бұрын

@@heathergraham5380 Great question. New system here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@TheNeurophysiology Жыл бұрын

Thank you again. This was VERY HELPFUL. Again though for my question. Can we make sure that they are the ones who really signed for the attendance? Thanks

@HashAliNZ Жыл бұрын

No, not with this simple setup. I have a couple more attendance methods coming out over the next three weeks, so stay tuned for those. Not as high-tech, but definitely easier and more efficient than paper attendance

@jasonjenkins4925 Жыл бұрын

Thanks, this is just what I need, however my scanner only takes me to the form and not to the completed entry like when clicking on the links? Trying to work out where I’ve gone wrong. Any help appreciated. Keep up the amazing work.

@HashAliNZ Жыл бұрын

Hi Jason. There's been a change to the way camera apps work. It's just happened in the last week or so. Download the BinaryEye app and use that to scan. Once you've got BinaryEye, click the three dots in the top right corner, then hit preferences. Go right down the bottom. The option that's like 8th from the bottom is "Open immediately". Turn that on, then scan away.

@GoodBoy-vu6jg 10 ай бұрын

hi thx for the tutorial follow all your instruction got everything right my problem is when I scan QR code Error connection L version popup. anything I can do to fix that error? thx

@HashAliNZ 8 ай бұрын

I've never seen that before. Here's a better system to bypass the errors: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@seanxigmand6272 5 ай бұрын

Hello. Can you add geolocation track everytime they scan the qr code.

@HashAliNZ 5 ай бұрын

No, not using a free version. Geolocation requires dynamic QRs, whereas Google's platform only accommodates static QRs. You'd have to pay for a different platform/service if you want geolocation. If you want a more secure system, check out my latest version: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@hithamali8896 Жыл бұрын

It's really a good video thx alot dude, if u could upload the final Excell cheet u hc worked on at the video. That would be kind of you 🌹

@HashAliNZ Жыл бұрын

No problem. Check out the description! Thanks!

@heathroddy8631 3 ай бұрын

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 3 ай бұрын

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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.html

@syamakhalder4646 9 ай бұрын

hey sir wanted to say a great and helpful video . I had a question though , how can I send these qr codes individually to each participant if i have their email addresses . i know how to send emails in bulk by mail merging but I am not sure if I can send a QR code from excel tab through a mail . please help

@HashAliNZ 8 ай бұрын

Here's a revised system that allows you to send out the QR codes to all students to their email: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@cyrilleemmanuelaka3893 7 ай бұрын

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?

@bafa4984 2 ай бұрын

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 2 ай бұрын

Anyone can access the QR codes, which is a downside to this method. That's why I made this upgraded method: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@heathroddy8631 2 ай бұрын

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 2 ай бұрын

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 kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=Up609SXdF-7guh6E

@kimkerttigon1894 Жыл бұрын

Wow! Amazing!

@HashAliNZ Жыл бұрын

Thank you!

@elishawest5285 10 ай бұрын

@Hash Ali thank you for this wonderful tutorial. Here is my issue. The link works well it does what is supposed to do. However, the QR code only works with iPhones. Android sends a request to Samsung notes. How can I disable that so the Android users can simply scan and the attendance recorded?

@HashAliNZ 8 ай бұрын

How about creating your own app? It's easier than it sounds! Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@evamotto9276 Жыл бұрын

This is so cool!!

@HashAliNZ 8 ай бұрын

You haven't seen anything yet! Check this one out: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@allennadigitals 11 ай бұрын

Thanks, this is awesome. How do you ensure that one person doesn't scan for the other who did not attend.

@HashAliNZ 8 ай бұрын

By creating your own app. It's simpler than it sounds! Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@chauminh3507 6 ай бұрын

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

@HashAliNZ 6 ай бұрын

Don't use this system. Here's a different system that allows you to send out the QR codes in emails automatically: =kzfaq.info/get/bejne/fsepkpVnrdC0mHU.html&lc=Ugyh0X_0uTQrfnlOrlF4AaABAg.9zg9NV49Gxn9zgLztLPzCG

@user-wx4zd3sr6f 8 ай бұрын

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 8 ай бұрын

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

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

@johnkennjie2993 3 ай бұрын

Big help

@HashAliNZ 3 ай бұрын

Make sure you check out my updated video which is better, more secure, and simple to setup: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@naeemullahm Жыл бұрын

Wonder if it's possible to record two sheets columns, such as name & mobile number, into forms in an automated way? Can't Thank enough for great great videos..

@HashAliNZ Жыл бұрын

Sure, but if you already have the mobile number for each person then it's better to use a vlookup

@cjdbrink 6 ай бұрын

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 6 ай бұрын

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 themathlabnz@gmail.com, or you can set up a more secure version of the attendance system here using this tutorial: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=s1Wjsn79_dNUY1tl

@hariprasad-ss6wr Жыл бұрын

Hi First of all a big thanks for the video i just wanted to know can we add any validation as such the qr code should be scanned only in an particular one user

@HashAliNZ Жыл бұрын

Not with this method, sorry. You could turn on the option to require email sign-ins. However if you do this, the person scanning will need to click "Submit" and it won't automatically go to the submit page.

@aiworld470 10 ай бұрын

Question: is there a way to store the data locally? Without using the internet? Because in our place we have low or no bandwidth most of the time. Thank you so much.

@HashAliNZ 8 ай бұрын

Yep! This new system works without internet and reconnects when you get back in range: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@six_sixteen 6 ай бұрын

Hash Ali! What if the data that you need is more than one data in Gform? How do you set the gform link for it?

@HashAliNZ 6 ай бұрын

When you click the Link To Spreadsheet button, you have the option to link to a single spreadsheet instead of multiple. Or you could use the IMPORTRANGE function to collate all the collected data.

@NoOne-qd2yp Жыл бұрын

Wow! Thanks mate! In your Patreon, do you teach how to make QR CODE for Patrol Management? Like if I'm walking around buildings, each building will have a QR code, when I login to Google Forms, I can scan each of the QR from each building and it will be logged in Google Form that I was there?

@HashAliNZ Жыл бұрын

Hey No One, what id suggest is a qr code for each building that directs to a Google form with just a text field. Teacher inputs their unique code and submits it. Have all Forms attached to the same Google Sheet for easy reporting. This method prevents people from signing in other people and keeps students guessing as to what the teachers unique codes are

@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 😊

@gaganwadhwafreelancer 10 ай бұрын

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 8 ай бұрын

Absolutely. Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@lotaesmale4464 3 ай бұрын

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 3 ай бұрын

Hi! Unfortunately QR Codes have stopped working in Google Sheets this last week. Here's a different (and better in every way) method: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@nitinbolinjkar4583 4 ай бұрын

Very helpful video. Thank You! One question, can the QR code include the mobile number which syncs to the mobile number that scans the code? This will avoid proxy attendance.

@HashAliNZ 4 ай бұрын

Not using this basic system, no. Microsoft PowerApps can do it, though. I do have a better system on my channel where you can create your own app for it: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@nitinbolinjkar4583 4 ай бұрын

Thank You!😊

@user-ip5tr3ms6g Жыл бұрын

Just the video I needed. Can I also add an column that tells me if the person has logged in or logged out based on the condition when they scan the QR code, If its the first scan "login" value should be recorded in the column or if its the second scan "logout" value must be captured in the column???

@HashAliNZ 8 ай бұрын

How about creating your own app? Create this once, then duplicate it for the log out: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@ohseepinoy9505 6 ай бұрын

Thank you, Hash! I have been looking for a better way in creating qr codes for attendance for events and bumped into this after 1 week of looking around. However, I can't seem to move forward from 7:59. I did follow exactly how you did it and I was successful using Control+Shift+enter for the URL, but I can never do it successfully with the QR Codes. Frustrating thinking what I'm doing wrong. Got stuck.

@HashAliNZ 6 ай бұрын

Don't use this method. Use this one: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=GfBdFz-8lH3T7DGT

@ohseepinoy9505 6 ай бұрын

@@HashAliNZ got it working now! Thank you!!! Looking forward to learning more from your tutorials :)

@henryeffiom7610 7 ай бұрын

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 7 ай бұрын

Have you seen the features of the new method? Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.html&lc=Ugyy1Vt43_HEAIY3_iF4AaABAg

@pochhai2339 7 ай бұрын

awesome

@fatimaaisya4385 Жыл бұрын

Hi. This has been really helpful and I've scrolled down the comments section but I couldnt find if anyone shared the same problem. When I scan another student's code, it pops up: "Saved progress It looks as though there's a more recent draft of your response. Update to your latest draft to pick up where you left off." and there's only one button that says update

@HashAliNZ Жыл бұрын

Hi Fatima, 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.

@rimasdesigner9471 5 ай бұрын

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

@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 11 ай бұрын

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

@tsendayushdanzan4142 Жыл бұрын

That’s so helpful thank you. Can we use only one QR code for all people at one time event.?

@HashAliNZ Жыл бұрын

Absolutely. The downside to this is the lack of automatic sign in. I have a video in the works showing an amazing way to get it to work while also engaging your students!

@meddwlarea9013 7 ай бұрын

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

@HashAliNZ 7 ай бұрын

It's still there, but check out this new and improved version: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.html&lc=UgwDU6yGASJwARYnZdp4AaABAg

@cyL2801 2 ай бұрын

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 2 ай бұрын

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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@islamchihabeddinchebha8164 Ай бұрын

thaaaaaaaaaaank you

@Dormant96 Жыл бұрын

sir can i ask, can we use 2 columns instead of just 1 column for name and add another 1 column for category, so that after getting the response it will also appear with 2 columns when being reflected to excel, for example: we get the first column for time, second column for name, and the third column will be the category for example. thank you so much

@HashAliNZ 8 ай бұрын

Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@MarianaAsap 9 ай бұрын

is it possible to scan bulk of QR and post it all together into the excel? (instead of one by one ?)

@HashAliNZ 8 ай бұрын

Yep! Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@fr3d414 Жыл бұрын

Very informative! Thanks. Question: How can I go about if I don't want students to use their smartphones but keep a QR-CODE say, on a student card and scan on a my tablet? Will it work that way?

@HashAliNZ Жыл бұрын

Absolutely. Many people find this is the best way to do it. People have said they've create a student ID for them with the QR code and they scan when they get to school. Students don't often think of scanning their own student ID cards if they look official.

@Fight4Sanity 8 ай бұрын

Does it generate a new date specific QR code for each class date if there are multiple class dates?

@HashAliNZ 8 ай бұрын

No, the date is not taken into account. The date and time is automatically recorded by the Google Form. I have a new method coming out soon, so stay tuned!

@TheAQWScoorcher 10 ай бұрын

HI Hash! I was wondering, is there any way to automate a process where I can send the client their QR Code via SMS or E-mail automatically? For example, once Emily Smith submits a reply, it generates a barcode, that barcode is sent to Emily, Emily now scans in that QR Code to be checked off the list at Check-In. Let me know if that's possible or if it's a different process! Thank you!

@AnyaOf3 10 ай бұрын

I have a similar question. I need to put the QR codes on name badges. I've tried copy/paste and that doesn't work. Word copies only an empty box. If anyone knows how to copy the QR codes, I would appreciate it.

@HashAliNZ 8 ай бұрын

Absolutely. Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@HashAliNZ 8 ай бұрын

Like this: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@user-ln8eh3ue5k 5 ай бұрын

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?

@mohammadhijazi2367 2 ай бұрын

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

@HashAliNZ 2 ай бұрын

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

@EttienneWahl-kn9fy 8 ай бұрын

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 8 ай бұрын

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!

@rohansalwan1958 Жыл бұрын

@Hash Ali Great video, however is there a way we can have one single QR code to enable users log their attendance, I have a started a small MMA gym, so need the system to log the clients attendance

@HashAliNZ Жыл бұрын

Hi Rohan, One way to do this for free is to have the one QR code to scan as people enter which has a text field for them to add in their user ID

@GS-gv8km 3 ай бұрын

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 3 ай бұрын

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): kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@GS-gv8km 3 ай бұрын

@@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 3 ай бұрын

@@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!

@user-zy1bf9vx5o 5 ай бұрын

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?

@miaa416 Жыл бұрын

Hi. This is interesting and useful. I have a question. Can I use the same QR codes to record attendance on different days for the same students? For example, students attending a club meeting on different dates. Can I scan the codes for different dates and have all the dates in 1 sheet?

@HashAliNZ Жыл бұрын

Yes you can do that. It automatically records the date and time it's scanned. You'll just need to figure out what times relates to which club.

@miaa416 Жыл бұрын

@@HashAliNZ thank you. Will test this out. Very helpful.

@shawnprather 6 ай бұрын

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 6 ай бұрын

No, everyone gets a unique one. Check out my newest attendance video for a better, more secure system: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=6fC_FiytUy0fPP0H

@danielkpkk1005 10 ай бұрын

Can you do the same thing for Microsoft forms and Microsoft excel?

@HashAliNZ 8 ай бұрын

Yes, with PowerApps and SharePoint. I'm not well versed in it, though. Here's a different system that uses AppSheet: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@rllaneso Жыл бұрын

Thank you very much for your videos. They are very well explained and easy to follow. I am having an issue with this specific one... I followed all the directions and everything worked great, but not the scanning of the QR code... if I click on the created URL in the google spreadsheet, it does exactly what expected, the submission of the response in the form, but when scanning, it just opens the form as if I had not changed the viewform to formResponse... it opens the browser (chrome) and the form to submit... Any ideas? Thanks in advance!

@rllaneso Жыл бұрын

I dowonloaded a copy of the file that you share in this video and that file does work so I am confused now.. 🤔 I am going to redo it and see if it works... 😫

@SriNugrahaniRK-if3nq 11 ай бұрын

@@rllaneso well, last night I checked the QR code and it still worked, but in the morning my QR is just as you said, let me know if you have fixed it! Ill tell you if I'm done with mine

@HashAliNZ 8 ай бұрын

How about a system where we don't have to deal with those pesky formulas and URLs? Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@HashAliNZ 8 ай бұрын

@@SriNugrahaniRK-if3nq Here's a different (and better) system where you don't need to rely on difficult formulas: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@ralphmaalouf5601 6 ай бұрын

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

@HashAliNZ 6 ай бұрын

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

@user-cr6cf2fj3x 11 ай бұрын

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 8 ай бұрын

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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@abody44ever 9 ай бұрын

well explained now how I can download these qr code so i can merge it with a design for each person

@HashAliNZ 8 ай бұрын

Like this: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@janelleatteco5606 10 ай бұрын

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 8 ай бұрын

Oh no! I hope things worked out. If not, here's a better system! kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@user-mn7me6ob8n Жыл бұрын

Thank you for the great video! Is there any way to do this without the students having a google account?

@HashAliNZ 8 ай бұрын

Absolutely. Check it out here: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@matetcid998 Жыл бұрын

Hi! This is my second time using this process for attendance taking. Sir, can I use the same file for recurring meetings? same generated QR codes, form, and excel.

@HashAliNZ Жыл бұрын

Yes. Just make sure everyone that's attending is in your Google Form. However, this method doesn't use Excel it uses Google Sheets.

@matetcid998 Жыл бұрын

@@HashAliNZ You are so helpful and responsive, Sir. Thank you so much!

@user-uz4mc5yh9s 9 ай бұрын

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

@HashAliNZ 9 ай бұрын

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!

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

@lisathomen1914 Жыл бұрын

This is amazing. I am so excited doing the arrays haha. I am noticing when I try to compile the QR codes, it is opening as text and not in my browser to complete. Any suggestions? I am scanning with an android if that matters.

@yashh_2.0 Жыл бұрын

Same Issue, If you find a Solution. Please let me know

@HashAliNZ Жыл бұрын

I recommend using the BinaryEye scanner. It gives the option to open the QR code without having to click the URL link that pops up. Just head to the preferences and it's about 4th-ish from the bottom.

@HashAliNZ Жыл бұрын

@yashh_2.0 Жыл бұрын

@@HashAliNZ Thank you so much. Got Fixed. One more thing if you can help me with it will be great. How can we change QR Code On Daily Basics automatically? You suggested adding a date form, but I didn't get it clearly. so can you please let me know in detail

@justsamuel5593 11 ай бұрын

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

@HashAliNZ 8 ай бұрын

Fantastic! Let's see it come alive with this system instead: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@kumonmtedeneducationcentre9478 3 ай бұрын

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

@HashAliNZ 2 ай бұрын

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

@halimabdullah7878 11 ай бұрын

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 11 ай бұрын

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

@HashAliNZ 8 ай бұрын

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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@HashAliNZ 8 ай бұрын

@@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: kzfaq.info/get/bejne/fsepkpVnrdC0mHU.htmlsi=wTzUFBBzKsuy3dnA

@Variety8th 7 ай бұрын

if not binary scanner, u will need to submit manually

@NoisybeanS 8 ай бұрын

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

@HashAliNZ 8 ай бұрын

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

@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