All case studies

HR, timesheet and payroll system

AppSheet Solutions built an AppSheet HR system for an engineering consultancy, covering staff records, timesheets, leave, expenses and salary periods.

Page last updated

Status: In daily use

Ask about this project

Islom Ilkhomov

Sample HR app: a weekly timesheet table with a cost column hidden from staff, the project’s employee, timesheet, leave, expense and salary totals, a calendar and salary periods, and a phone showing a leave request form.
Illustration. Names and rows are sample data; totals are the project’s.
On this page

Key numbers

  • 28 employees
  • 206 timesheets
  • 111 expense claims
  • 49 tables 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.

More case studies

Offline field service app for a repair contractor

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.

Sector
Insurance-repair contractor · United Kingdom
Platform
AppSheet + offline web app
Status
In daily use

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

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