How To Create A QR Attendance App System in 2024 For Teachers!

Рет қаралды 44,464

Күн бұрын

Amplify your spreadsheet savvy-support the channel here, access one-on-one consults, and find extra resources here: ko-fi.com/hashalinz
👩‍🏫 Welcome to the future of classroom attendance! In this video, I guide you through the setup of a foolproof, secure, and cost-effective attendance system using QR codes - just like airline ticketing systems but for your classroom. Say goodbye to traditional roll calls and embrace the efficiency of technology.
📱 What You'll Learn:
Creating personalized QR code-based student IDs.
Setting up an automated system for easy scanning and tracking.
Utilizing Google Sheets and add-ons for a seamless experience.
Tips on making the system accessible for all students.
🔗 Key Highlights:
0:00 Creating Student IDs Cards
8:03 Build your own Attendance App
🛠️ Tools Used:
- Google Slides
- Google Sheets
- Document Studio Add-on
- AppSheet for Custom App Creation
🧑‍🎓 Student-Friendly Features:
- Easy-to-save digital IDs
- Option to print IDs for non-smartphone users
- Quick scanning for efficient class entry
👨‍🏫 For Teachers:
- Simple setup for multiple classes
- Real-time attendance tracking
- Offline functionality with auto-sync upon reconnection
📊 Admin Dashboard:
- Customizable for attendance overview
- Integrable with Google Sheets or Looker Studio
🔔 Subscribe for more educational tech solutions and hit the bell to stay updated

Пікірлер: 135

@darkaaapps 6 ай бұрын

Great video! Making the teacher scan the QRs (as opposed to students scanning) is definitely better; there is less class disruption, the data is more reliable and the whole system is more secure.

@marzool1 8 ай бұрын

Thank you so much for this fantastic tutorial! Your step-by-step instructions made it incredibly easy to follow along and create my first app. I appreciate the time and effort you put into explaining each concept thoroughly.

@HashAliNZ 8 ай бұрын

Thanks, I appreciate the kind words!

@Caponies1 Ай бұрын

@@HashAliNZ Hi there! do you know how to make attendance sheet that is only accessible in our company address then outside of it you can no longer have access? Thank you!

@HashAliNZ Ай бұрын

This video shows how to make an app that works only for the phones you install the App on.

@harshadissanayake9266 4 ай бұрын

Hi this is super important...!!! Thanks for the content. Btw I have one question. Is there anyway to identify the individuals who did the scans? Can we provide unique IDs?

@Gabe1964 3 ай бұрын

Thanks!

@bri5green1 Ай бұрын

Hello, great video very informative, I'm having issues with getting the student ID# showing up with the scans. Is there a way to correct this?

@khalidalqahtani1940 Ай бұрын

Thank you very much for this useful and wonderful video. I would like to ask you how to avoid the situation where a student may miss attendance and send his QR to one of his colleagues, thus registering him as present while he is absent!

@edhythecrafter 3 ай бұрын

Hi bro, thats an incredible tutorial and easy to follow!... Now i want to use like a check-in for an event, and i dont know how to limit the creation of new data when the QR was readed, can you help me with that?

@Baraka002 Ай бұрын

thank you! how can i connect the app to the scanner device may be a barcode scanner

@bookbunny8029 5 ай бұрын

This is amazing! Thank you for this detailed video... was so useful! I do have a doubt... is it possible to choose a batch when scanning? So essentially, I want to be able to select a specific batch and then scan so that the Scanner sheet will also record that the scans were for that specific batch. Would this be possible? I'm trying it myself but not very successfully

@ethels.gallinero952 2 ай бұрын

Is it possible to add clock out or multiple clock in/clock out per day?

@noorabboud314 7 ай бұрын

Loved it! Is it possible to add number of students and then it counts untill the class is full? Like I have 20 students, with every scan it adds up till it reaches 20 and then it will notify me that my class is full. So even if a stranger entered it won't scan the code because its full.

@lorigruessing4183 4 ай бұрын

