How to Create a QR Code Attendance System in 2023 for Teachers
Вставка
- Опубліковано 31 гру 2022
- **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 ↓↓↓ - Навчання та стиль
Check out an updated, better (in every way), more advanced, simple set-up, more efficient and secure system here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
googleapi doesnt work
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
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!
Great!
If you want an even better system, check this one out: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Thanks for the information
You're welcome! If you need something better, check this one out: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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?
thanks for video
😇
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
I had no plans for that, but I'll give it some research. Thanks for the comment!
Happy New Year mate. Keep it up
You too! I look forward to learning some top management techniques from you this year!
Hello It's very good. Thank you.
Thanks! Here's a better way: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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?
THANK yOU SO MUCH very helpful
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
You could add filters. It is a little bit of work, but it can be done!
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?
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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.
Use the method in this video: ua-cam.com/video/Hay_26HjPhA/v-deo.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?
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
Hi HAsh, The QR Doesn't work if have multiple fields for eg. multiple entry, can you please help with that. Thanks
Nice work thanks you so much, this is exactly what I want.
Excellent, thanks!
Great work, thanks for sharing
Thanks for watching!
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
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.
This is so cool!!
You haven't seen anything yet! Check this one out: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Can I do one for arrangement in seating ?
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?
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.
@@HashAliNZ Thank you very very much
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?
How about a beep? New system here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Wow! Amazing!
Thank you!
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 :)
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.
tutorial plss@@HashAliNZ
@@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
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?
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: ua-cam.com/video/Hay_26HjPhA/v-deo.html
hey, Hash I did follow the instructions given but the QR codes did not appear can you help me with this?
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.
Thanks! Here's exactly what you need: ua-cam.com/video/jae_VE7JJDw/v-deo.html
Import that list into your Looker Studio and you're good to go!
@@HashAliNZ Thanks! Great info!
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?
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: ua-cam.com/video/-LBD0bXNFiQ/v-deo.html
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.
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
ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=Up609SXdF-7guh6E
Such a great Vid, H. : ) Thanks for the excellence and resource. -New Fan.
You're very welcome!
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!
This is also my question! Thanks so much
Yes. It only goes to my form. Doesn't automatically submit.
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
@@bricehudson9541 New system here with auto-submit here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
@@heathergraham5380 Great question. New system here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Thanks, this is awesome. How do you ensure that one person doesn't scan for the other who did not attend.
By creating your own app. It's simpler than it sounds! Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Great video.!! May i ask for the scanner preferences/settings for it to automatically go to the google form without clicking it. Thanks!!
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!
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!
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!
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.
Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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.
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.
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
you need to disable the response hehehe
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
@@HashAliNZ how to make a dynamically changing QR code each day?
@@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
@@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 😊
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?
Hello. Can you add geolocation track everytime they scan the qr code.
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: ua-cam.com/video/Hay_26HjPhA/v-deo.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?
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
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
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
Is there a way to get a general QR code upon scanning links each individual to their QR code?
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.
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Thank You!😊
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?
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.
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 🌹
No problem. Check out the description! Thanks!
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..
Sure, but if you already have the mobile number for each person then it's better to use a vlookup
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.
Thanks for the question. That would be based on the se
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.
Yep! This new system works without internet and reconnects when you get back in range: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Big help
Make sure you check out my updated video which is better, more secure, and simple to setup: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Same thing can you make a restriction on this attendance, Ex: 1 person can attend 1 time only like that
awesome
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.
Don't use this method. Use this one: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=GfBdFz-8lH3T7DGT
@@HashAliNZ got it working now! Thank you!!! Looking forward to learning more from your tutorials :)
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
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.
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
That’s so helpful thank you. Can we use only one QR code for all people at one time event.?
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!
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.
Hi! Unfortunately QR Codes have stopped working in Google Sheets this last week. Here's a different (and better in every way) method: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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
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.
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!
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... 😫
@@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
How about a system where we don't have to deal with those pesky formulas and URLs? Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
@@SriNugrahaniRK-if3nq Here's a different (and better) system where you don't need to rely on difficult formulas: ua-cam.com/video/Hay_26HjPhA/v-deo.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
I've never seen that before. Here's a better system to bypass the errors: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
thaaaaaaaaaaank you
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?
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!
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=s1Wjsn79_dNUY1tl
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
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.
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???
How about creating your own app? Create this once, then duplicate it for the log out: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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?
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.
This just gave birth to a business idea i had for years.
Fantastic! Let's see it come alive with this system instead: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Thank you for the great video!
Is there any way to do this without the students having a google account?
Absolutely. Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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
Here's a revised system that allows you to send out the QR codes to all students to their email: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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
Anyone can access the QR codes, which is a downside to this method. That's why I made this upgraded method: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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.
Same Issue, If you find a Solution. Please let me know
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.
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 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
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?
@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?
How about creating your own app? It's easier than it sounds! Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
I can't reach the url you used (you say in description but couldn't find it)
It's still there, but check out this new and improved version: ua-cam.com/video/Hay_26HjPhA/v-deo.html&lc=UgwDU6yGASJwARYnZdp4AaABAg
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.
Yes. Just make sure everyone that's attending is in your Google Form. However, this method doesn't use Excel it uses Google Sheets.
@@HashAliNZ You are so helpful and responsive, Sir. Thank you so much!
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?
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.
@@HashAliNZ thank you. Will test this out. Very helpful.
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?
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.
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!!
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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?
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
@@HashAliNZ Thank you and yes that would be too many to manage.
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?
Have you seen the features of the new method? Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.html&lc=Ugyy1Vt43_HEAIY3_iF4AaABAg
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?
I'm currently facing the same issue, still looking for help tho
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
@@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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
if not binary scanner, u will need to submit manually
well explained now how I can download these qr code so i can merge it with a design for each person
Like this: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Thank you. Is there any way that I can make QR code to collect my students' food eating numbers from the cafeteria?
Hmmm interesting. I'll work on that!
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.
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
@@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.
@@pft4lifegamer4 if you follow the section from 2:34 that'll get you the automatic selection when scanning
@@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?
@@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&
how can i download the QR code as a jpq. or any image type of file? Thank you for your guidance
Don't use this system. Here's a different system that allows you to send out the QR codes in emails automatically:
=ua-cam.com/video/Hay_26HjPhA/v-deo.html&lc=Ugyh0X_0uTQrfnlOrlF4AaABAg.9zg9NV49Gxn9zgLztLPzCG
@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
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
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
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): ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
@@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!
@@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!
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 !
No, everyone gets a unique one. Check out my newest attendance video for a better, more secure system: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=6fC_FiytUy0fPP0H
Can you do the same thing for Microsoft forms and Microsoft excel?
Yes, with PowerApps and SharePoint. I'm not well versed in it, though. Here's a different system that uses AppSheet: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
is it possible to scan bulk of QR and post it all together into the excel? (instead of one by one ?)
Yep! Check it out here: ua-cam.com/video/Hay_26HjPhA/v-deo.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.
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
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?
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 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.
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: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
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?
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/
@TheMathLab NZ thank you so much your videos have helped me so much
Did you ever find a solution to the bar code scanner question? I was having the same thought
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
Don't do it in the Google Form, do it in the spreadsheet with a lookup table. See how here: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Does it generate a new date specific QR code for each class date if there are multiple class dates?
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!
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?
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!
Can you add sms alert for parents so they know if their child reaches or leaves the class?
Not using this method, but you could using Google App Sheet
Is there a way to email or text each QR code to the appropriate individual?
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!
@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.
Static
@@HashAliNZ thx!
Amazing! However I have some questions. I am hosting an event. I already created a form that is going to be sent to the guests. But I want that when the fill it they receive a confirmationwith a QR that I can scan when they arrive in the day of the event. How can I do this? Please help
this is what I need also
Absolutely! Check this out: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA
Perfect! I made something just for this: ua-cam.com/video/Hay_26HjPhA/v-deo.htmlsi=wTzUFBBzKsuy3dnA