QR Code Attendance System (google sheets and google forms)
HTML-код
- Опубликовано: 23 апр 2023
- In this video we'll look at how to make QR code attendance system. I'll guide you through the step-by-step procedure to create attendance using QR code. Actually, this is a QR code attendance system using google sheets and google forms.
Have you ever wondered "How do you use a QR code for student attendance" then this video is for you. In order to learn how to create a QR code for attendance, just follow along the video. By the end of this video, you'll be able to make a QR code attendance system for students or employees.
The steps to create a QR code attendance system is also mentioned below.
In order to make a QR code for attendance, you'll need to use Google Sheets and Google Forms.
Steps Involved:
- Import list of Students' names to Google Sheets
- Copy list of Students' names into Google forms
- Create Pre-filled links
- Create QR Codes
After the third step of creating a pre-filled link, we'll alter the link to record responses using some formulas and create QR codes for those altered pre-filled links.
After creating the QR Codes, we can arrange them according to our requirements in Google Sheets and then print them if needed.
This is how to track attendance with QR code.
If this video helped you in creating a QR code attendance system, do consider Subscribing to the channel.
SUBSCRIBE - bit.ly/3olihfZ
#QRattendance
#QRcodeattendance Наука
I carefully followed the steps in the video but it didn't automatically submit the response as shown in the video. Instead, respondent has to press the submit button manually. Did I miss something?
Thank you! Is there a way to see who DIDN'T scan in? This is the function I'm really needing...
Hello, why is it not working now? does not show qr code
thank you so much
How to apply or send it to the students to scan the qr code themselves? Did i need to send it one by one to the separate students?
I follow these trenssation, I reached the fast Qr Code but I clicked Double Click on it but no apper anything in below.
great
I followed your instructions, but wondering why there are some URLs that have no hyperlinks, and cannot generate codes if there's no hyperlink. I got some names with QR generated.
When you type the name or last name, do not press space at the end. If there are spaces it will not show the hyperlink.
can we record the attendance daily following this procedure?
Awesome. What happens if you scan twice the same QR code?
I carefully followed the instructions but the qr codes did not generate. can anyone help me with this ?
First of all, thanks for sharing this great video. But i still wonder how it can be used in real life.
In real application, we cannot use a smartphone as scanner, right? there has to be a device that's always there waiting for students to put their card on to be scanned.
this is currently my capstone project, I've tried sevel trial and error methods, to see what fits for using a scanner, still in 12th grade and with my limited budget i can only dream as much, but i'll try my best. I've come to conclude of using a template that can be used several times
But if they take pictures of their QR code in their smart phones, they can easily mark their attendance even from home.
Is there a way to make this work offline?
Works Fine For me
But new qr code for each??
how to include time in and time out into this attendance system?
Absolutly wonderful question👌
You can name it Check-in and do exactly what was showed in this tutorial. You'll end up with QR codes for Check-in form.
For the Check-out, you repeat it again same as before. You have to provide 2 QR codes for each student, one is to check-in and the other QR is to check-out.
P.s Timestamp is already provided when the form is submitted. You can see it yourself at the end of the video.
the QR code is not appear, can anyone help?
Hi, I followed your instructions but by scanning the QR code, the unfilled form appears, it doesn't show that my response was submitted. What could i be doing wrong?
Did you change “viewform” to “formResponse” with a capital R in the URL?
@@lastminutetech Yes, actually, the URL is working but the QR Code is not.
@@kathleengailtomas3906 Could you please perform the steps from 7:05 - 9:22 once again carefully. Let me know how it works.
Qr is not working it doesn't scan
@@tdkotobo6522 did you try with another qr service like image-charts?
QR code show nahi ho raha
sab kuch follow kiya but last me qr code nahi dikhayi de raha
I have this project with complete working
Its showing error
I followed all the process but QR code did not generated
QR code is not shown
I have this project with more. Features
@@Abidali-qi3xj could you tell me the steps of how you did it?
@@Stud-sy9vv yes i can.
@@Abidali-qi3xj how
@@joshtzy77 hw to talk with you ?
honestly too much details in the qr and still can be scammed if any other students sends it for his college to attend for him while he is at home , sorry but all i want to so is to make one qr code so that the students can type their name , ID , and their subject but also secure the qr code itself instead of everysingle one of it a qr code
Could you tell me the steps if you have made it ?
fake h