Question: Can I make this work to Check students in AND out?

@ZiadSaeed-j6w 16 күн бұрын

First of all you are great, I have a question what if I have groups do I have to do this system every time for each group , i don't know ,like how to make a copy or if u have an idea

@ExcelTipswithGagan 6 ай бұрын

Can you help me in How to autopopulate the drop down list valid item from google sheet in google App Sheet eNum List.

@user-xj2ck3wm7c 6 ай бұрын

Also I have this warning error message: Ignoring row 2 of table 'Main list' because it contains MultiRow formulas in editable column 'QRCode' [4] What do I need to do?

@RonKruiver 5 ай бұрын

How Can I return values from other columns, after the QR code is scanned? So whenever somebody scans the code from A2, the values from B2 (First Name and Last Name) is shown as well in the app. I know it should be done via a code but...........dunno the correct one

@MelissaRitchie-k2b 12 күн бұрын

Is there a way to do this, if they already have a bar code on their required IDs for school?

@hellhound4843 5 күн бұрын

Hi, just wondering what will i do to make the names appear? in the meantime ill try stuffs while waiting for your reply... Thank you for the wonderful video man.

@DanielaGarcia-tz6ic 4 ай бұрын

Great tutorial! Thank you so much! I have a question, if different teachers use it, will the information be logged into the same spreadsheet or will each teacher have their own? I would also like to know if you know how to add a task to the scan, for example “entered the class”, “did homework”, “participated”, etc.

@HashAliNZ 4 ай бұрын

You can add other teachers as "testers" for free. Up to 10 total users if I recall correctly. The data will be added to the same spreadsheet. If you have more teachers you want using the system, give them their own version and you can either link it to a different Sheet or the same Sheet in a different tab. For other query, you can add a list of students in the class as a new data table and view for each of the different things you want.

@user-xj2ck3wm7c 6 ай бұрын

Hi, I can't see the QR code icon button for me to press and scan. Is there a way for me to enable something for it to appear in the app?

@mahmoudemara5664 7 ай бұрын

genius bro thanks a lot :)

@HashAliNZ 7 ай бұрын

Anytime!

@user-zr7mn9dk8z 6 ай бұрын

can we use it on PC using scanner?

@sibilaldy 17 күн бұрын

hi have questions on my photo and barcode pictures are smaler than the box that we created. How to make it full on boxes? Also on Scans tab i have error formula with ={Scanner!A2:A} as you got nothing on your videos and mine are showing errors 😂 Please advices thanks

@user-xj2ck3wm7c 6 ай бұрын

What do I do if after scanning, I want the student ID, DateTime, AND name to appear in the data excelsheet?

@mao_cmt 7 ай бұрын

amazing tutorial!!!

@HashAliNZ 7 ай бұрын

Thanks!

@mao_cmt 7 ай бұрын

@@HashAliNZ This helps me a lot. I used to manually search for registration. With just one mobile phone and one person, I am able to successfully complete participant registration by scanning the QR Code. Your tutorial was greatly appreciated. The material is very clear and practical.

@Beshoo9111 6 ай бұрын

amazing video, just a question can i limit the amount of scans per ID, I would like to do this for my wedding guest list, and would like to ensure that the qr code could only be scanned once

@user-lq7tf8bf9b 6 ай бұрын

