Illustration. Names and rows are sample data; totals are the project’s.
On this page
Key numbers
28employees
206timesheets
111expense claims
49tables in one HR system
The problem
An engineering consultancy handled staff records, time, leave, expenses and pay outside one shared system, with approvals spread across e-mails and files.
What we did
We built the People App in AppSheet: employees, timesheets, leave, expenses, documents with expiry dates and performance reviews, with role-based access and approval chains. Cost data is hidden from ordinary employees. A daily Apps Script job keeps six months of salary periods and weeks generated ahead, so payroll never waits for set-up. About 28 automation bots handle notifications and approvals.
Results
28 employees, 206 timesheets, 73 leave requests, 111 expense claims and 67 salary records in the app
49 tables in one governed HR system
Salary periods generated six months ahead, automatically, every day
Live and in daily use
How it helps
Approvals run in one system, and payroll never waits for set-up.
Work plans, day records, photos and reports sat in different places. Many jobs are in rural areas with poor signal, and work recorded there must never be lost.