TR
Backend & Systems

Gym membership & measurement tracking system

I took over a simple QR membership app a developer friend at the gym had built with Google Apps Script and turned it into a real system. This was my first real contact with backend, databases, and system design.

Google Apps ScriptGoogle SheetsQR

How it works

The start

My friend's first version was a very basic MVP: at a fair, a customer scanned a QR, entered their name, and saw how long was left on their membership. He walked me through the JavaScript-based logic and said, 'here, play with this.'

What I built

By playing with it, I turned it into a system. A trainer enters a member's photo, measurements, and details through a single Google Form; everything lands in a Sheets-backed table. The member scans the QR at the gym, and on the page that opens they enter their phone number to see their own membership status and past measurements, comparing, say, September and October.

What I learned

This is where I first learned what backend is and concepts like databases. Turning an idea into an end-to-end system, my system-design journey, began right here.

Let's work together →