No answer yet :(

@suadz82 Ай бұрын

Can i use laptop to scan?

@keithshaylofjerezabayosait168 7 ай бұрын

Thank you, this was very helpful. Is it possible to add or notify that they scanned late?

@HashAliNZ 7 ай бұрын

Yeah you could do it either directly in the app, which is a bit more difficult, or do it on the Google Sheet. For example, in the Google Sheet you could use conditional formatting to highlight the late arrivals, or you could use a query to create a list of people that were late.

@chrisbradshaw5882 7 ай бұрын

Would you do a tutorial for a student reward tracking system? We use a point system and it would be nice to scan QR codes to add and subtract points (we let students spend points for candy, trinkets ect… I would like to be able to scan a student QR code and then a second QR code to add or subtract certain points. For instance, candy is worth 1 point but a fidget is worth 6 points. Accumulation of points from multiple scans throughout the day..

@HashAliNZ 7 ай бұрын

Interesting idea! I'll sort it out and add it to my list

@user-jr7tm8xn2b 7 ай бұрын

Appreciated for the tutorial - Important Question - 1) i thought the scanner app is driven by the data added, exist in the student ID card worksheet , but it looks like it is not, for example if a student Row is removed from the student ID card worksheet , and if the ID card is scanned in the app, it still adds the entry in the scanner worksheet. it should not be the case. 2) Tried adding corresponding Name also in the scanner sheet while scanning the ID , modified the initial value, Formula etc...but get get it correct. is that even possible? Please share your thoughts, thank you.

@aaryanjain8201 6 ай бұрын

See, if you would like to use the Student's Full Name you can try this formula that I tried :- In Column C I have added a Column Named "Student Name", now in C1 I wrote this formula which works perfectly fine. =ARRAYFORMULA(IF(ROW(B:B)=1, "Student Name", XLOOKUP(B:B, StudentIDCards!A:A, StudentIDCards!D:D,,0))) Here B:B indicates Student ID and A:A indicates Student ID from Sheet "StudentIDCards" whereas D:D indicates their "Full Name". Hope this Helps ;)

@ianposia276 5 ай бұрын

How do I automatically send sms to the parents after they scanned their id?

@aaryanjain8201 6 ай бұрын

How does Expiry Work as the QR won't expire Automatically??

@lisasteachingplace1324 6 ай бұрын

HELLO, HOW CAN I DO THIS FOR A DAILY ATTENDANCE

@carloscastroquintosa3598 5 ай бұрын

Can you make a video about how to create a QR CODE for payments ?

@TheSureboi 5 ай бұрын

Great Tutorial mate, Fantastic Teacher. I couldn't download the app on my iPhone, I Can see you used an Andriod in the tutorial. Is there a way to download the app to home screen please?

@HashAliNZ 5 ай бұрын

First, you need to download the AppSheet app from the iTunes store. Then you should be able to download your custom app. I'm not really sure other than that - I avoid iPhones and know next to nothing about them. support.google.com/appsheet/answer/10104495?hl=en#:~:text=You%20can%20find%20the%20AppSheet,store%20(for%20Android%20devices).

@helmiihamid 5 ай бұрын

How to see the student's name in the Scans tab?

@jefftafoya Ай бұрын

This is a great tutorial! Any idea why my qr codes are showing up very small in the center of the square on the IDs?

@HashAliNZ Ай бұрын

The textbox in your Google Slide should be the size you want the QR code to fill.

@Z0rlord 18 күн бұрын

@@HashAliNZ I'm having the same problem, but with the id photo, the QR fills but the photo does not

@danielvarner 3 ай бұрын

thanks, i followed the steps but got lost at the app part I didnt see a camera button to scan the qRcodes like you indicated.

@HashAliNZ 3 ай бұрын

Hey Daniel! To get the camera scanner to work, you need to ensure that the SCAN tickbox is ticked in the SCANNER tab for the STUDENTID line. Check out the part at 11:10 again

@cindyng2955 2 ай бұрын

Hi, is there a way to make sure the QR code is only scanned once each day? without duplicate? Once its scanned, it will not be allowed to scan again for the day.

@HashAliNZ Ай бұрын

No, sorry. That would require a little bit of formula work to count only the first (or last) one each day. Not too difficult within your Sheet.

@jessicaleclair578 2 ай бұрын

My school board does not allow Document studio. Is there an alternate qr generator that you would recommend?

@HashAliNZ 2 ай бұрын

Dang that sucks! I've tried a few like BeaconStac and others, but havent found any that works as well as Doc Studio. Sorry!

@user-xj2ck3wm7c 6 ай бұрын

Hi, the qr code scanner button did not appear in the app. I've also gone to 'other properties' and click on 'scannable'. How do I make it appear?

