FSM System Design for Technical Services

An technical services company struggled to manage customers, installed assets, support tickets, and technician jobs efficiently. Zendesk handled incoming requests, but there was no centralized system to track work orders, assign technicians, or monitor SLA compliance. This caused delayed responses, inefficient technician routing, and poor visibility into service operations.

I designed a lightweight FSM system in Airtable, fully integrated with Zendesk via Zapier. Customers, assets, tickets, and jobs are all structured in linked tables, while technicians and SLA tracking provide operational oversight. Tickets automatically generate jobs when field work is needed, assignments respect skill sets and availability, and SLA formulas flag at-risk tasks. Notifications and updates flow seamlessly between Airtable, Slack, and Zendesk, ensuring teams and customers are always informed.

The solution eliminated manual coordination, reduced missed or delayed service requests, and created a single source of truth for operations. Teams can now track assets, view service history, and assign work intelligently, while leadership gains real-time insights into workload and SLA compliance—all without purchasing a separate FSM platform. This system demonstrates how smart data modeling and automation can replace complex tools with a flexible, scalable workflow.