QR Code Attendance System (google sheets and google forms)

  Рет қаралды 91,442

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

Пікірлер: 45
@user-ni9ws5mj2u
@user-ni9ws5mj2u Жыл бұрын
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?
@royalriders4121
@royalriders4121 3 ай бұрын
thank you so much
@kathrynparrotta4442
@kathrynparrotta4442 10 ай бұрын
Thank you! Is there a way to see who DIDN'T scan in? This is the function I'm really needing...
@user-vh4xx1kq4s
@user-vh4xx1kq4s 8 ай бұрын
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 4 ай бұрын
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.
@chaijuighee3817
@chaijuighee3817 9 ай бұрын
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?
@sayarkyaw
@sayarkyaw 6 ай бұрын
I follow these trenssation, I reached the fast Qr Code but I clicked Double Click on it but no apper anything in below.
@nigelcolon
@nigelcolon Жыл бұрын
great
@NeerajKumar-zi4zg
@NeerajKumar-zi4zg Жыл бұрын
can we record the attendance daily following this procedure?
@user-rf7be9qp2k
@user-rf7be9qp2k 3 ай бұрын
Hello, why is it not working now? does not show qr code
@user-xc7ni4xb5d
@user-xc7ni4xb5d 6 ай бұрын
I carefully followed the instructions but the qr codes did not generate. can anyone help me with this ?
@shemabrammerqa.espartero3057
@shemabrammerqa.espartero3057 10 ай бұрын
Is there a way to make this work offline?
@theamazingreptar
@theamazingreptar Жыл бұрын
Awesome. What happens if you scan twice the same QR code?
@ggbin8092
@ggbin8092 11 ай бұрын
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 6 ай бұрын
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
@pawaliamit
@pawaliamit 10 ай бұрын
how to include time in and time out into this attendance system?
@Hakabasuuban
@Hakabasuuban 10 ай бұрын
Absolutly wonderful question👌
@gjergji2x
@gjergji2x 5 ай бұрын
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.
@nixonbecerra4685
@nixonbecerra4685 10 ай бұрын
Works Fine For me
@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?
@careforanimals4675
@careforanimals4675 11 ай бұрын
But new qr code for each??
@IrfanAzmanRTM-RH-ZONE2
@IrfanAzmanRTM-RH-ZONE2 2 ай бұрын
the QR code is not appear, can anyone help?
@SWORDBEAST
@SWORDBEAST 28 күн бұрын
But if they take pictures of their QR code in their smart phones, they can easily mark their attendance even from home.
@sadsongs362
@sadsongs362 2 ай бұрын
QR code show nahi ho raha sab kuch follow kiya but last me qr code nahi dikhayi de raha
@Abidali-qi3xj
@Abidali-qi3xj 2 ай бұрын
I have this project with complete working
@geet_aromi1277
@geet_aromi1277 8 ай бұрын
Its showing error
@ravi4201254
@ravi4201254 Жыл бұрын
I followed all the process but QR code did not generated
@furious220f
@furious220f 3 ай бұрын
QR code is not shown
@Abidali-qi3xj
@Abidali-qi3xj 2 ай бұрын
I have this project with more. Features
@Stud-sy9vv
@Stud-sy9vv Ай бұрын
@@Abidali-qi3xj could you tell me the steps of how you did it?
@Abidali-qi3xj
@Abidali-qi3xj Ай бұрын
@@Stud-sy9vv yes i can.
@joshtzy77
@joshtzy77 Ай бұрын
@@Abidali-qi3xj how
@Abidali-qi3xj
@Abidali-qi3xj Ай бұрын
@@joshtzy77 hw to talk with you ?
@MostafaAhmed-bg6yw
@MostafaAhmed-bg6yw 4 ай бұрын
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 Ай бұрын
Could you tell me the steps if you have made it ?
@9760210116
@9760210116 3 ай бұрын
fake h
How to Create a QR Code Attendance System in 2023 for Teachers
17:18
What it feels like cleaning up after a toddler.
00:40
Daniel LaBelle
Рет қаралды 73 МЛН
ЧУТЬ НЕ УТОНУЛ #shorts
00:27
Паша Осадчий
Рет қаралды 9 МЛН
Best KFC Homemade For My Son #cooking #shorts
00:58
BANKII
Рет қаралды 58 МЛН
Inventory with QR Codes in Google Sheets and Google Forms
19:07
Practical Sheets
Рет қаралды 69 М.
The SIMPLEST Way To Take Attendance
20:45
Hash Ali
Рет қаралды 11 М.
QR Attendance using Google sheets and Google forms
7:43
Peace Growba
Рет қаралды 7 М.
Can you scan a barcode into a Google Sheet?
4:22
The Mobile Sales Engineer
Рет қаралды 314 М.
Check in / out Google Sheets
12:05
The Mobile Sales Engineer
Рет қаралды 189 М.
Create QR Codes for FREE | Use Anywhere (Excel, Word & PowerPoint)
6:53
$1 vs $100,000 Slow Motion Camera!
0:44
Hafu Go
Рет қаралды 27 МЛН
EXEED VX 2024: Не өзгерді?
9:06
Oljas Oqas
Рет қаралды 49 М.
Cheapest gaming phone? 🤭 #miniphone #smartphone #iphone #fy
0:19
Pockify™
Рет қаралды 4,3 МЛН
ГОСЗАКУПОЧНЫЙ ПК за 10 тысяч рублей
36:28
Ремонтяш
Рет қаралды 560 М.