RFID Attendance System using ESP8266 and Google Sheets Version 4

[@sihemsihem5054]

شكرا أخ أحمد ،بارك الله فيك، واصل In the coming days, we hope that this project will be using QR code esp32 cam......thanks

[@kamalkamel7559]

hello my friend, it's been a long time since you've been away, I hope you're well!! thank you for the videos, thank you for being there!!

[@AhmadLogs]

Thank you for your comment and for checking in on me! I took a bit of a break from creating and uploading videos to focus on some personal matters, but I'm back now and excited to start creating content again. Thank you for your support and for being a part of this community!

[@kamalkamel7559]

@@AhmadLogs ooh, the pleasure is shared, we learned a lot from you, thank you for being there and with great pleasure

[@AhmadLogs]

@@kamalkamel7559 thanks a lot

[@jaroncole1088]

Hi Ahmad, I am currently having trouble with my network credentials when attempting the project. Are you using your own network Wi-Fi? I am trying to use a mobile hotspot for the module to connect to however it doesn’t seem to work when I attempted it several times. I would use my college’s network however the college network is private so really no chance of getting those credentials.

[@jaroncole1088]

Hi Ahmad, I am currently having trouble with my network credentials when attempting the project. Are you using your own network Wi-Fi? I am trying to use a mobile hotspot for the module to connect to however it doesn’t seem to work when I attempted it several times. I would use my college’s network however the college network is private so really no chance of getting those credentials.

[@warrenscorner]

Very cool Ahmad! I don’t have a project yet for RFID but I’ll think of something.

[@AhmadLogs]

thanks

[@johnpaulvalendez7211]

thank you so much, you saved our capstone for research. godbless

[@sohailulhannan]

Thank you 💝 I will try it. Love from Bangladesh.

[@AhmadLogs]

Hope you enjoy

[@sohailulhannan]

@@AhmadLogs all work fine but time is not working. In time zone i put "asia/dhaka" But not match. What can I do?

[@AhmadLogs]

@@sohailulhannan you might try to change time zone from google sheet GUI

[@sohailulhannan]

@@AhmadLogs i changed it. But still no outcome 😔

[@AhmadLogs]

@@sohailulhannan hmmmm. have you watched my this video. it might be helpful kzbin.info/www/bejne/g2q2lJxqo9iHe80.

[@shakerileiwat4341]

Welcome back Miss your videos 👍👍👍

[@AhmadLogs]

Thank you for the warm welcome!

[@SlavišaPetrović-AkademijaOxfor]

HI Ahmad thank you for a good eplanation of the project. Do you know why LCD screen is blinking? It occurs when blue led of nodemcu is blinking rapidly

[@muhammadm1237]

Man keep doing this awesome explanation. You did perfect bro

[@AhmadLogs]

thanks

[@kurtlrnzv_]

@@AhmadLogshi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?

[@Onur_Cndk]

greetings from Turkey. the system is very nice. My advice to you is to add a buzzer and batteries to the system. display the battery status on the screen. maybe you should just store the data on the sd card :))

[@AhmadLogs]

Thanks for the tips!

[@alextirkey3142]

Project working fine but one thing i would like to ask how to insert data from top row to downward in Google sheet

[@gialinhnguyentruc3502]

Thank's for this object. It is very helpful for me. But i have a question can you answer? I want to change RFID by Fingerprint sensor the code how about? Thanks a soon answer...

[@raymondjuballa5486]

@AhmadLogs I was able to add a relay to the system and am now looking to reference and display the First and last name rather than student ID when displayed on the LCD when it registers and logs a card. Advice?

[@zwack2097]

is the nodemcu need to connect to wifi inorder to run this program?

[@adarsh_1310]

Sir All thinks is done work perfectly i can see it on the serial monitor but nothing is showing in lcd.. What is the problem.. What solution fir it..

[@AhmadLogs]

test your lcd separately. There might be some connection issues.

[@adarsh_1310]

@@AhmadLogs ok sir

[@crisiec9776]

I am getting this error: Reading last data from RFID... Authentication failed for Read: Timeout in communication. Authentication failed for Read: Timeout in communication. Authentication failed for Read: Timeout in communication. Authentication failed for Read: Timeout in communication. Authentication failed for Read: Timeout in communication. Publishing DataPlease Wait...Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": ",,,,,Flag1"} Error with request. Response status code: 500 Error while connecting Failed.[TEST] delay(5000)

[@habibCI]

hi, the time of entry should not only be the time but the date too, and the time of return should not only be the time but also the date too, because if when you return home the date is a different day then the data will not be correct in calculating the time.

