Ben's Gutters Ltd

Ben's Gutters had been running their sales process through an Access-based form for years. It worked, but it was showing its age — and their sales team had no access to the real-time location data that could help them give customers better information and a more efficient service at the point of sale.

They came to us wanting a modern replacement that kept the familiarity of the existing workflow while adding something genuinely new: a live, interactive map embedded directly into the sales interface.

What We Built

We designed and built a web application that combines the customer sales form and map data into one unified interface. The brief required us to closely replicate the behaviour of the existing Access form — so the team wouldn't have to relearn their workflow — while delivering a significantly improved experience for both staff and customers.

The interactive map was the most technically interesting part of the project. It pulls together several data sources into a single view:

• Pins plotting the position of each customer job
• Different pin shapes indicating the type of job
• Colour-coded pins showing the day of each job
• Coloured area overlays indicating the next available booking slot for each zone
• Area notes visible on the map
• Live location tracking for each technician in the field

All of this updates in real time, pulling from a third-party REST API and the Google Maps JavaScript API. The result is a sales tool that gives the team an at-a-glance picture of their entire operation while they're on a call with a customer.

The application is hosted on an Ubuntu server running on-premises, in line with the client's existing infrastructure preferences.