Arduino IDE + ESP32 + RFID RC522 + Google Sheets | RFID Simple Attendance System ESP32 Google Sheets
ฝัง
- เผยแพร่เมื่อ 26 พ.ค. 2024
- ***********************************************
Follow and contact me on Instagram : / utehstr
***********************************************
ARDUINO IDE + ESP32 + RFID RC522 Module + Google Sheets (Google Spreadsheet).
Starting RFID-RC522 with ESP32 and Arduino IDE.
Simple attendance system with ESP32, RFID-RC522 and Google Sheets.
Software used :
- Arduino IDE (V1.8.9).
- Arduino Core for The ESP32 (V1.0.6).
- Notepad++ (V8.4.6).
Arduino libraries used :
- MFRC522 by GithubCommunity (V1.4.3)
- LiquidCrystal_I2C (V1.1.4)
Hardware used :
- ESP32 DEVKIT V1.
- RFID RC522 Module.
- LCD 20x4 I2C.
- Tactile Push Button.
- And other equipment such as cables and others.
Timestamp :
00:00 Opening
00:32 Project Preview
02:01 Modules and components used to create this project
02:37 Installation image
02:49 Step 1 - Created Google Sheets Projects and Google Apps Script Projects
03:40 Step 1 - Google Sheets Projects ID
06:18 Step 1 - Google Apps Script (Code)
07:49 Step 1 - Google Apps Script (Deploy)
08:39 Step 1 - Google Apps Script (Web App URL)
08:57 Step 1 - Google Apps Script (Web App URL Test)
10:53 Step 2 - Test the RFID RC522 installation (Code)
11:32 Step 2 - Installed the MFRC522 library
12:43 Step 2 - Test the RFID RC522 installation (Demo)
13:01 Step 3 - Test the LCD 20x4 I2C and Button installation (Code)
13:45 Step 3 - Downloading the LiquidCrystal_I2C library file
14:16 Step 3 - Installed the LiquidCrystal_I2C library
14:55 Step 3 - Test the LCD 20x4 I2C and Button installation (Demo)
15:24 Step 4 - Simple attendance system (Code)
17:37 Step 4 - Simple attendance system (Demo)
24:27 Closing
***********************************************
Download Arduino Code and other files : drive.google.com/file/d/14gRP...
The code file is saved in the .rar file format. I created a .rar file using Winrar V5.50, so to extract it, make sure you use the same version of Winrar that I use or the latest version or use the winrar extractor online.
***********************************************
SORRY IF MY ENGLISH IS CONFUSING, I USE AN ONLINE TRANSLATOR.
THANKS FOR WATCHING & DON'T FORGET TO LIKE , SHARE, COMMENT AND SUBSCRIBE.
***********************************************
For other video tutorials on this channel, please see this playlist:
- Basic4Android (B4A) Tutorials : • Basic4Android (B4A) | ...
- Electronics Tutorials : • 3 LED Flip Flop
- Arduino Tutorials : • Arduino | Scrolling Te...
- Great Cow Basic Tutorials : • Great Cow BASIC with A...
- Bascom Avr Tutorials : • Bascom Avr | How to Se...
- VB .NET Tutorials : • Visual Basic .NET | ...
- LoLin NodeMCU V3 ESP12E ESP8266 Tutorials : • Arduino | LoLin NodeMC...
- ESP32 Tutorials : • Arduino IDE + ESP32 | ...
- ESP32 CAM Tutorials : • Arduino IDE + ESP32 Ca...
***********************************************
***********************************************
- Download Arduino IDE : www.arduino.cc/en/Main/Software
- Download Notepad++ : notepad-plus-plus.org/downloads/
***********************************************
***********************************************
Reference :
- RFID Attendance System using ESP8266 and Google Sheets Version 4 : • RFID Attendance System...
- rfid attendance v4 : github.com/ahmadlogs/rfid-att...
- IoT based RFID Attendance system using ESP8266 and Google sheet : • IoT based RFID Attenda...
- RFID RC522 Interfacing with ESP32 : www.electronicwings.com/esp32...
- How to Find the Last Row of A Single Column in Google Sheets in Apps Script : www.jsowl.com/find-the-last-r...
- ESP32 HTTP GET and HTTP POST with Arduino IDE : randomnerdtutorials.com/esp32...
- RFID RC522 Interfacing with ESP32 : www.electronicwings.com/esp32...
- esp32io.com/tutorials/esp32-r...
- stackoverflow.com/a/29546373
- stackoverflow.com/questions/2...
- stackoverflow.com/a/71341868
- stackoverflow.com/questions/1...
and from several other sources.
*********************************************** - วิทยาศาสตร์และเทคโนโลยี
in a tactile push down switch, there are usually 4 legs or 4 pins, how did you interfaced with esp32, which 2 pins did you used ?
I love your lessons. You answer every request. Love to you.
Thank you 👍🙂
I need help, this project was interesting but I want to do it without a screen and without a button, how could I adapt it to make it functional?
Any suggestion to disable today's record. I need to get multiple times in a day for a user.
''You have completed your attendance record for today (Time In and Time Out have been ///filled in for today).''
Can I ask/ It gives out a question mark instead...? When testing the RFID reader, it gives a question mark.
thank you soo much man,,, only thing i didnt have is the External push button,,, its ok i did change the BTN_PIN to 0 and its works well too,,, thank you soo much
You're welcome 👍🙂
hi i have problem with the web url it say error evertime and it say 'The script completed but did not return anything.' please help
Wow awesome, you can add a tab to give permission to open the door , like making that card Enable or disable in the sheet ,👍
As the title of this video implies, this project is a SIMPLE ATTENDANCE SYSTEM project. For other features, you can develop based on your ideas 🙂.
I try to do same with your code but it shows library WiFi.h is not available . Can you help me with this.
Hello sir, can you edit the code to have an available slots? Your video is similar to my needs. Very much appreciated thank you sir!
May i know what is the circuit connections of this project when i combine RFID and Fingerprint which means two Identification before the attendance being recorded in excel and what is the source code pls tq (doing this for my final year project)
Can i use Arduino Uno R3 or i need to use Arduino mega 2560?
udah ngikutin tinggal code terakhir, baru sadar codenya buat esp32 bukan 8266 wkwk tapi makasih pak, sangat bermanfaat 😅😉
👍🙂
I made this attendance system. All are perfectly working just 1 issue no text is visible on the screen (PLease help me). Otherwise Awesome! You're great. Thanks!
in the "02_Test_RFID-RC522_LCD-20x4_Button" section, is there a display on the LCD?
@@utehstr No, there is no display. Only the light is on on the LCD.
I noticed something: The chip on top of the LCD has a different IC number than the one you image provided. Does it make any sense?
@@mjhkhan705 Have you adjusted the potentiometer on the LCD?
would be great if the system could do multiple log ins and log outs in a day. Time stamping also need to be fixed.
You can develop it according to what you want.
you did it?
i have changed the time zone accoreding to my location in google script code but it is not changed and still following the Asia/Jarkata timezone please provide the solution quikly becuase it is my final year project submission date is not much away
You must change on that google script and make a new deploy,after that reuploud the code on arduino ide
How to change Malaysia Zone?
How to duplicate data in same days?
we can register only 10 rfids ,After 10 entry registration is disabled ,how to solve this issue?we need increase the registraton up to 60,
Do you solve it?
I followed the steps as you instructed but my RFID can't receive the UID
Looking forward to your help,plz
As you can see in the video that everything is going well. I don't know how you did it, so what I can suggest is to watch the video again because maybe you missed something.
@@utehstr can you help me with the problem of why when I use RFID and put the data on google sheet and it gives an error like this 'OK,atcErr01' how to solve that problem, I'm sure I did the same steps as you. I thank you for reading.
@@nguyenlemintruong6604 Watch at 23:39
can i make it portable if i add power supply? i dont want it to connect with laptop. can i do that?
Yes of course.
@@utehstr can i just use powerbank?
I could not open my that files
❤❤❤
👍🙂
bg pas test kode "02_Test_RFID-RC522_LCD-20x4_Button" lcdnya nyala doang gk nampilin textnya
Periksa kabelnya, pastikan terhubung dengan baik. Kemudian coba atur potensio yang ada pada modul lcd-nya.
keren coba di combine pake wablas habis absen lalu auto send whatsapp ke orang tua murid
I could not open those files
How to prevent duplicate data in same days?
Watch the video until the end or watch the demo section, I designed the program code or system so that there is no duplication on the same day.
@@utehstr thanks sir . Worked for me
@@April2023-fb6pf You're welcome 🙂
WARNING: Category '' in library ESP Insights is not valid. Setting to 'Uncategorized'
WARNING: Category '' in library ESP RainMaker is not valid. Setting to 'Uncategorized'
WARNING: Category '' in library WiFiProv is not valid. Setting to 'Uncategorized'
??