[@kurtlrnzv_]

hi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?

[@robertotarragojr.7400]

thanks for the vid you created

[@Engineeeeeer6]

You Will Add The Buzzer Also And Plz Add The Lecturer Wise Attendance Means IF The Lecturer Start 10 The Attendance File Only 10 to 10.15 15 Minutes For The Attendance And Then Again Same Process For Next Lecturer

[@saikirang317]

bro, can i save the success message returning from the google sheets and display it on the 16*2 display?

[@saikirang317]

if yes, can u tell me how to do so

[@mohankumarm6366]

Super ahmed its wonderful ❤️🤩

[@AhmadLogs]

Thanks for liking

[@iamtheantony]

Hi Ahmad! Can we add one more feature, like if an employee comes late a message should display on the screen "You are Late"...

[@AhmadLogs]

noted. will add in version 5.

[@iamtheantony]

library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s). getting this warning and no text is showing

[@AhmadLogs]

@@iamtheantony it is not an error it is just warning but the code will work fine. There must be some other issue with your lcd

[@iamtheantony]

@@AhmadLogs thanks it's working, but how can we add buzzer with LCD? as D2 is already connected with LCD

[@AhmadLogs]

@@iamtheantony you can use any unused pin instead of D2

[@احمدنديماسماعيل]

Thank you sir for these useful videos, I enjoyed a lot

[@AhmadLogs]

welcome

[@BukolsGum]

@Ahmad Logs what language you use in this video?

[@GeneralKenobi-mz9ig]

THANK YOU! I’ve been looking for something like this!

[@AhmadLogs]

Enjoy!

[@habibCI]

please check why lcd liquid blank, no text why...

[@labandrick9240]

Where have you been because I have been waiting for part four for a long time I hope you are doing fine.

[@AhmadLogs]

Thank you for your comment and for checking in on me! I took a bit of a break from creating and uploading videos to focus on some personal matters, but I'm back now and excited to start creating content again. Thank you for your support and for being a part of this community!

[@alamgirshikder-q9p]

please make a project including sms alert.

[@woodenhara]

can you show me how to input the data like first name and last name, im kinda new in this kind of thing

[@olemayer2835]

Great work :) Is it possible to ad a keyboard so you can enter a code when you forgot your rfid tag?

[@cmoficenterify]

Regards, very good job, friend. How can I set the time zone of Venezuela? I can't change the time.

[@AhmadLogs]

check version 2 for this, where I have discussed it in detail.

[@cmoficenterify]

ok i solved it, thanks

[@cmoficenterify]

a query, I can add mad additional cards after having already added 5,

[@CoindyRush-vg5ev]

@Ahmad Logs what is the timezone when I'm in the Philippines what is asia/manila? How to input proper time on my current country? Please help me!

[@zkurtdelmo]

Yes asia/manila po

[@CristelBañares]

what are the wires did he use?

[@narutofficial]

Hey Ahmad,,,, in this video you using the esp8266,,,,but im using esp32 for the same project as you,,,,,did you have any code for esp32?

[@shanillajoseph3642]

thank you for this tutorial. I have tried to store data on RFID tags, however the message appears authentification failed. what maybe the possible cause?

[@AhmadLogs]

for writing data on rfid you need to check version 2

[@Trofacir]

hi is this possible if we add faace recognation on this project?

[@johncarlouminga7380]

THANK YOU SO MUCH!

[@tecvishnu]

Nice bro Welcome again...

[@AhmadLogs]

thanks

[@rugvedkoli2003]

Add a keypad and 4x3 keypad and use it for menu navigation and stuff

[@sridharbellala15]

Enter Last Name, ending with # Authentication failed for Write: Timeout in communication. Authentication failed for Read: Timeout in communication. I get error like this,How to overcome this

[@RobertoTarragoJr]

mr. ahmad where is the tutorial on how input data in rfid

[@BrillianceTutorials]

You can do this things in next update. * We can take output of specific student in pdf format. *Send automatically in/out message through whatsapp or sim.

[@AhmadLogs]

definitely I will try to add these features in version 5.

[@BrillianceTutorials]

@@AhmadLogs hey Recently purchased all modules but while uploading the code is shows ('D3' was not declared in this scope) , please help me out

[@AhmadLogs]

@@BrillianceTutorials I think there is not any D3 pin in the code. you must use #define RST_PIN 0, which is the pin D3.

[@BrillianceTutorials]

@@AhmadLogs thanks and fixed this , can we add more data on it , like father name and all , tried it but showing error Bad control character in string literal in JSON at position 64, any other social media handle to contact you .: ) thanks