@Z0rlord 18 күн бұрын

same problem, any solutions?

@jackiesowell4266 6 ай бұрын

Do you have to have the paid version for the scanner function to work? I can’t get the scanner to work on my iPhone.

@HashAliNZ 3 ай бұрын

No, it's free in Google App Sheet

@Z0rlord 18 күн бұрын

@@HashAliNZ scanner button does not appear in the appsheets app

@matteocalderini9719 8 ай бұрын

great job! Is it possible to enter the date and time of exit in addition to the date and time of entry?

@HashAliNZ 8 ай бұрын

The easiest way is to duplicate the app and set it up as the exit one

@HuyNguyenuc-cd3qr 3 ай бұрын

Amazing tutorial

@HashAliNZ 3 ай бұрын

In your Sheet it'll record the ID. All you need to do is use a vlookup to match the ID to the students' name.

@huynguyenuc7438 3 ай бұрын

@@HashAliNZ It works. Thank you so much

@longstorytechhub 5 күн бұрын

does this support iphone.i am having issues with clicking the scan button to take the id

@HashAliNZ 5 күн бұрын

Sorry I'm not sure. I don't know anything about iPhones and don't have access to one to test. Noone else has said anything to me before about it so I don't think so..

@krisburtmatthewballesteros307 6 ай бұрын

Is there a way for me to convert the QR codes generated in Sheets into image files? Thank you!

@aaryanjain8201 6 ай бұрын

Yeah there is a way for this, you can use the =IMAGE Function to convert the QR Code URL to image.

@bassammohamed2225 7 ай бұрын

