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
  • НаукаНаука

Комментарии • 45

  • @user-ni9ws5mj2u
    @user-ni9ws5mj2u Год назад +7

    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?

  • @kathrynparrotta4442
    @kathrynparrotta4442 9 месяцев назад

    Thank you! Is there a way to see who DIDN'T scan in? This is the function I'm really needing...

  • @user-rf7be9qp2k
    @user-rf7be9qp2k 2 месяца назад +2

    Hello, why is it not working now? does not show qr code

  • @royalriders4121
    @royalriders4121 3 месяца назад

    thank you so much

  • @chaijuighee3817
    @chaijuighee3817 8 месяцев назад

    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

  • @user-vh4xx1kq4s
    @user-vh4xx1kq4s 7 месяцев назад +3

    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 3 месяца назад +1

      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.

  • @NeerajKumar-zi4zg
    @NeerajKumar-zi4zg 11 месяцев назад

    can we record the attendance daily following this procedure?

  • @theamazingreptar
    @theamazingreptar Год назад +1

    Awesome. What happens if you scan twice the same QR code?

  • @user-xc7ni4xb5d
    @user-xc7ni4xb5d 6 месяцев назад +1

    I carefully followed the instructions but the qr codes did not generate. can anyone help me with this ?

  • @ggbin8092
    @ggbin8092 11 месяцев назад +1

    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 5 месяцев назад +2

      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

  • @SWORDBEAST
    @SWORDBEAST 6 дней назад

    But if they take pictures of their QR code in their smart phones, they can easily mark their attendance even from home.

  • @shemabrammerqa.espartero3057
    @shemabrammerqa.espartero3057 9 месяцев назад

    Is there a way to make this work offline?

  • @nixonbecerra4685
    @nixonbecerra4685 9 месяцев назад

    Works Fine For me

  • @careforanimals4675
    @careforanimals4675 10 месяцев назад

    But new qr code for each??

  • @pawaliamit
    @pawaliamit 9 месяцев назад +3

    how to include time in and time out into this attendance system?

    • @Hakabasuuban
      @Hakabasuuban 9 месяцев назад +2

      Absolutly wonderful question👌

    • @gjergji2x
      @gjergji2x 5 месяцев назад +1

      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.

  • @IrfanAzmanRTM-RH-ZONE2
    @IrfanAzmanRTM-RH-ZONE2 Месяц назад

    the QR code is not appear, can anyone help?

  • @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  Год назад +1

      @@kathleengailtomas3906 Could you please perform the steps from 7:05 - 9:22 once again carefully. Let me know how it works.

    • @tdkotobo6522
      @tdkotobo6522 Год назад +1

      Qr is not working it doesn't scan

    • @Mech174
      @Mech174 Год назад

      @@tdkotobo6522 did you try with another qr service like image-charts?

  • @sadsongs362
    @sadsongs362 2 месяца назад +1

    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 7 месяцев назад

    Its showing error

  • @ravi4201254
    @ravi4201254 11 месяцев назад +1

    I followed all the process but QR code did not generated

  • @furious220f
    @furious220f 2 месяца назад +2

    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