Service database
Unified database to keep records of all services performed, which includes information about clients, vehicles, inventory, invoicing, and more.
Autogas la 17
Vehicle conversion center to Compressed Natural Gas (CNG) located in Barranquilla, Colombia
Company website
Project
Company description
Autogas la 17 is a company located in Barranquilla, Colombia, dedicated to converting vehicles to natural gas. This line of work involves strict administrative and operational processes that require documentation. Each of these documents includes varied information about the client, the vehicle, inventory items used, and general service data. All this information must be entered correctly in each document. In case of errors, services can be delayed and penalties may be incurred.
Problem and solution
The company used to manage service-related information through shared Google Sheets files. Although this method worked for a long time, clerical errors were very frequent (more than acceptable). This is why the company decided to develop an application that would allow them to:
- Consolidate all information in one place. A single database for clients, vehicles, inventory, and more.
- Automatically generate documentation, pulling data directly from the database.
- Have a robust system with data validation.
- Optimize administrative and operational processes.
- Minimize errors and paper usage.
Features
Template-based document generation
Templates are Excel files created by an administrator. When adding a template, you can select the service types that will use it. Then, for each open service, a document can be created from the template. The application automatically fills in the service data required by the document in the Excel file. Finally, the file is converted to PDF.
Authentication and granular permission system
Users log into the application using an email address. The app implements a simplified version of PBAC (Policy-Based Access Control). This means each user can be assigned specific resources and permitted actions, enabling fine-grained control over what each user can do within the application.
Calendar for events and reminders
Integrated calendar in the app for managing events and reminders. Specially useful for the commercial team. The calendar can be viewed in a monthly or weekly view. Events can be all-day or have a start and end time. They can also be linked to a specific service. This enables the automatic generation of reminders for certain services. Events have 2 types and 6 categories with a color-coded legend for easy identification and organization.