All case studies

Sales records and access rules for each team

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.

Page last updated

Status: In daily use

Ask about this project

Islom Ilkhomov

Sample sales app: a customer table for one team, an opportunity with its activity, a made-up map, a permissions table for each team, and the time to open an opportunity falling from 7.1 to 2.2 seconds in the client’s test environment.
Illustration. Names and rows are sample data; totals are the project’s.
On this page

Key numbers

  • 2.2 s to open an opportunity, was 7.1 s
  • 13 data 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.

Planned, not built yet

Moving all staff off the old CRM. Not done yet.

More case studies

AI meeting-to-task and Workspace security automations

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.

Sector
Engineering team
Platform
Gemini + Apps Script
Status
In daily use

Purchasing platform for a machinery manufacturer

A machinery manufacturer needed one shared record for requests, supplier prices, approvals and goods receipt, used by many people at once.

Sector
Machinery manufacturer
Platform
AppSheet + Apps Script
Status
In daily use

Start with a conversation

Let’s make your work easier.

  1. Tell us where work gets stuck.
  2. We clarify what an app could help with.
  3. We agree the next step together.

Tell us about your project

WhatsApp (opens in a new tab)

Need an example?

We want to register our equipment and let field staff report faults from their phones. Today, we track everything in messages.

Add project details (optional)

What is it about?

Book a 30-minute call

Discuss your custom app project with Islom on Google Meet.

Choose an available time
Portrait of Islom Ilkhomov

Islom Ilkhomov

Prefer to write directly? Islom.Ilkhomov@appsheet.com.tr

Istanbul, Türkiye

Prefer a conversation? Write to me directly.

Talk to Islom on WhatsApp (opens in a new tab)+90 501 176 94 71