Back to Case Studies

CASE STUDY
BIOTRADE

Client

BIOTRADE

Industry

Heating and Energy Solutions

Product

Web app and automation

Date

September 2024

Skills

Airtable Database

Airtable Automations

Airtable Interfaces

Local Caddie: how it works
2 days
Implementation time
text image
About Client
Ecological Heating Products delivers high-quality, eco-friendly heating solutions, driven by sustainable practices and a Zero Waste philosophy. Deeply committed to community support through sponsorships and charity work, they also expand internationally, building a strong reputation for excellence. Recognized across Europe and beyond, their products are synonymous with quality, while strategic partnerships enable them to meet diverse environmental standards and lead innovation in sustainable heating solutions worldwide.
About the project

The project aimed to develop a web application specifically designed to meet the client’s logistical and operational needs. The application’s functionality was created to enable efficient tracking and management of essential data for each vehicle in the fleet, centralizing information in a single, accessible platform. Key features were also introduced to automate notifications, ensuring that employees and relevant external partners receive timely updates regarding vehicle maintenance and compliance requirements. This solution was designed to streamline workflows, enhance data accuracy, and improve overall operational efficiency across the company’s logistics processes.

Clients Problem

The client encountered a major challenge in managing a large fleet of vehicles, each requiring careful attention to technical inspections, scheduled maintenance, and insurance renewals.

Keeping track of inspection and maintenance deadlines was complex, as any missed appointment could lead to vehicle downtime, potentially disrupting transport schedules and delaying product deliveries to customers. Additionally, with vehicles insured through multiple providers, maintaining valid insurance policies required noting down each provider’s details and remembering to reach out for renewals.

Without a centralized system to track and automate reminders for these critical requirements, the process was time-consuming and susceptible to errors, impacting overall operational efficiency and customer satisfaction.

In response to these challenges, we leveraged low-code tools to develop a comprehensive solution tailored to the client’s needs. We implemented a tracking system for technical inspections, scheduled maintenance, and insurance renewals, ensuring that each vehicle’s status and upcoming requirements are easily accessible. Automated email notifications were integrated to inform employees when specific actions are needed for a given vehicle, streamlining the management process. Additionally, we created a centralized database for insurance brokers, simplifying policy tracking and renewal coordination. These improvements significantly enhanced the efficiency and reliability of the client’s fleet management system.

Challenges for 2N
  • Conducting extensive research into low-code tools to identify cost-effective, scalable solutions that meet the client’s needs for tracking, automation, and easy adaptability.
  • Developing robust automation and email notification mechanisms to proactively alert employees to upcoming actions for each vehicle, reducing the risk of missed deadlines.
  • Building a comprehensive user interface to centralize all vehicle information, including sections for insurance brokers, logistical staff, and maintenance records. This interface required careful data structuring to maintain accuracy, accessibility, and security, enabling streamlined oversight of each vehicle and the team responsible for its management.
In Action
What we did

Integration of Low-Code Tools

We efficiently integrated low-code tools, enhancing the platform’s usability and performance. This enabled the rapid deployment of essential features while ensuring scalability and adaptability.

Automated Email Notifications

We implemented automated email notifications to keep employees informed of upcoming technical inspections and maintenance schedules. Additionally, the system sends alerts to both employees and insurance brokers when a policy renewal is approaching, ensuring timely actions and reducing the risk of oversights.

Custom Database Design

We designed a database tailored to the client’s specific needs, structuring it to efficiently manage large volumes of data related to vehicles, brokers, and maintenance records. This custom design enhanced data accessibility, accuracy, and allowed for future scaling as the client’s fleet and operational demands grow.

Comprehensive User Interface

We developed a centralized interface that consolidates all critical information about each vehicle, insurance brokers, and key logistics personnel. This interface provides quick access to essential data in one place, streamlining workflows and enhancing visibility across fleet management operations.

Outcome
Our collaboration empowered Biotrade with a streamlined, intuitive tool that met their immediate fleet management needs while positioning them for future growth and operational efficiency. By removing the complexity of manual tracking and scattered data storage, we enabled Biotrade to seamlessly monitor vehicle maintenance, insurance renewals, and inspection schedules. This tailored solution reduced administrative tasks and mitigated the risk of delays in logistics operations. Additionally, the low-code automations we implemented improved workflow efficiency, laying a solid foundation for ongoing enhancements in fleet management and resource optimization.
What we accomplished:
  • Implemented automated email notifications, ensuring timely updates for employees and insurance brokers regarding upcoming inspections, maintenance, and policy renewals.
  • Centralized vehicle, insurance, and personnel data into a single, accessible interface, improving data accuracy and facilitating efficient fleet management.
  • Reduced the risk of missed deadlines, enhancing fleet reliability and minimizing the potential for transport delays.
  • Designed a custom database schema tailored to Biotrade’s needs, providing a structured framework for data organization and supporting the scalability of their logistics operations.
  • Integrated low-code tools for a smooth, rapid deployment of essential features, ensuring minimal disruption to existing workflows.
  • Enabled cross-device accessibility, allowing the application to work efficiently across smartphones, tablets, and computers. Biotrade’s team can access the platform via a web interface or mobile app, facilitating effective fleet management anytime, anywhere.