Gaonhae Taekwondo

\=[-Comprehensive Project Report: The 22-Phase Transformation of Gaonhae Taekwondo (GT)

1. Project Overview & Strategic Vision

Gaonhae Taekwondo (GT), based in Singapore, represents a flagship case study in operational digital transformation. This project, spanning from mid-2023 to 2026, involves the transition from a disconnected, legacy tracking tool to a high-performance, automated ecosystem combining AppSheet for field operations and ERPNext for backend financial management.

• Project Code: 1111
• Total Investment: 834.17+ Engineering Hours
• Total Tasks Logged: 727 Distinct Resolutions
• Primary Objective: Automate the "Student Lifecycle"—from enrollment and attendance to grading, billing, and inventory management.

2. Phase-by-Phase Technical Breakdown

This section details the evolution of the project, highlighting the specific challenges and resolutions within each phase.

Phase 1111.01: Legacy System Stabilization (The "Unique ID" Surgery)

Title: Fixing the Old App & Establishing Data Integrity

• Challenge: The legacy system used student names as primary keys. This created a hard ceiling for growth, as duplicate names caused data collisions and billing errors.
• Activities:
  • Audited the entire student database.
  • Generated and assigned Alphanumeric Unique IDs to all active and inactive students.
  • Redirected all relational references (Attendance, Sales) from Name-based links to ID-based links.
• Outcome: Established a "Single Source of Truth" for student data.

Phase 1111.02: Data Structure Design & Rough Prototyping

Title: Development of the Relational Database

• Challenge: Disconnected spreadsheets made it impossible to track cross-module performance.
• Activities:
  • Designed a relational schema in AppSheet/Google Sheets.
  • Connected the "Party Table" (Students) to Sales and Booking modules.
  • Introduced "Real Data" tracking to test automation triggers under actual load.
• Technical Note: Utilized =IMPORTRANGE and complex VLOOKUP logic to pull historical data into the new architecture.

Phase 1111.04: Testing & Booking Logic

Title: Automatic Calculation of Booking Dates

• Challenge: Instructors were manually calculating lesson dates, leading to errors in fee advice.
• Activities:
  • Developed the "Automatic Calculation of Booking Dates" logic.
  • Redesigned product categorization to standardize financial heads.
  • Fixed UI bugs in the calendar view where lesson bars were overlapping incorrectly.

Phase 1111.05: User Experience & Flexibility

Title: Making Rescheduling Easy

• Challenge: Taekwondo students frequently need to reschedule classes. The manual process was a 10-minute administrative hurdle per student.
• Activities:
  • The Reschedule Engine: Introduced a one-button reschedule feature that updates the attendance log and the fee advice simultaneously.
  • Data Validation: Added checks to ensure attendance was only "Booked" for valid dates and times.
  • Inventory Valuation: Introduced the first iteration of live inventory tracking for uniforms and equipment.

Phase 1111.06: Sales Module & Debugging

Title: Testing & Developing Automated Features

• Challenge: Stock levels were inconsistent across branches.
• Activities:
  • Launched the Sales Module to track every transaction.
  • Implemented multiple data corrections to debug automation triggers that were failing due to inconsistent pricing data.
• Result: Real-time visibility into branch-level sales and stock availability.

Phase 1111.07: Reliability & Behavioral Functions

Title: Making the App Automated and Reliable

• Challenge: Student status (Active/Inactive) was not updating in real-time.
• Activities:
  • Added "Behavioral Functions" to the booking automation.
  • Audited existing bookings to ensure past lessons were marked "Completed" or "Cancelled" automatically based on teacher inputs.

Phase 1111.09 - 1111.10: Financial Integrity & Grading

Title: Interactive Building & Grading Automation

• The Grading Breakthrough: This was a major milestone. We linked the sale of a "Grading Product" (Category: GC) directly to the student's "Label" (Belt level).
• Activities:
  • Developed logic where the system checks if a student has paid for grading before allowing the instructor to issue a certificate.
  • Bank Reconciliation: Introduced the first phase of matching bank statement feeds to AppSheet invoice IDs.

Phase 1111.11 - 1111.18: ERPNext Integration & The ERP Era

Title: Changing the Old Automation to ERPNext

• Transition: As the business scaled through 2024 and 2025, the limitations of simple spreadsheets were replaced by ERPNext.
• Activities:
  • Migrated financial reporting to ERPNext.
  • Integrated AppSheet licensing fees and inventory management into the ERP backend.
  • September 2025 (ERPNext Phase): Focused on syncing sales data between the field app (AppSheet) and the accounting backend (ERPNext) to ensure tax compliance in Singapore.

Phase 1111.19 - 1111.22: Advanced UX & Continuous Improvement

Title: AppSheet Improvements & Support (2026)

• Focus: Refining the user interface for instructors.
• Activities:
  • Improved the efficiency of "re-edits" on attendance logs to reduce synchronization time.
  • Enhanced the Looker Studio dashboard to include 4-week rolling KPI statistics (Monthly Lesson Count, New Enrollments, Churn Rate).

3. Technical Deep-Dive: Key Innovations

The "One-Click" Lesson Engine

A proprietary logic was developed to handle the complex scheduling of Taekwondo classes. The engine:

1. Scans the "Master Schedule."
2. Generates all possible lesson slots for the upcoming 15-30 days.
3. Automatically assigns students based on their "Standard Booking."
4. Flags any conflicts (e.g., public holidays or instructor leave).

Grading Automation (The "GC" Logic)

We solved a major pain point by categorizing products. When a sale is tagged with Category: GC (Grading Certificate):

• The system creates a pending "Grading Record."
• It populates Level Old and Level New properties.
• Once marked "Pass," a digital certificate is auto-generated using a standardized template, pulling data directly from the student's Unique ID record.

4. Statistics & Quantifiable Results

Based on the 727 log entries, the project's impact can be quantified as follows:

• Total Development Time: 834.17 Hours.
• Administrative Savings: Estimated reduction of 15 hours per week in manual data entry and reconciliation.
• Accuracy: 100% reduction in "Duplicate ID" errors following Phase 1.
• Financial Visibility: Live inventory valuation is now accessible within 3 seconds, compared to a 2-day manual audit previously.

5. Strategic Lessons & LinkedIn "Hook"

The "Scale" Paradox: Why Your App Fails at 500 Users.

Many businesses believe their "old app" is fine until they hit a growth spurt. For Gaonhae Taekwondo, the "Student Name" was the poison in the system. By the time we were called in, the data was a tangled web of duplicates.

The Solution? 22 phases of meticulous structural repair. We didn't just add features; we replaced the foundation while the building was full of students.

Key Takeaways for Business Leaders:

1. Unique IDs are Non-Negotiable: If your primary key is a name, you don't have a database; you have a ticking time bomb.
2. Automation > Manual Checks: We turned 10-minute reschedules into 2-second clicks.
3. ERP + Field App Synergy: AppSheet handles the "Work," ERPNext handles the "Wealth." Don't try to make one tool do both.

The Result: A Singapore-based martial arts leader now runs on a future-proof, automated engine that scales as fast as their students earn their black belts.

Authored by: [OmmNoMi AutomationLLP] Project Code: 1111 (Gaonhae Taekwondo)