Skip to Content

Attendance Management System (AMS)

Attendance Management System (AMS)

AMS is a web-based platform designed to help you efficiently manage student attendance using Google Sheets for secure and scalable data storage. Below you'll find a comprehensive overview of every major feature and exactly how each part works for you.

Sign Up

  • You register by providing your email, department, semester, and the Google Sheet ID where your attendance will be kept.
  • Important: Before signing up, open your Google Sheet, click "Share", and add hubattendance@gmail.com as Editor.
  • The system checks if it can access your sheet. If not, you'll see a warning message and get instructions to share the sheet first.
  • Your account is securely protected using password hashing and stored in a master Google Sheet.

Login

  • Once registered, you log in using your email and password.
  • All passwords are securely hashed and stored.
  • On successful login, you’re redirected to your personalized dashboard.

First-Time Student Addition

  • After your first login, you need to add your list of students.
  • This is a one-time setup: simply enter each student's enrollment number and name.
  • Once you save your students, your roster is ready for marking attendance.
  • You can always edit your list later if needed, but the initial setup only needs to be done once.

Forgot Password

  • If you forget your password, use the "Forgot Password" option on the login screen.
  • Enter your registered email, and you'll receive a reset token in your inbox.
  • Enter the token and a new password to reset your credentials and regain access.

Dashboard

  • After login (and after you’ve added students for the first time), the dashboard displays your department and semester for easy reference.
  • You can view your student list, manage attendance records, and access all major features in one place.
  • All important actions are confirmed with clear, centered pop-up messages.

Edit Students Button

  • The Edit Students button lets you update your student roster.

  • Clicking this switches your dashboard to edit mode:

    • You’ll see all students listed with editable fields for enrollment number and name.
    • You can change details, remove students with the Remove button, or add new students with the + Add Student button.

Save Students Button

  • After editing, click the Save Students button to update your list.
  • The system validates your entries and saves your new list.
  • You'll see a centered pop-up confirming your changes, and the dashboard returns to view mode with your updated students.

Students Management

  • Easily add new students, update details, or remove students no longer in your class.
  • Your student list is private and only accessible by you.

Attendance Management

  • Mark each student as Present or Absent for any date directly from the dashboard.
  • Attendance records are instantly saved to your connected Google Sheet.
  • Filter and search attendance by enrollment number or status (Present/Absent) for quick access to specific records.

Security

  • All sensitive actions (login, password reset, saving data) use secure storage and password hashing.
  • Sheet access is checked automatically to keep your data safe.

Technology Stack

  • Frontend: HTML, CSS, JavaScript with animated RGB borders and centered pop-ups for a modern user experience.
  • Backend: Google Apps Script and Google Sheets for scalable, real-time data storage.

Special Notes

  • All main pages feature an animated RGB border for an engaging, modern interface.
  • Pop-up messages are always centered to make sure you see important updates.
  • You must share your Google Sheet with hubattendance@gmail.com as Editor for attendance tracking to work.

How to Use

  1. Prepare Your Google Sheet: Create a new Google Sheet and share it with hubattendance@gmail.com as Editor.
  2. Sign Up: Enter your details and the Google Sheet ID to create your account.
  3. Log In: On your first login, add your list of students (this only needs to be done once).
  4. Dashboard: Start marking attendance, manage your students, and use all features.
  5. Forgot Password: If needed, recover your account using the secure reset process.
  6. Efficient Attendance Tracking: Easily manage and review your students' attendance, all safely stored in Google Sheets.

APK Download link 👉  AMS Download now