I used (=QRcode(A2) but not work so used (image function) and QR appear but after the workflow done and run the QR not added to the student ID card only the name and picture only added

@HashAliNZ 7 ай бұрын

It needs to be the QRCODE function. Make sure you've opened Document Studio, close it, then run the function. By opening Document Studio it gives you access to the QRCODE function

@bassammohamed2225 6 ай бұрын

Ok,thanks@@HashAliNZ I make QR image for the name(arabic name) instead of student id due to I want to appear name after scan rather ID But when I scan the QR Image it appear (Xxxxxxxx) rather than name So is there any problem with arabic name or document studio is not support for arabic language . Can fix this problem?

@askeladd8850 7 ай бұрын

Is there a way to add multiple timestamps for checking in, checking out and break time?

@HashAliNZ 7 ай бұрын

Probably the best way is to duplicate the app for each thing. Or just duplicate the Scanner, naming each one appropriately

@ingill_ 3 ай бұрын

Hi can u make an attendance where only the admin can scan their QR and will be recorded?

@HashAliNZ 3 ай бұрын

Unfortunately no, not without some serious programming. However the method shown in this video you can just filter out the admins

@ExcelTipswithGagan 6 ай бұрын

I have created that similar app. But after scanning 2nd QR code it is asking for Saving it again and again. Please help me. As soon as possible. Some default settings has been changed. I don't know.

@HashAliNZ 6 ай бұрын

Follow all the instructions from 10:40 to 12:46. If the order is incorrect, the tickboxes aren't correctly ticked, the view types are different to what I show, and the view type settings are different, then it won't auto-complete and it'll keep getting you to submit.

@jherdamrhoimagallanes8464 8 ай бұрын

Thanks a lot. This is a big help. Is it possible to send SMS to parents? Notifying them that they are present?

@HashAliNZ 7 ай бұрын

Yes, absolutely. In AppSheet there's a section called "Automations". You can create a bot that sends an SMS when a scanner record is updated. You just need to record the phone details. In my experience, parents prefer to get a message when their child is NOT at school, which could be a bit more difficult to setup.

@stonestudio9 6 ай бұрын

I think after taking attendance. We can use slices filter out absent students and then use Automation to send SMS messages to parents.

@rodgerfransman4542 28 күн бұрын

Great video, is there any way of linking the scans to WhatsApp?

@HashAliNZ 28 күн бұрын

Not natively that I know of. I haven't explored WhatsApp much, it's not a popular app here in New Zealand. But there might be a way to link it with zapier or pabbly. AppSheet does have advanced automation workflow built into it, so you could get it to send messages but I'm not sure about doing it through WhatsApp

@crissygiacona8022 Ай бұрын

Wow! Can this work with NFC tags?

@HashAliNZ Ай бұрын

Yes. When setting up the checkboxes in the backend, there's a setting for "NFC"

@guiverneilesguerra9282 2 ай бұрын

Is it possible to add the image in the scans? Thank you

@HashAliNZ 2 ай бұрын

So, apparently there is. I investigated this when I created the method and everything I found said it's doable. However, in all my testing I could never get it to work and I just don't know why.

@guiverneilesguerra9282 2 ай бұрын

Thank you sir.

@john1802 7 ай бұрын

Woah cool stuff

@gilbertsbiogasexpertske1120 5 ай бұрын

Can the same idea be implemented by use of NFC tags rather than using QR codes

@HashAliNZ 5 ай бұрын

Absolutely. When setting up the rows in AppSheet, there's a tickbox for "NFC" near the "Scan?" tickbox

@gilbertsbiogasexpertske1120 5 ай бұрын

Let me give it a try, and by the way is the process all free

@evansebenezerofficial2842 3 ай бұрын

Do I need a workspace account for this?

@HashAliNZ 3 ай бұрын

No, a free account works. I made this video on a free account

@evansebenezerofficial2842 3 ай бұрын

Do I have an option to fill the image i.e shape in the ID card? I don't get any output its blank?

@skinnylages 3 ай бұрын

1. How can I make i show those I scanned? 2. How does it show those who are not scaned?

@HashAliNZ 3 ай бұрын

It'll show you the IDs of those who scanned. To get the names, simply use a vlookup. To show who didn't get scanned, you'll need to have a full list of students the filter out the ones who did scan.

@francosepulcri4283 6 ай бұрын

So, if I am poor and cannot pay for the extension, I`m done, right? You should have said you have to pay for this at the beginning of the video...

@HashAliNZ 6 ай бұрын

It depends. If you've got like 400 or more people, then you probably need to either front up the money (or get your school to pay for it), or you could just run it for free over several days. You don't have to pay annual - there is a monthly option. So pay for it for the month, then unsubscribe. Of course, any new students that come after the month is over might get left off the roll...

@ahmedmeglali1700 Ай бұрын

Do the qr code generated expire ?

@HashAliNZ Ай бұрын

No, the only thing the qr code holds is the person's ID or name, no other info

@jubairmarahman7086 5 ай бұрын

How resize images on ID Card

@HashAliNZ 5 ай бұрын

On the ID card created in Canva or Slides? The image should fit to the size of the box you put the {{Image}} tag in

@AngadSokhi 7 ай бұрын

If a student has a photo of another students id card, can they not fake their attendance as well?

@HashAliNZ 7 ай бұрын

Sure. But then they'd have to scan multiple IDs which would be an obvious hold up for the rest of the students. I get this comment come up quite a bit and I'm just surprised because it shows that so many teachers, not the majority by a long shot, just don't interact with their students and figure this stuff out. When I have a class, I interact with every one of my students every day totaling around 120 to 150 students a day. If there's a discrepancy in an attendance I can very easily search my memory going back at least a few days, sometimes more depending on the student, to remember if they were actually there. I've also built a trust system with my students so they actually want to be in class, and if they don't they'll tell me they're going to skip for whatever reason - communication works. Teachers really need to stop coming up with excuses and just do better. You want a different system that's 100% secure? Pay for one. My systems have helped a lot of people and comments like these really show those teachers who need to step up.

@macmacho 6 ай бұрын

Very good. Please could you tell me how to delete a user who has already registered?

@HashAliNZ 6 ай бұрын

Delete it from your Google Sheets records

@yetzzhif 7 ай бұрын

Would you do a tutorial student just scan teacher QR code for attendance ?

@HashAliNZ 7 ай бұрын

Unfortunately that's quite difficult to do. I'll keep working on a way to figure it out in the Google Platform. There are ways to do it using Microsoft PowerApps, but I'm not well-versed in how that works

@colleennikstenas4921 3 ай бұрын

@@HashAliNZ This is what I did with your info! worked the same. What I did was just keep track of the students in the group. However, each group only has 6-8 students anyway. Same setup though. Without the picture. Just enlarged the code and laminated a page for the instructors to take to the clinicals with them each week. It has worked ok. Gets a bit messy on filtering for dates though for me. I have fifteen weeks for attendance tracking, on two opposing days, with more than a hundred students in around 15-20 groups located on different units for clinical experiences. Would love to streamline the filters and make it more automated to a single page report. That way I can visualize and set up makeup days more readily.

@ivankan2070 3 ай бұрын

can this use in China?

@HashAliNZ 3 ай бұрын

I have no idea. Never talked to anyone from there about it.. If you're there and you're using your Google Account, then yes I think so. All you need is Google Sheets with the Document Studio addon, and Google App Sheet

@alexandernygren1993 Ай бұрын

Did they change to 25 per month (instead of per day) for the free version?.. 😑

@HashAliNZ Ай бұрын

Unfortunately, yes. I only just found this out a few days ago when I had to do some treasurer invoicing. To make matters worse, the notification we get is that the quota is 25 per week - the wording hasn't been updated yet. I'll email them and let them know. It's kinda disappointing, but that's how business goes. I did approach them to try get some kind of deal with my viewers but they don't do that kinda thing. I'll work on getting a different solution out within the next month.

@alexandernygren1993 Ай бұрын

Thank you in advance for hopefully showing us a different method! (At least for the document studio part) 😇 I really liked your tutorial regarding this topic. This solution actually helped a nonprofit organization that I'm a part of (so we can track statistics of visitors better). So I can't express enough gratitude for this tutorial!! Keep up the awesome tutorials 🤩😊

@Muhammadashique-mh6zm 5 ай бұрын

How to make qr event ticket

@HashAliNZ 5 ай бұрын

Exactly like the video shows, but instead of a Student ID, use a ticket - you can get free templates at Canva

@becky1996chacko 4 ай бұрын

I AM HAVING A PROBLEM " UNABLE TO FETCH APP DEFINITION" THE APP DID NOT LOAD SUCCESSFULLY..... KINDLY ADVISE WHAT NEEDS TO BE DONE SIR

@HashAliNZ 4 ай бұрын

The first thing is to make sure to read the error message and see if you can fix it. Press "Go to the problem" to see where the error is detected.

@sarnas699 3 ай бұрын

date only shown not time

@HashAliNZ 3 ай бұрын

Change it to datetime instead of date

@sarnas699 3 ай бұрын

@@HashAliNZ thank you for your suggestions. How can I get name in scanner sheet

@petermelling798 7 ай бұрын

Nice as usual. It's too long and uses add-ons. Thanks for sharing.

@HashAliNZ 7 ай бұрын

Yeah, but it's so much better than the other methods. More secure, personalised, efficient, works offline and can send out the student ID cards (which you don't have to if you don't wanna use add-ons for some reason 🤷🏼).

@sivasankarpandiraj3825 4 ай бұрын

I CANT GET THE NAME OF STUDENT

@HashAliNZ 3 ай бұрын

Use a Lookup to get the names

@sivasankarpandiraj3825 3 ай бұрын

@@HashAliNZ But how.. Can u explain it plss..

@dreaminate 3 ай бұрын

In Google sheets, use VLOOKUP function on the names

@user-hb8ko2fn9h 5 ай бұрын

What do I do if after scanning, I want the student ID, DateTime, AND name to appear in the data excelsheet

@HashAliNZ 5 ай бұрын

That all gets populated within the Google Sheet (not Excel Sheet, wrong program). Once you've got the ID you can extract the Name from a separate list of all IDs and names using a lookup function