Skip to content

Latest commit

 

History

History
57 lines (31 loc) · 1.94 KB

File metadata and controls

57 lines (31 loc) · 1.94 KB

Daily Attendance System

This project automates the process of recording daily attendance in a Google Sheets document. Teachers or users can submit their in-time and out-time through a web interface, and the attendance details are updated in the Google Sheets.

Google Apps Script (JavaScript Code)

Usage

Google Sheets Setup:

  1. Create a Google Sheets document with the necessary columns (e.g., ID, In Time, Out Time).

Google Apps Script:

  1. Copy and paste the contents of DailyAttendance.gs into the Google Apps Script editor.
  2. Save the script.

Deploy as Web App:

  1. In the Google Apps Script editor, go to Publish > Deploy as web app...
  2. Choose a version and set access to "Anyone, even anonymous."
  3. Click "Deploy."

Get the Web App URL:

  1. After deploying, you'll get a URL for the web app. Use this URL in your MIT App Inventor project.

MIT App Inventor Project

Import the Project:

  1. Import the AttendanceApp.aia file into your MIT App Inventor.

UI Components:

  1. Set up the necessary UI components (e.g., text boxes, buttons).

Web Component:

  1. Use the Web component to make POST requests to the web app URL obtained from the Google Apps Script.

Usage:

  • Users can input their attendance details using the MIT App Inventor app.
  • The Google Apps Script updates the Google Sheets document with the provided information.

Modified Version - Teacher Attendance App

Check the modified version in this repository link.

Related Repositories

Acknowledgments

Inspired by the need for a simple daily attendance system.