[@AhmadLogs]

@@BrillianceTutorials check version 3 for more detail. kzbin.info/www/bejne/eJjWkGZ8atd_a7M

[@CoindyRush-vg5ev]

@Ahmad Logs how to change time?

[@RED_esp8266Electronics]

in this project, how to connect to ggole sheet please

[@MRREDDY-ih7wb]

Error compiling for board NodeMCU 1.0 (ESP-12E Module). how to resolve this isssue

[@sensordhanaraj1327]

Current time not displayed sir. What can i do? It displayed only 5 hours late time in and out. Please give a Sugition sir

[@JunayedRafi8]

I want to use esp01 insted of nodemcu please give me tutorial on that

[@Eng-Nabeel2004]

sir yhe attandance output is not showing on google sheets what i do/

[@pika11029]

Sir, how to do this project using esp32

[@Suryabala2009]

sir after scanning the data is not properly storing for example the student is not updating and also the please secify on how to set timezone please reply sir

[@steveopen5524]

Why there is a problem in uploading ?

[@vedantkiduniya2616]

how to ADD buzzer

[@sithiradissanayake3940]

hello sir, how can i modify this code to upload data to a database to create an attendence based mobile. thankyou

[@johncooper5769]

once data is written in tag how to erase the data?

[@jaroncole1088]

Hi Ahmad, I am currently having trouble with the network credentials part. I am trying to use my mobile hotspot on my phone to act as my “Connecting to Wi-Fi” however the connection is not going thru. Do I need a personal home wifi connection or is there a way I may use a private wifi solution, such as my college wifi?

[@AhmadLogs]

In order to connect the ESP8266 to a Wi-Fi network, you need to provide the network credentials (SSID and password) in the code. This network can be a personal home Wi-Fi connection or a public Wi-Fi network, such as your college Wi-Fi, as long as you have the necessary credentials to connect to the network. If you are having trouble connecting to the Wi-Fi network using your mobile hotspot, there are a few things you can try to troubleshoot the issue: 1. Check that your mobile hotspot is turned on and that the network name (SSID) and password are correctly entered in the code. 2. Ensure that the ESP8266 module is within range of the Wi-Fi network and that there are no physical obstacles or interference that could block the signal. 3. Verify that the Wi-Fi network you are trying to connect to is not using any advanced security protocols or network settings that may be incompatible with the ESP8266 module. 4. If you are still unable to connect to the Wi-Fi network using your mobile hotspot, you can try connecting to a different Wi-Fi network, such as a personal home Wi-Fi connection or a public Wi-Fi hotspot.

[@raymondjuballa6570]

Does anyone know how I’d go about adding a solenoid and/or buzzer to this system?

[@AhmadLogs]

I have added a buzzer in version 3. you may check that.

[@zkurtdelmo]

My lcd won't turn on

[@chroma-i4c]

how to correct the time? it's 4 hour advance pls help

[@ganeshgun3102]

can we use moblie hotspot either wifi plz relay soon

[@tbsmcendekia1878]

Hi Ahmad...., great project. still have problem with timezone. i'm from Indonesia, any suggestion to solved this problem?

[@AhmadLogs]

check this davidkeen.com/blog/2017/01/time-zone-conversion-in-google-sheets/

[@MPIComputer6thAttendanceSystem]

sir how to add buzzer sound when a scan card ... please modify your code

[@febrian4361]

how to top up the card?...

[@harshulrathod1548]

super project i really like you

[@AhmadLogs]

thanks

[@harshulrathod1548]

@@AhmadLogs Im very much inspire from this project and i have few questions for the prototype i have build can you help out? Query: how to check particular student_ID using If else block.

[@AhmadLogs]

@@harshulrathod1548 can you give me some more details for your query.

[@BukolsGum]

@Ahmad Logs what's server you use in this RFID v4?

[@AhmadLogs]

please explain a bit

[@Kentir772]

How to connect sim800l to blynk server with nodemcu controller?

[@AhmadLogs]

you need to send http post request from sim800l

[@herypertamax4970]

Can we add a buzzer to indicate that the RFID has been scanned?

[@Projectswithmani]

Yes

[@captan8191]

​@@Projectswithmani give me the code bro

[@zkurtdelmo]

​@@captan8191just use ai

[@ahsanch3009]

i faced this erroe ( library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s).) kindly give solution of it. i follow all step sir

[@ShamimAhmed-rj9kr]

Please also add gsm sim800l in this project to send the attendace time to the employees automatically when they scan an rfid tag.

