Bike distributor’s reps each see only their own dealers
Dealers, brands and opportunities ran in Google Sheets.
Wholesale
Our dealers live in Google Sheets, and the scripts and access rules keep breaking.
- The problem
- Our dealers live in Google Sheets, and the scripts and access rules keep breaking.
- What we built
- From his sheets. A web app built from them, with a database behind it.
- What changed
- All three milestones are built and running on staging.
The problem
Our dealers live in Google Sheets, and the scripts and access rules keep breaking.
- Dealers, brands and opportunities ran in Google Sheets.
- Each rep should see only his own dealers.
- Scripts and access rules kept breaking.
What we built
- From his sheets. A web app built from them, with a database behind it.
- One place for dealers. Dealers, brands and opportunities together.
- Rep isolation. A rep sees his own dealers only.
What changed
All three milestones are built and running on staging.
Sheets that keep breaking as the team grows?
Tools
- Google Sheets
- SQL database
- Web app