NUS Climbing Club Attendance Tracker

Interaction only via Telegram Bot

Description

This application was created to help the club semi-automate tracking of member's attendances.

Members are required to scan the QR codes at USC / UTown and key in their NUSNET ID minimally (as that is the key value we are using to update their attendance).

Example

There are 2 functions on the Telegram Bot, Generating weekly attendance sheets and Updating of attendances.

Creating a new week's attendance sheet

User will run the generate command as instructed by the bot, and the application will duplicate the template sheet and populate the weekly information respectively.

Command :

Template :

Generated Sheet :

Updating week's attendance [Incomplete]

The weekly attendance sheet is supposed to be updated to the master attendance sheet on a weekly basis. However due to time constraints, the functionality has not been completed yet.

Command :

Master Attendance Sheet :

Support

Please contact Matthew if you face any issues.

API

This project was created with NodeJs, ExpressJs, Heroku and the Google Sheets API
Google Sheets API Wrapper : node google-spreadsheet

Making Changes

git add .
git commit -m "message"
git push heroku main
git push