Sistem Absensi Online Menggunakan kartu RFID

Summary

This tutorial demonstrates how to create an RFID-based attendance system using NodeMCU and Google Sheets. The video covers the components needed, including the NodeMCU, RFID module, and LCD, and guides viewers through the wiring process. It walks through the setup of the Arduino IDE to program the NodeMCU, allowing it to read RFID cards and upload attendance data to Google Sheets. The tutorial includes detailed instructions on setting up the spreadsheet, configuring Google Apps Script, and testing the system by scanning RFID cards. By the end, viewers will have a fully functional attendance system integrated with Google Sheets.

Takeaways

• 😀 The project demonstrates how to create an RFID-based attendance system using NodeMCU and Google Sheets integration.
• 😀 Hardware components required include NodeMCU, RFID module, 3 RFID cards, LCD I2C display, a buzzer, jumper wires, and USB cables.
• 😀 Wiring the components involves connecting the RFID module to NodeMCU and setting up the LCD I2C display for communication.
• 😀 The RFID module uses 7 key pins (SDA, SCK, MISO, MOSI, RST, GND, 3.3V) for connection with NodeMCU.
• 😀 The LCD I2C connections are made with the SCL pin to D1, SDA pin to D2, VCC to 3.3V, and GND to GND on NodeMCU.
• 😀 The buzzer is connected to the D0 pin for positive leg and GND for the negative leg.
• 😀 The first step in programming is to register RFID cards by scanning them and assigning user details like name, gender, and faculty.
• 😀 Google Sheets is used to store attendance data, with columns for date, time, name, faculty, and gender.
• 😀 Google Apps Script is used to link NodeMCU with Google Sheets and enable the automatic data entry process.
• 😀 The code on NodeMCU reads the RFID card data, fetches the timestamp, and sends it directly to Google Sheets for real-time updates.
• 😀 The system is tested by scanning RFID cards, ensuring that the attendance data appears in the Google Sheet correctly, including the date and time.

Q & A

What components are used to build the RFID-based attendance system?

The components used include a NodeMCU, two breadboards, an RFID module, three RFID cards, an LCD with I2C interface, a buzzer, jumper cables, and a USB cable.

How is the RFID module connected to the NodeMCU?

The RFID module is connected using seven pins: SDA, SCK, MOSI, MISO, GND, RST, and 3.3V. The IRQ pin is not used.

What is the purpose of the LCD display in the system?

The LCD display shows information, including the status of the system and possibly the attendance data. It is connected via the I2C interface for easier wiring and communication.

How are the RFID cards programmed with user data?

To program the RFID cards, first, the user connects the NodeMCU to the computer, resets it, and scans each card. The user then inputs the associated data such as name, gender, and faculty, ending with the hashtag symbol (#).

What software is used to program the NodeMCU?

The NodeMCU is programmed using the Arduino IDE, where the necessary libraries are imported, and code is uploaded to the device.

How is the Google Spreadsheet set up to receive data?

The Google Spreadsheet is prepared by creating columns for date, time, name, faculty, program of study, and gender. Google Apps Script is used to link the spreadsheet with the NodeMCU, allowing it to automatically input data when a card is scanned.

What is the role of the Google Apps Script in the system?

The Google Apps Script is used to integrate the Google Spreadsheet with the NodeMCU. It handles receiving data from the NodeMCU and updating the spreadsheet accordingly. The script needs to be deployed with the correct ID and timezone.

How does the system send data to Google Spreadsheet after scanning an RFID card?

After scanning an RFID card, the NodeMCU connects to Wi-Fi, communicates with the Google Spreadsheet, and sends data (like the name and timestamp) to the corresponding spreadsheet columns.

What should be done if the LCD display shows no information?

If the LCD display does not show any information, it's often due to the potentiometer on the back of the LCD not being adjusted. It should be rotated using a screwdriver to ensure the display is visible.

What happens when a card is scanned successfully?

When a card is scanned successfully, the system records the attendance by inserting the corresponding data (such as name, date, and time) into the Google Spreadsheet, visible in real-time.