Field Sales Tracking System
A sales team with no reliable view of activity in the field, and managers who each needed to see only their own region.
- Services
- Custom Software · Data Analytics & BI
- Stack
- PostgreSQL · Row-level security · Mobile-first · Excel export
Published anonymised at the client's request. The problem, approach and stack are described; the client and their data are not.
The story
What happened
The challenge
A field sales team was reporting activity through calls and messages, which meant managers had no reliable view of what was happening day to day. It also meant a genuine access problem: each regional manager needed their own region's data and nobody else's.
Our approach
Mobile-first, because the people entering data are standing in a shop, not sitting at a desk. Row-level security in the database rather than in the interface, so the access rule holds no matter how the data is queried.
What we built
- A mobile-first tracker for field reps to log activity on the move
- KPI dashboards for managers, scoped to their own region
- PostgreSQL row-level security enforcing access at the database layer
- Excel export for the finance team's existing workflow
The result
Managers see current activity for their region instead of reconstructing it from messages. Because access control sits in the database rather than the UI, the rule holds regardless of how the data is reached — which matters more than it sounds when reporting gets extended later.
Notable
Details worth calling out
Built for a phone in the field
Entry is fast on mobile, because that is where the data is actually created.
Security in the database
Row-level security means the access rule cannot be bypassed by a new query or report.
Fits existing workflow
Excel export, because finance already had a process that worked.
Something similar in mind?
Tell us what you need. You will get an itemised quote, not a vague estimate.


