All case studies

Offline field service app for a repair contractor

AppSheet Solutions built an AppSheet office app and an offline-first field app for a UK insurance-repair contractor. Work recorded without signal uploads exactly once when the signal returns.

Page last updated

Status: In daily use

Ask about this project

Islom Ilkhomov

Sample field service app: an office table of day sheets with a work plan and upload log, two phones showing a day’s jobs with no signal and a job’s photos, voice note and report, and a report of 36 of 36 security tests passed.
Illustration. Names and rows are sample data; totals are the project’s.
On this page

Key numbers

  • 36 / 36 security tests passed
  • 4 roles, each seeing only their own work
  • 25-page client guide

The problem

A UK insurance-repair contractor kept work plans, tradespeople’s day records, photos and reports in different places. Many jobs are in rural areas with poor signal and imprecise addresses, and work recorded there must never be lost.

What we did

We built three connected parts: an AppSheet office app for projects, tasks and day sheets; an offline-first Android and web app for the field; and an Apps Script backend. Tradespeople start and finish work, take photos and leave voice notes even without signal; when the signal returns, everything uploads exactly once. Voice notes become AI-written reports. Four roles (admin, manager, surveyor and tradesperson) each see only their own work.

Results

  • Offline test passed: a survey with 3 photos survived a phone restart and synced exactly once
  • 36 automated security tests passed, 0 failed
  • Role isolation proven: a tradesperson cannot see another surveyor’s records
  • 25-page client guide and role-based help site delivered
  • Live and in daily use

How it helps

Tradespeople keep working with no signal, and nothing recorded on site is uploaded twice.

Proposed, not in production

A platform to replace several tools. Prototype only.

More case studies

A supplier document library that matches files to products

Measured in the client’s test environment.

Tens of thousands of supplier files arrive in a Drive folder. Linking them to products took manual work.

Sector
Ingredients distributor · Europe
Platform
AppSheet → custom software
Status
In daily use

Sales records and access rules for each team

Measured in the client’s test environment.

Sales teams were moving off an old CRM. Each team should see only its own customers and prices.

Sector
Ingredients distributor · Europe
Platform
Custom software
Status
In daily use

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

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