RFID Attendance System using ESP8266 and Google Sheets Version 4
ฝัง
- เผยแพร่เมื่อ 9 มี.ค. 2023
- Looking for an efficient and reliable way to manage attendance in your workplace or organization? Look no further than our RFID Attendance System using ESP8266 and Google Sheets Version 4, which features advanced capabilities including time-in, time-out, and multiple gate entry options.
Using Google Sheets and Nodumcu, our system provides real-time tracking and monitoring of attendance data, making it easy for you to stay on top of attendance management. And with our user-friendly LCD display, checking attendance status is simple and straightforward.
Whether you're a school, business, or any organization in need of a comprehensive attendance management system, our RFID attendance system version 4 is the perfect solution. So why wait? Watch our video now to see just how easy it is to implement this system and streamline your attendance management today!
--------------------------------------------------------------------------------------------------------------------
Parts List
--------------------------------------------------------------------------------------------------------------------
1. NODE MCU - amzn.to/3Zzm1bJ
2. MFRC522 Reader Module - amzn.to/3ytuFMU
3. LCD Display Module 16X2 - amzn.to/3ZTsMET
4. Breadboard - amzn.to/3ysOvHX
5. Jumper Wires - amzn.to/3YRafs5
--------------------------------------------------------------------------------------------------------------------
Useful Video Links
--------------------------------------------------------------------------------------------------------------------
RFID Attendance System Version 3
• Version 3 - RFID Atten...
RFID Attendance System Version 2
• Advanced RFID Based At...
RFID Attendance System Version 1
• RFID Attendance System...
--------------------------------------------------------------------------------------------------------------------
Social Media Links
--------------------------------------------------------------------------------------------------------------------
GitHub:
github.com/ahmadlogs/
TH-cam:
th-cam.com/users/ahmadlogs?sub...
--------------------------------------------------------------------------------------------------------------------
Download Code
--------------------------------------------------------------------------------------------------------------------
github.com/ahmadlogs/rfid-att...
--------------------------------------------------------------------------------------------------------------------
Disclaimer
--------------------------------------------------------------------------------------------------------------------
Disclaimer: All videos are for educational purposes and use them wisely. Any video may have a slight mistake, please take decisions based on your research. This video is not forcing anything on you.
Warning: I will use High Voltages which if incorrectly or improperly used could result in serious injuries or death. So be careful of what you are doing because I will take no responsibility for any of your actions.
Warning: In some countries it is required to register GSM module from govt authorities before using it. So, get proper understanding of govt laws related to GSM technologies.
#nodemcu #rfid #googlesheets
thank you so much, you saved our capstone for research. godbless
شكرا أخ أحمد ،بارك الله فيك، واصل
In the coming days, we hope that this project will be using QR code esp32 cam......thanks
THANK YOU SO MUCH!
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
Thank you sir for these useful videos, I enjoyed a lot
welcome
Very cool Ahmad! I don’t have a project yet for RFID but I’ll think of something.
thanks
Welcome back
Miss your videos
👍👍👍
Thank you for the warm welcome!
Man keep doing this awesome explanation. You did perfect bro
thanks
@@AhmadLogshi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?
@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?
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?
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...
Great work :) Is it possible to ad a keyboard so you can enter a code when you forgot your rfid tag?
THANK YOU! I’ve been looking for something like this!
Enjoy!
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 :))
Thanks for the tips!
Super ahmed its wonderful ❤️🤩
Thanks for liking
Thank you 💝
I will try it.
Love from Bangladesh.
Hope you enjoy
@@AhmadLogs all work fine but time is not working.
In time zone i put "asia/dhaka"
But not match.
What can I do?
@@sohailulhannan you might try to change time zone from google sheet GUI
@@AhmadLogs i changed it.
But still no outcome 😔
@@sohailulhannan hmmmm. have you watched my this video. it might be helpful th-cam.com/video/M9Sci4nsTEk/w-d-xo.html.
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!!
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!
@@AhmadLogs ooh, the pleasure is shared, we learned a lot from you, thank you for being there and with great pleasure
@@kamalkamel7559 thanks a lot
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.
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.
Nice bro
Welcome again...
thanks
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?
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
hi I’d like to ask if you have e another video for this RFID with Facial Recognition as second authentication feature?
Super bro.
Thank you
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.
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 😮
mejor di que quieres venderlo 😂
@@frankespirituvalera8035 De hecho realicé uno 😉
can you show me how to input the data like first name and last name, im kinda new in this kind of thing
@Ahmad Logs what language you use in this video?
please make a project including sms alert.
Add a keypad and 4x3 keypad and use it for menu navigation and stuff
hi is this possible if we add faace recognation on this project?
super project i really like you
thanks
@@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.
@@harshulrathod1548 can you give me some more details for your query.
Where have you been because I have been waiting for part four for a long time I hope you are doing fine.
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!
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
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
sir how to add buzzer sound when a scan card ... please modify your code
I want to use esp01 insted of nodemcu please give me tutorial on that
please check why lcd liquid blank, no text why...
hi your project is nice but mine say failed try again many times even though i activate the card
❤Dear Ahmed...
Make An RGB P10 or P5 Clock...
With Arduino UNO...
It Is Most Difficult For Most People
tambien se puede hacer con un esp32
in this project, how to connect to ggole sheet please
once data is written in tag how to erase the data?
can we use moblie hotspot either wifi
plz relay soon
Error compiling for board NodeMCU 1.0 (ESP-12E Module).
how to resolve this isssue
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?
for writing data on rfid you need to check version 2
what are the wires did he use?
Please also add gsm sim800l in this project to send the attendace time to the employees automatically when they scan an rfid tag.
great idea. will add in version 5
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
@Ahmad Logs how to change time?
Has the time out issue been fixed? Great project!
Not yet! it is the server side issue. and I did not find any solution for this. it is very complex
@@AhmadLogs Thank you sir for your great work.
Thanks ahmad, i will try this for thesis
Have fun
hello sir can you teact me on how to use the lcd
Hi Ahmad...., great project. still have problem with timezone. i'm from Indonesia, any suggestion to solved this problem?
check this
davidkeen.com/blog/2017/01/time-zone-conversion-in-google-sheets/
Please version 5
Can you lend this project for a week ??
I will pay for this .
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.
definitely I will try to add these features in version 5.
@@AhmadLogs hey Recently purchased all modules but while uploading the code is shows ('D3' was not declared in this scope) , please help me out
@@BrillianceTutorials I think there is not any D3 pin in the code. you must use #define RST_PIN 0, which is the pin D3.
@@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
@@BrillianceTutorials check version 3 for more detail. th-cam.com/video/Bgs_3F5rL5Q/w-d-xo.html
sir yhe attandance output is not showing on google sheets what i do/
how to top up the card?...
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)
Hi brother I have tested the google sheet url in google brower there comes script not found error would you please solve the error.
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?
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.
hello bro i made this project which is working but the data is not publishing am getting
failed try again please help
Regards, very good job, friend. How can I set the time zone of Venezuela? I can't change the time.
check version 2 for this, where I have discussed it in detail.
ok i solved it, thanks
a query, I can add mad additional cards after having already added 5,
how to ADD buzzer
Why there is a problem in uploading ?
LCD is not turning on, why?
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
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
@@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 🥇🥇🥇
bro, can i save the success message returning from the google sheets and display it on the 16*2 display?
if yes, can u tell me how to do so
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..
test your lcd separately. There might be some connection issues.
@@AhmadLogs ok sir
Hi Ahmad! Can we add one more feature, like if an employee comes late a message should display on the screen "You are Late"...
noted. will add in version 5.
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
@@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
@@AhmadLogs thanks it's working, but how can we add buzzer with LCD? as D2 is already connected with LCD
@@iamtheantony you can use any unused pin instead of D2
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
Using fingerprint
Dear Vai please help me.
When I punch a card, time deferent 6 hour less in Bangladesh time.
Bangladesh time-18: 25pm
Show-12:25pm
Does anyone know how I’d go about adding a solenoid and/or buzzer to this system?
I have added a buzzer in version 3. you may check that.
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?
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
@@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,?
@Ahmad Logs what's server you use in this RFID v4?
please explain a bit
Reading failed: A buffer is not big enough showing in serial monitor and also entering wrong details in gsheets
How to connect sim800l to blynk server with nodemcu controller?
you need to send http post request from sim800l
hi, can i ask? why i didn't have Board "NodeMCU 1.0 (ESP-12E Module)" at Tools area
because you did not install the esp8266 board. so just install the esp8266 board from BoardManager
@@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?
@@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!
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
just change the sheet name in the script file. I think it will work
@@AhmadLogs
I need auto update bro... like if day changed , sheet will changed automatically...
@@guruchethan4731 hmmmm. will try soon
@@AhmadLogs thank you so much 😊
Is it okay to not use breadboard, just directly connect it ?
Yes
What do i put in Command and Insert_row or Append_row in?
nothing to change. just change the sheet name if required
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
check this for time zone related issues
th-cam.com/video/M9Sci4nsTEk/w-d-xo.html
Thanks for your Video! I'm facing a problem with the code. After publishing the data, I can see it in my Google Sheet, but the loop seems to be stuck. In the Serial Monitor, I can see the JSON payload, but nothing happens after this. Hope you can help!
hmmm. have you installed esp32 core version 2.0.6?
please give me some more detail about the error. check serial monitor for more detail.
@@AhmadLogs In the serial monitor there is nothing after the payload is printted. It does get published, as I can see the data in my Google Sheets, but it seems the POST function is stuck, and doesnt return anything, so the loop doesnt continue.
@@AhmadLogs Hi again, I updated to the newest version of esp32, and it works now! Thanks so much
@@WobbleStoneMedia glad it works
@@WobbleStoneMedia hmmm. I will try to update the code.
My lcd won't turn on
will you upload rfid plus SD card reader?
may be later
@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!
Yes asia/manila po
Sir can you please tell us how to download HTTPSRedirect library
I think I have provided the library with the code
@Ahmad Logs I don't see the esp8266 in latest version of Arduino, how to solve that or I download your version of Arduino in this video so I can find the esp..
1. have you added the esp8266 link in the preferences?
2. What version of IDE you are using?
@@AhmadLogs latest version of ide
@@AhmadLogs how to add esp866?
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)
this WARNING not effect the functionality of the project
serial.serialutil.SerialException: Cannot configure port, something went wrong. Original message: PermissionError(13, 'A device attached to the system is not functioning.', None, 31)
serial.serialutil.SerialException: Cannot configure port, something went wrong. Original message: PermissionError(13, 'A device attached to the system is not functioning.', None, 31)
I'm working on this project, how is it done?
thanks for the tutorial.
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.
i dont have l2c module in my 16*2 display what should i do
then you might use SPI
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).
it is possible.
@@AhmadLogs actually I have tried bro. But it will not triggered. Instead of rf id I have used push button. It will work
@@guruchethan4731 hmmm. can you share your code?
@@AhmadLogs sure bro can I have your social media id?
@@guruchethan4731 I have GitHub
how to change time zone or how to write the corrected time xone
@AhmadLogs
How do I get the wrong card? It will say wrong card on the lcd
That's because there is no data on the card
i have no 8266 but have esp32 dev can you help with pinouts as i have no I2C but dont think i need ?
I think you need to change the entire code. I never tested it for esp23
@@AhmadLogs I will have a go lol.... 🙏
what if someone give their card to other employee to mark attendence anyyy option for that rather than fingerprint?? ?cameraa??
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.
@@AhmadLogs can you make something which recognizes face and rfid for attendence ot takes a photo everytime a card scanned
@@drabtechs Yes I can make, but I don't have hardware such as esp32 cam or fingerprint module right now
Hi,I have problem my led display is not working properly.it is just glowing..
rotate the potentiometer on the back side of the lcd to adjust the contrast.
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?
Use different library versions , adjust the potentiometer in the back, make sure pins are correct
hi Error with request. Response status code: 500
Error while connecting
[TEST] delay(5000) i get this problem can you solve? please
It is a server side issue. just try again it will solve