Turning field tickets into job reports
Context
Each type of field job called for different questions, and the office needed a report based on the technician’s answers.
What I did
- Built reusable ticket templates so administrators could choose the fields and set conditional workflow rules for each job type.
- Built an editor so the API and the Word and PDF exports used the same response data.
- Built offline response bundles with media and signatures that kept the field validation rules.
- Automated dispatch scheduling around travel distance and each technician’s workload, with calendar and route views.
- Added CSV and XLSX import and export with column mapping and validation.
Result
Technicians filled in the ticket for the job, offline when needed, and the office exported those same answers as a Word or PDF report.
Technical detail
Ruby on Rails · React · Stimulus · REST APIs · Word/PDF export · CSV/XLSX · Docker for CI builds