[@AhmadLogs]

great idea. will add in version 5

[@drabtechs]

i dont have l2c module in my 16*2 display what should i do

[@AhmadLogs]

then you might use SPI

[@nikhilsharma3845]

Sir can you please tell us how to download HTTPSRedirect library

[@AhmadLogs]

I think I have provided the library with the code

[@Manuel24]

Está super genial tu canal, estaria super un proyecto similar pero que puedas denegar el acceso por ejemplo si pagas una membresia mensual y despues de cierta fecha si no pagas que no te de acceso 😮

[@D.E.77]

mejor di que quieres venderlo 😂

[@Manuel24]

@@D.E.77 De hecho realicé uno 😉

[@ethanryanbaclaan2969]

What do i put in Command and Insert_row or Append_row in?

[@AhmadLogs]

nothing to change. just change the sheet name if required

[@protobelt9001]

WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s). This is my current problems, can i ask how to fix it?

[@AhmadLogs]

it is not the issue. it is just a warning and does not cause any issue with the project

[@saikirang317]

@@AhmadLogs its not diplaying anything bro

[@AhmadLogs]

@@saikirang317 just test it with arduino

[@protobelt9001]

@@AhmadLogs can i ask this is my final problem? Reading last data from RFID... Authentication success Block was read successfully Authentication success Block was read successfully Authentication success Block was read successfully Authentication success Block was read successfully Authentication success Block was read successfully Publishing data... {"command": "insert_row", "sheet_name": "Sheet1", "values": ",,,,,Gate1"} Error with request. Response status code: 404 Error while connecting [TEST] delay(5000)

[@AhmadLogs]

@@protobelt9001 let me check. The 404 error told that the resource that you request is not found. it means your sheet url might me wrong

[@steveopen5524]

Is it okay to not use breadboard, just directly connect it ?

[@Projectswithmani]

Yes

[@monika_malhotra]

Error.... **Card Detected** Card UID: 03 5D 9E 0D PICC type: MIFARE 1KB --------------------------------------- Enter Student ID, ending with # Authentication failed for Write: Timeout in communication. Authentication failed for Read: Timeout in communication.

[@phạmcường-n1f]

How do I get the wrong card? It will say wrong card on the lcd

[@CraziMayur]

That's because there is no data on the card

[@sergioestevansuarezdiaz8816]

tambien se puede hacer con un esp32

[@protobelt9001]

hi, can i ask? why i didn't have Board "NodeMCU 1.0 (ESP-12E Module)" at Tools area

[@AhmadLogs]

because you did not install the esp8266 board. so just install the esp8266 board from BoardManager

[@protobelt9001]

@@AhmadLogs this is help me a lot, but this is now my currently problem shows (WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s). What is the problem?

[@AhmadLogs]

@@protobelt9001 this warning message does not necessarily mean that your code will not work. It is possible that the library may work without any issues on your esp8266 board. if you still want to remove this compile warning. You can do it by doing the following: 1. Navigate to your Arduino/libraries/LiquidCrystal_I2C library. 2. Edit the library.properties file with a text editor. 3. Change the architecture line from "architecture=avr" to "architecture=avr,esp8266". If something bad happens, please let me know!

[@PantoaFx]

Thanks ahmad, i will try this for thesis

[@AhmadLogs]

Have fun

[@alamgirshikder-q9p]

Please version 5

[@SaravanaKumar-zo9ne]

Hi Brother How are You, I have one doubt, when out punch is detected i want out date. I mean in time in date and out time out date. Kindly help me Brother

[@Alitolongchannel]

Is this wireless

[@guruchethan4731]

yeah 1st day sheet 1 will store the attendance. if i want to store the 2nd day attendance in sheet 2 and so on.. what should i do

[@AhmadLogs]

just change the sheet name in the script file. I think it will work

[@guruchethan4731]

@@AhmadLogs I need auto update bro... like if day changed , sheet will changed automatically...

[@AhmadLogs]

@@guruchethan4731 hmmmm. will try soon

[@guruchethan4731]

@@AhmadLogs thank you so much 😊

[@narendranr7271]

hi your project is nice but mine say failed try again many times even though i activate the card

[@alexandermarcellino6109]

Hello Ahmad, i already followed all your steps, but i have a problem for the lcd, it doesn't even turning on, can you please help me solve this problem?

[@l.rishipreethdas4043]

Use different library versions , adjust the potentiometer in the back, make sure pins are correct

[@muhammadm1237]

how to change time zone or how to write the corrected time xone

