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.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 ↓↓↓
Пікірлер: 469
Check out an updated, better (in every way), more advanced, simple set-up, more efficient and secure system here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@gerimiahmaribbay3460
Ай бұрын
googleapi doesnt work
@HashAliNZ
Ай бұрын
Correct. Description has had that in there for a couple months now with a solution 👍
It really appreciating to take time to study us, Very Big thank you, It really worked... Thanks Alot
@rimasdesigner9471
4 ай бұрын
Same thing can you make a restriction on this attendance, Ex: 1 person can attend 1 time only like that
Thank you very much! This is exactly what I’m looking for!
@HashAliNZ
9 ай бұрын
Great!
@HashAliNZ
7 ай бұрын
If you want an even better system, check this one out: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Thanks for the information
@HashAliNZ
7 ай бұрын
You're welcome! If you need something better, check this one out: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
thanks for video 😇
THANK yOU SO MUCH very helpful
@HashAliNZ
Жыл бұрын
You're welcome!
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!
Hello It's very good. Thank you.
@HashAliNZ
7 ай бұрын
Thanks! Here's a better way: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Nice work thanks you so much, this is exactly what I want.
@HashAliNZ
Жыл бұрын
Excellent, thanks!
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!
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
7 ай бұрын
@@sathya8094 Great questions. New system here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@HashAliNZ
7 ай бұрын
@@ivix5947I've got the system that's perfect for this: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Great work, thanks for sharing
@HashAliNZ
Жыл бұрын
Thanks for watching!
Big help
@HashAliNZ
2 ай бұрын
Make sure you check out my updated video which is better, more secure, and simple to setup: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Happy New Year mate. Keep it up
@HashAliNZ
Жыл бұрын
You too! I look forward to learning some top management techniques from you this year!
awesome
Wow! Amazing!
@HashAliNZ
11 ай бұрын
Thank you!
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
22 күн бұрын
Use the method in this video: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=K6MDFSFfl_8Y7MlA And overall, that new video is a better method. More secure.
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
This is so cool!!
@HashAliNZ
7 ай бұрын
You haven't seen anything yet! Check this one out: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
11 ай бұрын
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: kzread.info/dash/bejne/X4B2ppKbiLGsmbQ.html
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
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?
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!
Such a great Vid, H. : ) Thanks for the excellence and resource. -New Fan.
@HashAliNZ
11 ай бұрын
You're very welcome!
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!
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!
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
thaaaaaaaaaaank you
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: kzread.info/dash/bejne/nJWZwbh-Z62wdNo.html Import that list into your Looker Studio and you're good to go!
@1rolfejo
11 ай бұрын
@@HashAliNZ Thanks! Great info!
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.
Thanks, this is awesome. How do you ensure that one person doesn't scan for the other who did not attend.
@HashAliNZ
7 ай бұрын
By creating your own app. It's simpler than it sounds! Check it out here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
How about a beep? New system here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
6 ай бұрын
tutorial plss@@HashAliNZ
@patriciastewart2719
5 ай бұрын
@@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
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
3 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
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
7 ай бұрын
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.
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!
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
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.
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.
Can I do one for arrangement in seating ?
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 kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=Up609SXdF-7guh6E
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.
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
2 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.html
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.
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
7 ай бұрын
Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Thank you for the great video! Is there any way to do this without the students having a google account?
@HashAliNZ
7 ай бұрын
Absolutely. Check it out here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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 😊
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
Жыл бұрын
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.
@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
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
7 ай бұрын
How about creating your own app? Create this once, then duplicate it for the log out: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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?
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.
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?
@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
Very helpful, thank you! My question is how can we display the name of the person who just scanned the QR code on the form response itself? Currently it’s a simple thank you message. Can we edit it to say ‘Thank you for coming, John Doe’ for example? I really appreciate your genuine support.
@HashAliNZ
Жыл бұрын
Unfortunately, that's not possible in Google Forms.
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
7 ай бұрын
Yep! This new system works without internet and reconnects when you get back in range: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Hi HAsh, The QR Doesn't work if have multiple fields for eg. multiple entry, can you please help with that. Thanks
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
11 ай бұрын
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
10 ай бұрын
@@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
7 ай бұрын
How about a system where we don't have to deal with those pesky formulas and URLs? Check it out here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@HashAliNZ
7 ай бұрын
@@SriNugrahaniRK-if3nq Here's a different (and better) system where you don't need to rely on difficult formulas: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Is there a way to get a general QR code upon scanning links each individual to their QR code?
well explained now how I can download these qr code so i can merge it with a design for each person
@HashAliNZ
7 ай бұрын
Like this: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@nitinbolinjkar4583
4 ай бұрын
Thank You!😊
Hello. Can you add geolocation track everytime they scan the qr code.
@HashAliNZ
4 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
hey, Hash I did follow the instructions given but the QR codes did not appear can you help me with this?
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
10 ай бұрын
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
Hi Hash, Is it possible to add another two or more questions on google form, create a pre-filled link, and generate the same QR system as you did in this video?
@HashAliNZ
Жыл бұрын
Hi Fernando, It's possible but you'd need a new QR code for each different option. Let's say you have 5 people, three questions each. That's like 125 different QR codes. Not very manageable
@user-gf8ni6cv5i
Жыл бұрын
@@HashAliNZ Thank you and yes that would be too many to manage.
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.
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!
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
2 ай бұрын
Hi! Unfortunately QR Codes have stopped working in Google Sheets this last week. Here's a different (and better in every way) method: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
This was very helpful and I will use it! Thank you! My only question is I got everything to work but scanning the qr code. I was able to generate qr codes but using binary eye didn't say your response has been recorded. I tried my camera and it'll send me straight to the Google form and I have to click on their names to record it. Binary only gives me the option to copy qr code. I believe I'm missing a setting.
@HashAliNZ
Жыл бұрын
Hey Gamer! 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
@pft4lifegamer4
Жыл бұрын
@@HashAliNZ ok great thanks! I'll give it a shot. One last thing please so when I scan the qr code from my camera it sends it to the Google form and lets me select which student I want to put in. How do I get it to scan and automatically record the data like when you click on the link.
@HashAliNZ
Жыл бұрын
@@pft4lifegamer4 if you follow the section from 2:34 that'll get you the automatic selection when scanning
@pft4lifegamer4
Жыл бұрын
@@HashAliNZ ok ty and I really appreciate your help. I did that step properly, ok so what I'm realizing maybe. If I put the similar formula from the Google docs link and apply formresponse to the QR code part will that make the qr code scan and automatically record?
@HashAliNZ
Жыл бұрын
@@pft4lifegamer4 Yes, you'll also need to delete the part directly after the formResponse part of the URL. The bit that says usp=pp_url&
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
5 ай бұрын
Don't use this method. Use this one: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=GfBdFz-8lH3T7DGT
@ohseepinoy9505
5 ай бұрын
@@HashAliNZ got it working now! Thank you!!! Looking forward to learning more from your tutorials :)
Hi, Firstly I want to thank you. I have a question regarding access to register the attendance. As per the video anyone can scan the QR codes and the attendance will get registered. Can we restrict the access to register the attendance to just one google account?
@HashAliNZ
7 ай бұрын
Even better, send each student their QR code and have only one device scanning them in: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
I've never seen that before. Here's a better system to bypass the errors: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@HashAliNZ
7 ай бұрын
@@bricehudson9541 New system here with auto-submit here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@HashAliNZ
7 ай бұрын
@@heathergraham5380 Great question. New system here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Can you do the same thing for Microsoft forms and Microsoft excel?
@HashAliNZ
7 ай бұрын
Yes, with PowerApps and SharePoint. I'm not well versed in it, though. Here's a different system that uses AppSheet: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
@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
7 ай бұрын
How about creating your own app? It's easier than it sounds! Check it out here: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
Thank you. Is there any way that I can make QR code to collect my students' food eating numbers from the cafeteria?
@HashAliNZ
7 ай бұрын
Hmmm interesting. I'll work on that!
HI can you make an attendance sheet with QR codes without using google sheets. Could you use a bar code scanner on this. Also could add break times on this if the team gets 30 mins break?
@HashAliNZ
Жыл бұрын
Hi Kelvin. I don't have any experience with bar code scanners, so you'll need to Google your own model to see if yours can identify QRs. You can definitely make QR codes without Google Sheets. I use Sheets because it's insanely fast to populate a huge list of people. You can add automatic 30mins break time, but it's better to correctly record their time in and time out. Some people work through their break times and it wouldn't be fair to automatically deduct the 30 minutes without checking first. Another option you might want to look into is Jibble 2. I'm not affiliated with them, I just think they have a great system (and free for the first tier!): www.jibble.io/
@kelvinawang9503
Жыл бұрын
@TheMathLab NZ thank you so much your videos have helped me so much
@megankilmartin9108
11 ай бұрын
Did you ever find a solution to the bar code scanner question? I was having the same thought
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
Hi, can i know if the QR code is for an individual names or one QR for the whole thing ?
@HashAliNZ
Жыл бұрын
Hi Afiq, The method shown in the video is for one QR code per person. If you want one QR code for everyone, think about using Beaconstac for your solution: bit.ly/beaconstac2023
@HashAliNZ The fundamental question for my organisation is: "Is it a dynamic or a static qr" that we are creating here? Would be very happy for an answer.
@HashAliNZ
9 ай бұрын
Static
@DEuropeanView
9 ай бұрын
@@HashAliNZ thx!
Great Video i see the check in timestamp but is there a way to also get a checkout timestamp using the same QR code ?
@HashAliNZ
11 ай бұрын
Not reliably or easily. I'm working on a video now that should come out in a couple of weeks that doesn't use QR codes but has a check-in and check-out system.
@djnewyork1844
11 ай бұрын
@@HashAliNZ ok great I will support your work thank you 👍🏽
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
Wondeful tutorial. However, friends could scan the QR code for them. I followed the same procedure you uploaded in 2020. so is there any solution for this. Thank you
@HashAliNZ
Жыл бұрын
Unfortunately there is no solution using Google Forms. This is a high trust model
Same thing can you make a restriction on this attendance, Ex: 1 person can attend 1 time only like that
This just gave birth to a business idea i had for years.
@HashAliNZ
7 ай бұрын
Fantastic! Let's see it come alive with this system instead: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
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
7 ай бұрын
Thanks for the question. That would be based on the se
This is excellent but I have a question. Is there any way to have one QR instead of multiple QR code for each individual
@a9eelalghamdi288
Жыл бұрын
Hello im having the same issue if you found a solution i hope you can help me
@HashAliNZ
Жыл бұрын
Hi both of you! You could have just the one QR code, then turn on the "Record email" option in the Google Form, and instead of having the radio buttons with all the names, just have a name or ID field for the individuals to put in their own name/ID Number. The downside to this is that it won't automatically go straight to the "Form Response" screen and will only go to the "View Form" screen they will need to click on the Submit button. I have a few other Attendance videos coming out over the next four weeks, so stay tuned and I'll give you more options for taking attendance!
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.
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=UgwDU6yGASJwARYnZdp4AaABAg
Is there a way to email or text each QR code to the appropriate individual?
@HashAliNZ
8 ай бұрын
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!
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
7 ай бұрын
Here's a revised system that allows you to send out the QR codes to all students to their email: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=wTzUFBBzKsuy3dnA
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
7 ай бұрын
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!
How about with Time out sir? thanks.
@HashAliNZ
Ай бұрын
Just make another copy of this and call it 'time out' instead of 'sign in'.
how can i download the QR code as a jpq. or any image type of file? Thank you for your guidance
@HashAliNZ
5 ай бұрын
Don't use this system. Here's a different system that allows you to send out the QR codes in emails automatically: =kzread.info/dash/bejne/epWtwZRveM22mKQ.html&lc=Ugyh0X_0uTQrfnlOrlF4AaABAg.9zg9NV49Gxn9zgLztLPzCG
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
5 ай бұрын
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: kzread.info/dash/bejne/epWtwZRveM22mKQ.htmlsi=s1Wjsn79_dNUY1tl