case://study-012
Web App
Back to Work
Project 012

China Global Study CRM

An internal student-placement CRM built for China Global Study, the parent agency behind CGS Language Services. Next.js 16 + Supabase, an 8-stage kanban that drag-and-drops applicants between funnel stages (initial enquiry → document collection → translation → application → admission → visa → departure → enrolled), 5 themes, and a clean role-gated authentication model. Built as a freelance commission and running in production.

Try the live demo Source on GitHub
8
Funnel Stages
5
Themes
Production
Status
Web App
Category
The Problem

What Wasn't Working

Student-placement agencies live in spreadsheets — every applicant means one tab, every stage transition means a manual cell update, and a missed deadline can mean a student loses their visa window.

The Solution

How I Fixed It

An 8-stage drag-and-drop kanban that turns the agency's actual workflow into a visible pipeline. Supabase backs the data, Next.js 16 renders the UI server-side, five themes let the agency match the look to client-presentation contexts.

Stack

Technologies Used

Next.js 16
Supabase
TypeScript
DnD Kit
Framer Motion
Results

Key Outcomes

✓
Replaced a multi-tab spreadsheet workflow with a single pipeline view
✓
Drag-and-drop stage transitions with optimistic UI
✓
Freelance client work — in production for the agency

Want something like this?

Let's build it. I ship fast and I ship clean.

Try LiveView CodeHire Me