Bangkok University · English Major Student Committee
Five production systems shipped for a student committee — four Google Apps Script tools plus a Next.js and Supabase staff portal — integrating Groq AI, the LINE Messaging API, and automated notifications.
Each one replaced a process that was being done by hand. They are listed in the order they grew in scope — the last consolidated the four before it.
One staff portal replacing four separate spreadsheet systems
Four Apps Script systems had grown up separately, each with its own login, its own spreadsheet, and its own idea of who a committee member was. Staff re-entered the same person into three places, and nobody could answer a question that crossed two systems.
Live coordination dashboard for tour groups moving between stations
Campus tour days were coordinated by walkie-talkie and clipboard. Nobody had a single view of where each group was, which station was backed up, or which group had stopped moving — problems surfaced only after a group was already late.
Barcode-driven stock control for shared committee equipment
Equipment was counted by hand against a paper list at the end of each night. Items went missing without anyone knowing who had borrowed them, and disputes were unresolvable because there was no record.
OTP-verified member registry with an AI automation suite
Committee membership lived in a Google Form response sheet. Duplicate and mistyped entries accumulated, nobody chased inactive members, and answering a question about the roster meant reading the sheet by eye.
QR check-in, waitlists, and a live attendance display
Event sign-in was a printed name list at a door. Queues formed while staff searched pages by hand, walk-ups had no waitlist, and the final attendance figure was transcribed from paper the following day.