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.
Illustration. Names and rows are sample data; totals are the project’s.
On this page
Key numbers
36 / 36security tests passed
4roles, each seeing only their own work
25-pageclient 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.
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.
Tell us where work gets stuck.
We clarify what an app could help with.
We agree the next step together.
Book a 30-minute call
Discuss your custom app project with Islom on Google Meet.