[@muhammadm1237]

@AhmadLogs

[@JamesLee-ub4rm]

hi, I love your video, but could I use arduino uno and NodeMCU V3 at same time? because I use arduino uno with RC522 to perform the lock, at same time, I want to have this google sheets function. How can I fix it? Thank you

[@AhmadLogs]

this project work on internet, but arduino uno cannot connect to the internet itself. so you need to connect esp01 wifi module to the arduino to fix it

[@JamesLee-ub4rm]

@@AhmadLogs oh I see. Thank you to reply my question. I will check your other videos and see what can I learn from you. Thanks 🥇🥇🥇

[@SmartSocket]

i have set time zone to asia/kolkata for india but the time showing is 5:30 hours apart from the actual time what to do next

[@AhmadLogs]

check this for time zone related issues kzbin.info/www/bejne/g2q2lJxqo9iHe80

[@BSCSIV]

Hi, I followed all of your directions, but the only thing I see on the LCD is "Connecting to WiFi." Could you maybe explain why it doesn't want to connect to WiFi? Why is it unable to connect?

[@BSCSIV]

@Ahmad Logs Hi, I followed all of your directions, but the only thing I see on the LCD is "Connecting to WiFi." Could you maybe explain why it doesn't want to connect to WiFi? Why is it unable to connect?

[@zkurtdelmo]

Edit the code. Use your wifi name for ssid and your wifi password

[@Karthik_Mogaveera]

Hello I tried this it works Good, but along with attendance I need to add extra columns for the same row which can store components taken by student (components with separate RFID tag ) is it possible?

[@AhmadLogs]

yes it is possible you need to store the component information in RFID tag. then you append this information in the queryString in sketch file. you also need to update the code for google script

[@Karthik_Mogaveera]

@@AhmadLogs thank you, now I have completed it, can we further make this project such that where to write the information to tag we must use a key pad and write it directly using a switch by changing the program to writing mode, and make it free from all the time going to Arduino ide,?

[@Trofacir]

will you upload rfid plus SD card reader?

[@AhmadLogs]

may be later

[@smartlibrary-z7z]

hello bro i made this project which is working but the data is not publishing am getting failed try again please help

[@pugalendhic2039]

Hi brother I have tested the google sheet url in google brower there comes script not found error would you please solve the error.

[@Proxxyyy.]

can you help me? WARNING: library LiquidCrystal_I2C claims to run on avr architecture(s) and may be incompatible with your current board which runs on esp8266 architecture(s)

[@AhmadLogs]

this WARNING not effect the functionality of the project

[@nextbrainmechâ]

Reading failed: A buffer is not big enough showing in serial monitor and also entering wrong details in gsheets

[@jonathanherston4245]

Ahmad, any interest on developing a system like this for a small work based transportation program so that the scan would capture name, date, time, and location when getting on and off the bus, and calculating the number of miles transported as well as the amount of time each passenger rode? If you are interested, how much would something like that cost?

[@drabtechs]

what if someone give their card to other employee to mark attendence anyyy option for that rather than fingerprint?? ?cameraa??

[@AhmadLogs]

if someone give their card to other employee to mark attendence it is possible. fingerprint or face recognition is better choice if you want make it batter.

[@drabtechs]

@@AhmadLogs can you make something which recognizes face and rfid for attendence ot takes a photo everytime a card scanned

[@AhmadLogs]

@@drabtechs Yes I can make, but I don't have hardware such as esp32 cam or fingerprint module right now

[@AdrianMartinez-t4e]

Has the time out issue been fixed? Great project!

[@AhmadLogs]

Not yet! it is the server side issue. and I did not find any solution for this. it is very complex

[@AdrianMartinez-t4e]

@@AhmadLogs Thank you sir for your great work.

[@guruchethan4731]

can you please do one project , my requirement is rf id receiver should connected with arduino's interrupt pin. if rf id card found it should trigger the controller and do some interrupt function(exit the loop and do the interrupt function and back to the loop and continues the loop function).

[@AhmadLogs]

it is possible.

[@guruchethan4731]

@@AhmadLogs actually I have tried bro. But it will not triggered. Instead of rf id I have used push button. It will work

[@AhmadLogs]

@@guruchethan4731 hmmm. can you share your code?

[@guruchethan4731]

@@AhmadLogs sure bro can I have your social media id?

[@AhmadLogs]

@@guruchethan4731 I have GitHub

[@akydisplay]

❤Dear Ahmed... Make An RGB P10 or P5 Clock... With Arduino UNO... It Is Most Difficult For Most People