Web app · 2025
FTC Feedback System
A student feedback portal that replaced a paper suggestion box with a validated form writing straight into a shared spreadsheet.
- Role
- Solo build: interface, front end, submission pipeline
- Stack
- HTML · CSS · JavaScript · Google Apps Script · Google Sheets
- Year
- 2025
- Status
- Built and demonstrated; the Apps Script endpoint exists but the site has no public deployment. Code lives in two public repositories.
Purpose
Feedback at Federal Training Centre, Ikoyi arrived on paper and disappeared into a box. There was no timestamp, no way to sort by topic, and no way to submit anonymously.
What was built
- Custom feedback form with validated, structured inputs
- Client-side submission to a Google Apps Script endpoint
- Live progress indicator while the form is being completed
- Success, error and reset states so the visitor always knows what happened
- Submissions stored in a Google Sheet with timestamps, sortable by staff
Decisions
Zero-infrastructure backend
Apps Script plus Sheets means no server to keep alive and no database to pay for, and the staff already know how to open, sort and filter a spreadsheet. For a school without a technical team, that trade was the right one.
States, not just a submit button
Loading, success, failure and reset were designed up front. The first feedback system of this kind usually fails at exactly that point: the user presses send and nothing tells them whether it worked.
Questions about this project? Email me.