How To Create QR Attendance for Teachers in 2020 !! (Google Sheets and Google Forms)
Рет қаралды 666,096
Күн бұрынI've updated this video! Check it out here: • How to Create a QR Cod...
The digital age calls for contactless solutions, and QR codes are a fantastic answer. In this video, we're back with an updated, secure method for creating QR codes for attendance in 2020, leveraging the power of BeaconStac. Whether for school, work, or events, this system offers a more secure and user-friendly approach to attendance tracking. Dive in and learn how to modernize your attendance system with increased security.
If you want to see the completed Google Sheet from this video click here
► docs.google.com/spreadsheets/...
----------------------------------------------------------------------------------------------------------------
📼CHECK OUT THE OTHER VIDEOS IN THIS SERIES
----------------------------------------------------------------------------------------------------------------
📼Struggling to determine why your QR codes aren't working? Try this: • Your QR Attendance Qs ...
📼Need to get some management process once things have been scanned? See here: • How to filter your QR ...
📼Prefer a Microsoft product, or want to prevent people from scanning the wrong person? Give this a shot: • How to Create QR Atten...
📼Check out the rest of the QR series! • QR Attendance
----------------------------------------------------------------------------------------------------
💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓
@ahmadrisesatriawicaksono4191 3 жыл бұрын
Wow, It's an amazing system Man. Your explanation is so detail. Thanks a lot for the tutorial.
@HashAliNZ 3 жыл бұрын
Hope it helps. Thanks!
@krollb 2 жыл бұрын
This is fabulous! So well conceived, so clearly explained, so on point for a specific need for the times we are in. I just implemented your technique to print ID cards with QR codes for 800+ students after testing. Flawless. We already were using google forms on a shared Chromebook to take attendance prior to COVID, and were 100% remote last year using the same form, but this year we needed a touchless alternative on site which could also be self-serve for remote students. This was perfect. Thank you so very much on behalf of our staff and students. Bravo.
@HashAliNZ 2 жыл бұрын
Thank you so much for spending the time to write such a supportive message. I really appreciate it, Bud. Good luck with your new approach!
@fayyurockz2267 Жыл бұрын
Sir please explain me..how it can be done
@ramonvictorviray2546 3 жыл бұрын
The instructions are so clear and easy to understand. You helped me a lot, sir. Thank you so much!
@HashAliNZ 3 жыл бұрын
Glad it helped!
@eileenlai6308 2 жыл бұрын
Great video! So easy to follow and so clearly explained. Thank you for sharing!
@Jasmine-lz5yf 3 жыл бұрын
Extremely clear in explanation, very detailed & helpful! Thank you so much
@HashAliNZ 3 жыл бұрын
Thanks!
@PaulsEnglishFukuoka 3 жыл бұрын
Very clear instruction and a perfect result. Impressed. Following avidly from this point.
@HashAliNZ 3 жыл бұрын
Great to hear!
@Tac2forever Жыл бұрын
This is exactly what I needed! I am using this to track my students office visits. My assistant can scan the code of the student coming to the office and we have instant timestamped documentation!
@RAHULKUMAR-xj4hp 3 жыл бұрын
Learnt a lot of things in very less time 👍 Please make more and more videos like this .
@HashAliNZ 3 жыл бұрын
Thank you, I will
@allisonbarker8082 3 жыл бұрын
Thank you!!! You just saved me so much time this evening. I wanted to create something like this for contract tracing with seats, followed the instructions, and they look perfect. Thank you again!
@HashAliNZ 3 жыл бұрын
Glad it helped!
@lauraperry6042 3 жыл бұрын
@@HashAliNZ this is a great help. I too want to use this method for contract tracing. Except I plan to assign qr codes on seats and have students scan the seat when they sit down. I can't get the form prefill option to appear if I opt to collect email addresses? Any ideas there? We want to track what student sits in what seat (date, time, etc).
@sudarshanms7822 3 жыл бұрын
@TheMathLab NZ Thanks ! Please tell us how to resolve it.
@christinejelbert4676 2 жыл бұрын
Thanks for this! It's absolutely brilliant and elegantly done. Can't wait to see how easy attendance is going to be:-)
@HashAliNZ 2 жыл бұрын
Can't wait!
@TheJcperla 2 жыл бұрын
Good for first day until kids start scanning each other’s codes. Cool concept though. Better if they have the code and teacher scans.
@HashAliNZ 2 жыл бұрын
@@TheJcperla Yeah, that's the way a lot of people have implemented it. But there's downsides to that too - for example students scanning the code at home. Check out this video for a more secure version: kzfaq.info/get/bejne/o8d5lNWezdrKk40.html
@TheJcperla 2 жыл бұрын
@@HashAliNZ that is an awesome solution. Could the Google form be set up so only certain people could access it? This would prevent students from scanning?
@YonadavTapuchi 3 жыл бұрын
This is perfect! Exactly what I thought of making, but hadn't a clue where to begin... Thank you sooo much :)
@HashAliNZ 3 жыл бұрын
You're very welcome!
@mariaeddieferomero4368 2 жыл бұрын
Thank you so much, please do continue making contents like this. I was able to create one for my class because of your concise explanation in this video. 👏👏👏 Have a great day ahead!
@HashAliNZ 2 жыл бұрын
Will do!
@ronniehayes4199 3 жыл бұрын
You make it look so easy!!! Thank you for a great tutorial. Now I know what I will be trying for the next 24 hours!!
@HashAliNZ 3 жыл бұрын
Good luck!
@purpleheart8491 3 жыл бұрын
@@HashAliNZ hi can ask how to make qr code for organization thank you in advanced i will wait for your reply
@HashAliNZ 3 жыл бұрын
@@purpleheart8491 Just follow the same steps as in the video, but the URL will be the URL for your organization
@kevinadriansyah8513 3 жыл бұрын
Yoooo, it was a nice system. i will come back later if theres more update.. thanks a lot more sharing
@HashAliNZ 3 жыл бұрын
No problem 👍
@marcblanco5472 Жыл бұрын
I used your "old" method for the 20th anniversary event of our highschool. It was quick and reliable. I see now that you have a better version of it. Can't wait to see how it works. Thanks a lot!
@HashAliNZ Жыл бұрын
Excellent! It's got updated formulas to take into account a bunch of different text types and even different alphabets!
@user-vi1kb4in1u 2 жыл бұрын
i havent seen someone this thorough in google sheets & forms. Appreicated!
@HashAliNZ 2 жыл бұрын
No problem!
@GloryApologetics 2 жыл бұрын
Superb video! I followed all the steps but the QR Image wont show-Up. Any solution. The space looks blank where the QR image is supposed to appear. Appreciate your efforts.
@franciscofretziec8251 2 жыл бұрын
Same problem with mine appears to be blank
@HashAliNZ 2 жыл бұрын
Heya, Check if there's any spaces in the names. If there are, get rid of them.
@HashAliNZ 2 жыл бұрын
Heya, Check if there's any spaces in the names. If there are, get rid of them.
@minirollsrule 2 жыл бұрын
Also having the same problems. Checked and there are no spaces in URL
@HashAliNZ 2 жыл бұрын
@@minirollsrule Feel free to share with me and I can take a look: themathlabnz@gmail.com
@JaxHO 3 жыл бұрын
Thanks. It's amazing! However, is there any way to restrict students to scan multiple times such as some students will scan the QR for their friends? And what if they scanned wrong? Just delete it in Google Sheet Response Form?
@HashAliNZ 3 жыл бұрын
Hi Jax, Yes you can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit. Some people may scan for their friends. You do need to teach the students this is a trust-based model. If scanned wrong, you can delete from either the Responses Sheet or from the Google Form itself.
@christopherlawes9286 2 жыл бұрын
Alternatively, you could give the students printed qr codes and get them to scan a webcam to register attendance. That way it doesn’t rely on them having internet/data and you can watch them so they don’t scan multiple cards.
@Digital.Done.Right. 2 жыл бұрын
this is such a great video! I did not know of the Google API we can use for this. I have been wanting a static code to print on my business cards and on stickers but didn't want to pay for it. Now with your tips and explanation I can code a QR code. Thanks for making this even if it was for a different audience.
@HashAliNZ 2 жыл бұрын
Glad it was helpful!
@nischalsubedi4213 2 жыл бұрын
Awesome Man, never knew you could do such things with Google Sheets and Forms! Thanks for the knowledge my man!!
@HashAliNZ 2 жыл бұрын
Happy to help!
@danaviv 3 жыл бұрын
Well explained! Quick Q: Where does the student access the QR code? Do you share the Google Sheet with the class and they scan in each time with the same QR code?
@HashAliNZ 3 жыл бұрын
Hi Dan, Yes it's the same QR code each time, but each person gets their own QR code. At the end of this video I have a quick clip showing how I did it for my students.
@moriahdamian4542 3 жыл бұрын
Can you create a video dedicated to shortkeys for Google Docs, Sheets, etc.?
@HashAliNZ 3 жыл бұрын
Interesting idea!
@bryanchristiansalvador826 2 жыл бұрын
Dude you are a genius! You deserve more subs than what you currently have. Keep it up.
@HashAliNZ 2 жыл бұрын
Appreciate that!
@evineiteljorge8920 2 жыл бұрын
Really awesome video. Thank you for teaching me how to create bulk QR codes without going through a sketchy site!
@HashAliNZ Жыл бұрын
Thanks! There are some good sites out there, it's just tolling to research which ones are good
@angelaquia1394 3 жыл бұрын
this channel is underrated
@HashAliNZ 3 жыл бұрын
Thanks!
@aumarivero 3 жыл бұрын
agree
@3101199 3 жыл бұрын
Great! Is it possible to add the location where de scanned was made? To know where the person is in the Moment of the scan
@HashAliNZ 3 жыл бұрын
You have a few options. Option 1: Make a new QR code for each student for each location. Option 2: One QR code but then have another question which is manually filled out before clicking Submit
@shadyworld1 3 жыл бұрын
Option 3: Add 1 random Quiz Question only teacher got there answers. Each get the one word/code answer for there question from the teacher as they attendance approve physically! Whoever scanned and didn't answer the quiz is a skipper tried to cheat attendance. Basically it's the basic 2 Key Auth. Semi manual, based on military standards. No fancy gps required or biometrics! Always simplist methods works the best... By the way... Special Tip! You could make questions of Auth. IQ or Equations like SAT hardest Questions that would challenge them if they answered it they may have late entry for the effort once a month!
@lazarereznik4854 3 жыл бұрын
Thank you so much TheMathLab NZ! I really like your presentation and the clear explonations you provide. Well done sir. Sure it'b be great to limit the ability to flash to one single account, to prevent anybody to flash their code when they please. Yet it's a usefull method you gave the world ;-) Cheers!
@HashAliNZ 3 жыл бұрын
Thanks, Lazare! Yeah, it would be good to do that. There are ways to create apps specifically for that, but that's beyond my capability!
@lazarereznik4854 3 жыл бұрын
@@HashAliNZ Yours seem fine enough to me ;-) The check out would be nice too. Thanks again, hope to read more exiting tricks from you soon.
@IrfanKamil 2 жыл бұрын
brilliant idea and love the simplicity on it, cool bro, thanks for sharing these!
@HashAliNZ 2 жыл бұрын
No problem 👍
@tajuddina2455 3 жыл бұрын
Thank you. A clear as glass explanation! Subscribed! Though I am not a teacher, never the less appreciated this work very much. We were able to create the attendance sheet as per video first time correct (including the part of printing, laminating and producing the QRCodes!). I wonder if you could help someones in further need and expand the functionality of this sheet. I noticed on the last segment of your video...Create A New Spreadsheet - it is able to detail the timestamp of who attended, and at what date and the time. Could you create a formula that is able to pull the data and identify who was a little late (ie 15mins) or very late (ie 30mins) or didnt make it (not checked-in) at all for class or work (ie >60mins) ? And send out and email reminder(s) to the student/worker and/or Supervisors? Thanks. Tajuddin
@HashAliNZ 3 жыл бұрын
Absolutely. I have an old video somewhere that goes through latenesses. I'll see if I can find it
@HashAliNZ 3 жыл бұрын
Here you go! kzfaq.info/get/bejne/pb-HZLeKztidnoU.html It's an older video so the quality is not so great, but it has the basic details. Let me know if you get stuck
@tajuddina2455 3 жыл бұрын
Thank you. Will look into this
@timteacher 2 жыл бұрын
Excellent video. I'm surprised you don't have more followers. You explain everything in a concise and logical way. I've followed your video and adapted it slightly. My students here in Seoul have both English and Korean characters in their 'name' field. This morning I tested QR attendance with the students and everything worked, except that only 3 (out of 10 or so) responses had names attached to them. The timestamps showed all of the students were able to submit their attendance using QR codes though. Is there anyway that Korean characters could be screwing something up, or is there another issue that I'm not aware of? I'd be happy to share the spreadsheet with you or anyone else who is willing to take a look. From one Kiwi to another.
@HashAliNZ 2 жыл бұрын
I've never tried with Korean characters. My email is themathlabnz@gmail.com if you wanna send it to me
@tristanparsadh8601 Жыл бұрын
Subbed already 6min in and im learning more than my entire high school
@HashAliNZ Жыл бұрын
Thanks for the sub, but no need to put down your high school - there's no reason for them to teach this stuff. If you wanna go more in depth, I've updated this video with better and more efficient formulas: kzfaq.info/get/bejne/lZxdjad4s9rHgps.html
@AlexanderMcGruder 2 жыл бұрын
My boss gave me a task and was expecting me to spend $4000 to solve it. Your video was the answer. So well put together. Explained so perfectly. I think I love you
@HashAliNZ Жыл бұрын
Keep sharing that love, Alex!
@mohanjayaraman9018 3 жыл бұрын
Thanks, Very useful and time saving. What if any student scanned some other students QR by mistake or How can we stop proxy attendance?
@sapkotadiwash 3 жыл бұрын
Yeah, that's the challenge here. Otherwise it's just cool
@faruqr8127 3 жыл бұрын
Can try requires log in. That way can cross reference
@raigledsosmith 3 жыл бұрын
Exactly !!! that's what I thought when he 4 times scanned the QR code from his single phone itself. By this way 1 student can apply fake attendance for their classmates. How do we counter this hiccup???
@HashAliNZ 3 жыл бұрын
You can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit. Some people may scan for their friends. You do need to teach the students this is a trust-based model.
@ValpasKankaristo 3 жыл бұрын
You could also try giving/sending each student only their own codes. Requires a bit more effort and still isn't fool-proof, but it might discourage scanning others' codes!
@BeLikMike23 3 жыл бұрын
This is an outstandingly well thought out and detailed tutorial. I followed everything exactly and was able to generate a full attendance tracker for my students. I am having an issue though where some scans are coming in without the students' names, and therefore they are being marked as absent. I'm not sure why this would be happening, and it isn't always the same students that are coming in scanned without names. I verified that the names match the Google Form perfectly (I copied them and pasted so everything matches), and if I personally scan each QR code myself, it comes in with the names as expected. I just can't seem to figure out what to do to solve the blank name problem. Any help would be greatly appreciated. Thanks so much for putting this video out. I'd have been lost without it.
@HashAliNZ 3 жыл бұрын
Thanks for the kind words. Just so I'm on the right track: - Student A signed in but it scanned without a name attached - On a different day, Student A was able to scan no problems but Student B signed in with a similar issue - The names on the Google Form match exactly the names on the Google Sheet and you have tested each one The next step would be making sure the URLs are correct. Find a student whose name did not scan but their scan did register. Go to that student's URL that's next to their QR code in the Google Sheet. Read the URL to make sure it's correct and then click on it to make sure it registers properly.
@BeLikMike23 3 жыл бұрын
@@HashAliNZ Thanks so much for the reply. That's correct. I just checked what you suggested and it registered as expected when clicking their link, also I can personally scan these students' QR codes using my own phone and it will register perfectly fine when I do it, so based on that I can't seem to understand what the issue could be.
@HashAliNZ 3 жыл бұрын
@@BeLikMike23 That's a new issue for me. I haven't come across that one before. It's possible the QR scanner being used has a problem. I recommend using BinaryEye for the scanner
@BeLikMike23 3 жыл бұрын
@@HashAliNZ I appreciate the recommendation. I'll suggest it to the students and hope it solves the issue. Thanks so much for your replies and for your superb video.
@khalidkhadim1854 Жыл бұрын
the video was super great and strait-forward. well done
@HashAliNZ Жыл бұрын
Thanks for all the continued views and comments. I've updated this method, so check out this video that has better and more efficient formulas: kzfaq.info/get/bejne/lZxdjad4s9rHgps.html
@rajibthaosen2591 Жыл бұрын
How to add those alignment patterns on QR
@HashAliNZ Жыл бұрын
@@rajibthaosen2591 Alignment patterns?
@hobbytime1502 2 жыл бұрын
Awesome tutorial keep it up bro. That goes a long way. Thank you very much.
@HashAliNZ 2 жыл бұрын
Thanks!
@patriciashawwatkins2901 Жыл бұрын
Thank you. Remarkable! I enjoyed following along. It worked on the first try.👍
@HashAliNZ Жыл бұрын
Thanks Patricia!
@JoshuaDometita Жыл бұрын
How can automatic generate the duration, example if the student time in and out? how can calculate it? manually? or there is another option?
@mariopidlaoan4175 3 жыл бұрын
Thank you sir. BIG HELP. God bless you .
@HashAliNZ 3 жыл бұрын
Glad it helped
@khalidQureshi 2 жыл бұрын
Excellent and amazing.....simple and robust. Thank you.
@HashAliNZ 2 жыл бұрын
You are welcome!
@jonchalk3855 2 жыл бұрын
Just used the "join" formula on MS excel. Works exactly the same. Thank you.
@HashAliNZ 2 жыл бұрын
You got QR codes in Excel?
@Lizellers 2 жыл бұрын
I enjoy how the "student names" are characters from the Rugrats show. Awesome!
@vishalparkar 3 жыл бұрын
Insanely great yet simple.
@HashAliNZ 3 жыл бұрын
Thanks!
@aitorgallastegui5200 2 жыл бұрын
Thanks for sharing!!! I apologize for the simplicity of my question but when putting this into use in class, does the professor use their own phone to read the student's QR codes or doe sit work differently? Thanks!
@nicolegeorge8975 Жыл бұрын
Hello how would I implement this with different classrooms and the same students? Like if a student goes to a different class, but attendance needs to be put for that new class on the same day.
@filmtokstudio9099 Жыл бұрын
Pls any tips on doing 3-5 Multiple choices with radio buttons, checkboxes. Every time I create it, and click submit form I created it only allow first two option to go through, but 3rd, 4th, 5th and so on option just wont go through for both multiple choices and checkboxes. In affition if you have any tips on file upload would be amazing!!!
@heartyeaterkh 2 жыл бұрын
Thanks a lot, man. I'm really appreciated it.
@varyktv Жыл бұрын
Is this translatable through new classes? For instance can you just edit the form and change a name or add/remove a name and it’ll auto update to the sheet and make a new QR code?
@cybersam6567 Жыл бұрын
That was well done. Thank you.
@HashAliNZ Жыл бұрын
Thanks Sam!
@ndunyumarketplace Жыл бұрын
This is honestly the best tutorial
@HashAliNZ Жыл бұрын
Thanks!
@NathanHopson 3 жыл бұрын
Fantastic work!
@HashAliNZ 3 жыл бұрын
Thank you! Cheers!
@dear5597 Жыл бұрын
Thank you so much, you made my day
@gabrielobidi1083 2 жыл бұрын
Thanks for sharing this knowledge. You're a hero.
@HashAliNZ 2 жыл бұрын
I appreciate that!
@influencetechnology2017 Жыл бұрын
Just amazing sir 💪
@Ejigalem 2 жыл бұрын
Many many thanks 🙏 you’re very kind!
@HashAliNZ 2 жыл бұрын
You are very welcome
@muniranzakuto2912 3 жыл бұрын
You explained that very well. I thank you for that.
@HashAliNZ 3 жыл бұрын
I'm glad it helped
@juviegonzalesgalutan73 2 жыл бұрын
Wow im gonna do that to our staff since we have a new company thank you🙏🏻🙏🏻🙏🏻🙏🏻 more power
@HashAliNZ 2 жыл бұрын
Brilliant! Make sure you check out this video for a different method: kzfaq.info/get/bejne/o8d5lNWezdrKk40.html
@ianbone4781 2 жыл бұрын
think you for the new updated video and files its a it grate what you do thank you
@HashAliNZ 2 жыл бұрын
You are very welcome
@herbertpalines4695 2 жыл бұрын
Thanks for sharing this!
@HashAliNZ 2 жыл бұрын
Glad you enjoyed it!
@alyacim654321 2 жыл бұрын
very big help sir.. thank you so much!!
@HashAliNZ 2 жыл бұрын
Glad it helped
@CubbyBaumann 3 жыл бұрын
Thank you for your help! This was so informative. My predicament is as follows, I would like to assign and provide participants in my program 1 QR code. I would like to scan the QR code for their attendance as you explained in your video but I would also like the option to somehow scan their code to keep track of their meal pick ups as well as for a linen exchange system. I would like to use separate google forms for the meal and linens. How would I go about expanding the access to the multiple forms with one QR? thank you for any and all advice.
@HashAliNZ 3 жыл бұрын
You'll need two QR codes per person. One will be for meal picks, the other for linen exchange. If you really need just one QR code, then you'll have the person scan then select either meal pick up or linen exchange then submit.
@harutanaka3647 3 жыл бұрын
@@HashAliNZ I also have similar problem. One QR code need be able to distinguish Task 1 or Task 2 or Task 3. Print out end result who are in each Task at end of day. I was thinking add a question in Google form prior to pull up google Lens, then select Task 1, 2 or 3 before scan. How to do about doing this ? Is this too much coding ?
@HashAliNZ 3 жыл бұрын
@@harutanaka3647 What if you set up each student on their task first, then give them the QR code that autofills both the task number and their name? You can semi-automate the setup process using some more advanced techniques in Google Sheets. Here's a big project that someone on Reddit was working on that allows you to select the information first, and then you can create a QR code based on the final URL docs.google.com/spreadsheets/d/1Jm71h1zWXim8rds4-mytnU4V5jifwDCxeG9uw5AcGbw/edit?usp=sharing
@HussainAlMarkhi 2 жыл бұрын
Well explained and it's work fine 100% thank you for your efforts ❤
@HashAliNZ 2 жыл бұрын
Glad it helped
@MsOfficeLearning 2 жыл бұрын
Thank you for a great tutorial !
@HashAliNZ 2 жыл бұрын
Thanks
@heleenreid7140 3 жыл бұрын
This has been great! I've been trying to streamline attendance for 138 students for ages and this might just work. I have followed all your intstructions and some rows are not filling in the QR code. Most have filled automatically but some are empty. Any advice? Also any idea when you might do another useful video on how to take this attendance for multiple weeks in a course? separate response collections?
@HashAliNZ 3 жыл бұрын
Fantastic! I'll be making a video that covers all of this today. Hopefully I will have it ready to be released this week!
@exoticexplorationtourssdnb9303 2 жыл бұрын
hi its a great video. very informative. i would like to ask that is it possible to create staff automatic location detect attendance during check in via the scan code? means that staff will check in attendance using their location.
@whatsinthename5712 2 жыл бұрын
Today If I need to add more than one pre filled values in the google form, its not working with qr codes. can someone please check and let me know.
@ritumali3753 3 жыл бұрын
Really very helpful , it will lessen the burden of a teacher as well student also
@HashAliNZ 3 жыл бұрын
Thanks!
@MustafaAkman1965 2 жыл бұрын
Many thanks ♥
@haythembenhmida9695 Жыл бұрын
great video; i m wondering if the in and out time could be implemented thank you
@yasufumithebest 11 ай бұрын
Nice, thank you
@JimmyBradley-yt9ue Жыл бұрын
Brilliant. Thankyou
@Niknou11 Жыл бұрын
Looking to take a bus roster in google sheets so that it can be updated daily and then have the bus monitors scan the students barcode ID's to check them in as they get on the but and then again when they get off, if little Johnny is checked in but not out the bus driver can do a search of the whole bus to make sure he is sleeping in the back or whatever the case is....The google sheets updated roster would be good if a student accidently tried to get on the wrong bus. Is this even possible, I have been watching a bunch of videos but haven't found one that can do everything I want it to... Any Advise>??
@artjakedesierto8241 2 жыл бұрын
love it thanks man
@HashAliNZ 2 жыл бұрын
Thanks!
@KrisTheUkeChickGilbert 2 жыл бұрын
Great vid.....quick question. When I scan the qr code, it prompts me to log in to google every time. ANy thoughts on this? Also, how could I handle the prefilled link to include location attendance (like for a conference)
@HashAliNZ 2 жыл бұрын
Make sure you're not trying to collect email addresses. For the location, that's best done with a drop-down selection
@ESP95 2 жыл бұрын
me funciona perfecto, solo que cuando escaneo me pide la el usuario de la cuenta y no entra directo
@shirleyng9809 3 жыл бұрын
Great! Thanks a lot!
@HashAliNZ 3 жыл бұрын
Very welcome!
@rozitabintimohdzainiekpm-g7193 10 ай бұрын
Hi Hash, I tried to create a pre-filled google form with sections but didn't manage. The user has to select an option in section 1, before being directed to the next (e.g. section 2). Based on the selection in Sec.1: - In section 2, the user has to select his/her name (from a dropdown menu) and the following fields are supposed to be auto-filled. What should I do?
@mouhamadouelaminendiaye1150 3 жыл бұрын
Hello, I really liked your video, I'm one of your subscribers too, this update is so smooth and well explained. Thank you very much for the sharing of knowledge. By the way, is it a way to create data, for instance, if I, as a teacher take down the attendance every single day, and wanted to gather all the information by month, or by year, what should I do?
@HashAliNZ 3 жыл бұрын
Short answer: That's absolutely doable! Long answer: You're going to have to figure out the specifics of what you want to show/look at in your data. Do you want number of scans per month/year? That's the easiest. Do you want the number of non-duplicated scans each month/year? That's a bit tougher. Do you want to be able to select the student and a date range? Definitely doable but might take an extra hour or three to set up. Let me know what ideas you have and I'll see what I can come up with!
@mouhamadouelaminendiaye1150 3 жыл бұрын
@@HashAliNZ Hello Sir, Hope you are well, Thank you once again for your video. So sorry, I didn't realize that you answered back... What I really need exactly is to be able to know " to and also want to know "
@HashAliNZ 3 жыл бұрын
@@mouhamadouelaminendiaye1150 Hi Mouhamadou! Sorry, I think there might have been some error with your reply. Let me know what you want to happen and we'll figure out how to do it. Thanks!
@anwarulhaq6711 3 жыл бұрын
Hi! Great video! one question: is there a quick way for me to see only those that are absent instead? I am looking for a way to eliminate counter-checking against a physical name list instead.
@HashAliNZ 3 жыл бұрын
Absolutely. You'll need to have a full of students in one tab of your Google Sheet, and a filter to select the correct date. Then we can use a query that might look something like this: =query({B2:B,StudentList!A2:A}, "select Col1 where Col1Col2") where B has your form responses and C has your list of students. Email me with your spreadsheet if you want additional help
@orkin.itadmina2072 3 жыл бұрын
GREAT KUDOS Math Masters ... Thanks!!! all in ONE GOOGLE indeed
@HashAliNZ 3 жыл бұрын
Glad it was helpful!
@mozmr 3 жыл бұрын
Excellent video and very easy to follow
@HashAliNZ 3 жыл бұрын
Glad it was helpful!
@user-io8rz8rr7u Жыл бұрын
Is there a way to do a check in check out bathroom pass system with this? And have it organized by dates? Or something
@HashAliNZ Жыл бұрын
There is. It gets a bit messy because there's so many parts. I've explored using a touchscreen instead, but that does involve touching something which some people want to avoid due to bacteria and viruses
@camiloparadarojas3830 2 жыл бұрын
Great video. I am thinking how can we use this to rate subjects in a study by just scanning the QR code. Any idea of how can this be set up? I wonder if adding another layer to the form would help.
@HashAliNZ 2 жыл бұрын
Interesting idea. Is there any reason you want to do a QR system instead of a basic push button?
@DinoRodriguez 2 жыл бұрын
Excellent job 👍🏼👍🏼👍🏼
@HashAliNZ 2 жыл бұрын
Thanks!
@minamaged1688 2 жыл бұрын
Thank you so much I just wanted to what if I want to make for my students along the whole semester.. Am I gonna use the same link or what?
@HashAliNZ 2 жыл бұрын
Yes, the same link. You can then use the data and some spreadsheet magic to filter your data depending on which date you want to see. See here on how to do that: kzfaq.info/get/bejne/q9Z4aLaE3dHbf4k.html
@septemberluck9292 3 жыл бұрын
Thank you so much! :)
@HashAliNZ 3 жыл бұрын
Glad it helped!
@cindygarrido8102 3 жыл бұрын
Thank you for this very informative discussion on using QR code in tracking attendance of students. I just got a problem with my MacBook it wont show all of the qr code. i don't know why? what should I do?
@HashAliNZ 3 жыл бұрын
Hi Cindy, The most common reason that QR codes don't show up is due to spaces before, within, or after the person's name. Here's an easy fix: Select the column(s) with the names Press Ctrl+H In the Find box, type a space Leave the Replace With box empty Click the Replace All button. You should now see your QR codes
@ChandramouliDubey Жыл бұрын
what about if you add the location option in it so that only particular location where the person should be present than only his attandence works or shown.
@HashAliNZ Жыл бұрын
You could, but that adds complexity to the system. This is just a simple system in a spreadsheet program. If you want something more in-depth, there are paid apps that can do this for you
@margaretmcrobbie8127 2 жыл бұрын
How would I set up QR codes by lunches for particular seats
@HashAliNZ 2 жыл бұрын
Hmm... I'm not sure how to do that, sorry. There used to be an add-on called Form Limiter that could be used to select options from a list then remove that option but that's gone defunct now.
@azim3685 2 жыл бұрын
Thank you so much for the video, Sir! It's really helpful. I've a question. From the video, it shows the students that is present on that day. Would it be possible for me to see who's absent on that day from the name list?
@JB_thebig3 2 жыл бұрын
How do I find the the chart sizes?
@paweabaj6426 3 жыл бұрын
I love it!
@HashAliNZ 3 жыл бұрын
Thanks!
@srinivasseenu5398 3 жыл бұрын
Thanks and very useful video for us the create the sheet using QR doces.
@HashAliNZ 3 жыл бұрын
Glad it was helpful!
@zandruxerandio5956 2 жыл бұрын
Hi , brilliant idea. But can I ask is it possible to fo different entries like what class they're in, do you need to chop off the words before linking them on a URL? Like how you chose the first and last name instead of the full name? Ty
@HashAliNZ 2 жыл бұрын
Each class would need their own QR code for that student. There is a way to use the Full Name instead of the First and Last Name, but that requires a little bit of formula knowledge - use a regexreplace and search for a space and replace it with a + symbol
@aleonvc842 3 жыл бұрын
this is SO GREAT!!! new subscriber here!!! and i liked your video so i can go bank to it anytime!!!
@HashAliNZ 3 жыл бұрын
Awesome! Thank you!
@istoguful 2 жыл бұрын
Hey , it is possible to make this working for start/end shift of work , I need it for my organization ??
@HashAliNZ 2 жыл бұрын
Yes, definitely. I have a video coming out in the next few days.
@joelkepe7960 2 жыл бұрын
Joel kepe. Hello how are you? I was wondering if you could do the one way to automatically generate the QR CODE in the google drive form, but a QRC for certified coda. Thank
@HashAliNZ 2 жыл бұрын
Hi Joel. I'm not sure what you mean. Can you try ask another way? Thanks!
@craigwork5169 2 жыл бұрын
Dill Pickles haha. I love your subtle humor.
@sageerc1381 3 жыл бұрын
Great Video...Very Helpful...expect more like this...thanks ...Subscribed
@HashAliNZ 3 жыл бұрын
Thanks for the sub!
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 272 М.
MrsPTarleton
Рет қаралды 57 М.
GalloSheets
Рет қаралды 35 М.