QR Code Attendance System (google sheets and google forms)

  Рет қаралды 104,769

Last Minute Tech

Last Minute Tech

Күн бұрын

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

Пікірлер: 46
@StevenSaiya
@StevenSaiya Жыл бұрын
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?
@IrfanAzmanRTM-RH-ZONE2
@IrfanAzmanRTM-RH-ZONE2 4 ай бұрын
the QR code is not appear, can anyone help?
@geet_aromi1277
@geet_aromi1277 10 ай бұрын
Its showing error
@furious220f
@furious220f 5 ай бұрын
QR code is not shown
@Abidali-qi3xj
@Abidali-qi3xj 4 ай бұрын
I have this project with more. Features
@Stud-sy9vv
@Stud-sy9vv 4 ай бұрын
@@Abidali-qi3xj could you tell me the steps of how you did it?
@Abidali-qi3xj
@Abidali-qi3xj 4 ай бұрын
@@Stud-sy9vv yes i can.
@joshtzy77
@joshtzy77 4 ай бұрын
@@Abidali-qi3xj how
@Abidali-qi3xj
@Abidali-qi3xj 3 ай бұрын
@@joshtzy77 hw to talk with you ?
@ravi4201254
@ravi4201254 Жыл бұрын
I followed all the process but QR code did not generated
@JeffFrias-g4y
@JeffFrias-g4y 10 ай бұрын
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.
@mariaaldana432
@mariaaldana432 6 ай бұрын
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.
@МаксимИванов-ш3к6л
@МаксимИванов-ш3к6л 5 ай бұрын
Hello, why is it not working now? does not show qr code
@MELISSAONG-k8s
@MELISSAONG-k8s 8 ай бұрын
I carefully followed the instructions but the qr codes did not generate. can anyone help me with this ?
@sadsongs362
@sadsongs362 4 ай бұрын
QR code show nahi ho raha sab kuch follow kiya but last me qr code nahi dikhayi de raha
@Abidali-qi3xj
@Abidali-qi3xj 4 ай бұрын
I have this project with complete working
@SWORDBEAST
@SWORDBEAST 3 ай бұрын
But if they take pictures of their QR code in their smart phones, they can easily mark their attendance even from home.
@pawaliamit
@pawaliamit Жыл бұрын
how to include time in and time out into this attendance system?
@Hakabasuuban
@Hakabasuuban Жыл бұрын
Absolutly wonderful question👌
@gjergji2x
@gjergji2x 8 ай бұрын
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.
@kathrynparrotta4442
@kathrynparrotta4442 Жыл бұрын
Thank you! Is there a way to see who DIDN'T scan in? This is the function I'm really needing...
@ggbin8092
@ggbin8092 Жыл бұрын
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.
@serenade8905
@serenade8905 8 ай бұрын
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
@sayarkyaw
@sayarkyaw 9 ай бұрын
I follow these trenssation, I reached the fast Qr Code but I clicked Double Click on it but no apper anything in below.
@MostafaAhmed-bg6yw
@MostafaAhmed-bg6yw 7 ай бұрын
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
@Stud-sy9vv
@Stud-sy9vv 4 ай бұрын
Could you tell me the steps if you have made it ?
@chaijuighee3817
@chaijuighee3817 11 ай бұрын
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?
@NeerajKumar-zi4zg
@NeerajKumar-zi4zg Жыл бұрын
can we record the attendance daily following this procedure?
@shemabrammerqa.espartero3057
@shemabrammerqa.espartero3057 Жыл бұрын
Is there a way to make this work offline?
@careforanimals60
@careforanimals60 Жыл бұрын
But new qr code for each??
@royalriders4121
@royalriders4121 6 ай бұрын
thank you so much
@theamazingreptar
@theamazingreptar Жыл бұрын
Awesome. What happens if you scan twice the same QR code?
@g4128-k
@g4128-k Жыл бұрын
great
@kathleengailtomas3906
@kathleengailtomas3906 Жыл бұрын
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?
@lastminutetech
@lastminutetech Жыл бұрын
Did you change “viewform” to “formResponse” with a capital R in the URL?
@kathleengailtomas3906
@kathleengailtomas3906 Жыл бұрын
@@lastminutetech Yes, actually, the URL is working but the QR Code is not.
@lastminutetech
@lastminutetech Жыл бұрын
@@kathleengailtomas3906 Could you please perform the steps from 7:05 - 9:22 once again carefully. Let me know how it works.
@tdkotobo6522
@tdkotobo6522 Жыл бұрын
Qr is not working it doesn't scan
@Mech174
@Mech174 Жыл бұрын
@@tdkotobo6522 did you try with another qr service like image-charts?
@nixon.becerra
@nixon.becerra Жыл бұрын
Works Fine For me
@9760210116
@9760210116 6 ай бұрын
fake h
QR CODE ATTENDANCE TAKING WITH GOOGLE FORMS | Geek Out
18:39
Casually NERDS
Рет қаралды 114 М.
Create a data entry form in Google Sheets
8:19
hay kel
Рет қаралды 27 М.
Поветкин заставил себя уважать!
01:00
МИНУС БАЛЛ
Рет қаралды 6 МЛН
когда не обедаешь в школе // EVA mash
00:57
EVA mash
Рет қаралды 3,5 МЛН
How to Create a QR Code Attendance System in 2023 for Teachers
17:18
Generate and send QR Code e-tickets in Google Sheets for attendance tracking (with check-in)
4:09
Automated attendance using Google Forms
6:26
EdTechMedic
Рет қаралды 374 М.
Can you scan a barcode into a Google Sheet?
4:22
The Mobile Sales Engineer
Рет қаралды 329 М.
Поветкин заставил себя уважать!
01:00
МИНУС БАЛЛ
Рет қаралды 6 МЛН