Jonathan Talbot

Project Case Studies &
Previous Client Successes

View some of the previous work we’ve done that excelled our clients’ business operations

Custom Fitness Studio ERP

01 PROJECT GOALS

  • Replace fragmented apps, spreadsheets, and manual processes with a single ERP

  • Centralize company-wide operations for employees, instructors, and leadership

  • Automate repetitive workflows (subs, requests, expenses, reviews)

  • Improve transparency and access to documentation, customer info, and performance data

02 PROJECT DETAILS

I designed and built a custom ERP system in Airtable for b.cycle, consolidating dozens of tools and processes into one connected platform. The ERP covered every aspect of the business, including:

  • Project Management: A fully-fledged project tracker for internal initiatives.

  • HR & People Ops: Hiring, onboarding, raise management, evaluations, and newsletter tracking.

  • Events Management: Centralized event planning and execution tracking.

  • Documentation & Knowledge Base: FAQ + internal documentation hub, replacing standalone apps.

  • Password Management: Airtable base serving as a secure replacement for external password apps.

  • Customer Tracking: Unified client database showing all requests, tickets, and interactions.

  • Operations & Ticketing: Studio issues, bike issues, and other tickets logged and tracked to resolution.

  • Classes & Instructors: Private class management, instructor ratings aggregated from ZingFit + Google Reviews, and an instructor portal.

  • Subs Portal: Automated substitute instructor system with a point-based workflow to manage requests and fairness.

  • Finance: Expense management base with approval and tracking features.

The ERP connected employees, instructors, and leadership in one environment, eliminating silos and scattered tools. Tasks that previously required multiple apps or manual coordination were automated within Airtable and surfaced in dashboards.

03 TOOLS USED

04 PROJECT OUTCOME

  • Consolidated 10+ functions (projects, HR, events, docs, tickets, expenses) into one ERP

  • Eliminated dependency on multiple third-party apps (password manager, documentation tool, ticketing software)

  • Automated substitution requests and point tracking for instructors

  • Improved HR processes: hiring, onboarding, evaluations, and raises fully tracked in one place

  • Gave leadership access to real-time visibility across projects, finances, and operations

  • Freed staff and instructors from manual, repetitive workflows, improving overall efficiency


Built a full Airtable ERP centralizing projects, HR, events, clients, tickets, instructors, and finance.

Discover more from Jonathan Talbot

Subscribe now to keep reading and get access to the full archive.

Continue reading