Challenge
Sites were linked by their text names, and duplicates and hidden characters caused visit history to get lost. An audit found 262 broken names out of 697.
Mobile app · field service · CRM
Ecohoreca: field service for HoReCa
The company cleans grease traps in cafes and restaurants. Crew schedules and the client registry lived in spreadsheets, where the links between sites and visits kept breaking.
- crew mobile app
- visit calendar
- photo & video
- sales kanban
697sites on the service schedule
4apps in one system
81API methods
What we built
- Office portalclients, sites, districts, crews, services and a visit planner calendar with a change log.
- Crew appthe day's site list, visit card, photos and videos of the work, actual vs. planned liters, add-on services.
- Oversightevery morning the system automatically flags missed visits.
- Sales kanbanleads, hunter and farmer modes, PDF and Excel export.
Result
Every site has a permanent ID instead of a text name, visits are confirmed with photos and videos, and missed visits show up the next morning.
Technology
- Node.js
- Express
- MySQL
- React
- Expo / React Native
- Google Sheets API
Have a similar task?
Tell us what you need to automate or build. We will show similar solutions and estimate the timeline on the first call.