AppSheet Solutions and the client’s in-house team built a custom sales app for a European ingredients distributor. Each team sees only its own customers, contacts and prices.
Illustration. Names and rows are sample data; totals are the project’s.
On this page
Key numbers
2.2 sto open an opportunity, was 7.1 s
13data requests to open it, was 58
Measured in the client’s test environment.
The problem
Sales teams for different industries were moving off an old CRM. Each team should see only its own customers, contacts and prices, and costs only at the right level, and the new app had to apply those rules on every screen.
What we did
Customer industries, locations on a map, and a filtered view for each team
Access by department and level, plus exceptions, set by admins in a separate permissions app and enforced by the sales app on the server
Opportunity activity with mentions and support requests to other departments
CSV exports, and five years of national-bank exchange rates for offers
Speed work: far fewer data requests per screen, so records open faster
Built together with the client’s in-house team.
Results
Data requests to open a sales opportunity cut from 58 to 13, in the client’s test environment
Time to open it cut from 7.1 s to 2.2 s, in the same environment
How it helps
Each team sees its own customers and prices. Admins change access in one place.
Someone had to write up tasks by hand after long online meetings, and management had no simple view of how company Google accounts and files were used.