Shift handover for bus operations, in SharePoint

A SharePoint and Teams app where bus supervisors log service problems and hand over each shift.

The handover overview on a laptop: open bus cases, a timeline of the operating day and a list of what needs action, all invented test data for an imaginary bus company.

Status: Private copy, filmed on test data
Runs on: SharePoint, Teams, TypeScript
Data: Invented companies and test data

Opening frame of the trailer for Shift handover for bus operations, in SharePoint.

The problem

Supervisors at Linden Coaches (an invented bus company) tracked disruptions across an HTML draft, an Excel sheet and a PDF duty plan. Cases, the trips they hit and the handover between shifts had no shared place.

What I built

A SharePoint app on four lists: cases, affected trips, timetable and handovers. Type a duty number to get its garage and the day's trips. It has a desktop and a phone design, runs as a Teams app too, and has a lists-only version that needs no IT department.

A case opened beside the list on a laptop, showing its status, owner, next action and the delayed trips it affects, with invented test data.

The same overview on a phone, with the day summary and the first overdue cases, using invented test data.

What it changed

Runs in a private test tenant and in Teams, now on invented data. The timetable import turned 123 duty plan PDFs into 6,214 rows, checked by hand on two duties. The client chose its existing Monday.com instead, so this version was not rolled out.

Tell me what you want to automate.

Send me a message