Case study · Construction
Site hours, task progress and payroll in one app for a construction company
This construction company pays site workers twice a month and tracks progress task by task. Hours, progress and payroll were spread across separate spreadsheets. We built a Spanish-language Retool app on Supabase that records each worker’s hours against project tasks, suggests progress from hours against budget, and prepares payroll by pay period.
The challenge
What wasn’t working
Hours had to be logged against the right task, several levels deep: project, category, subcategory, activity, then task. Picking from one long list invited mistakes.
Progress reports needed a sensible starting figure, and earlier reports had to stay on record rather than be overwritten.
Payroll needed hours grouped by pay period and worker, with the right bank account for each payment.
The solution
What we built
Hours by task
An editable table of each worker’s hours, with cascading dropdowns from project down to task, saved in one batch with a MERGE upsert.
Suggested progress
Progress is suggested as hours worked against budgeted hours, capped at 100%, and the site team can adjust it.
Full progress history
Each new report is stored as a new record and the old one is marked as superseded, so nothing is lost.
Dependency warnings
A task status screen warns when someone starts a task whose predecessor isn’t finished.
Payroll by pay period
Hours per worker per pay period and day of the week, with the payment account assigned.
Safety nets
Delete confirmations, a warning when leaving a page with unsaved changes, and one-click generation of foreman hours for a pay period.
How it works
From timesheet to payroll
- 1
Log hours
Hours are entered against the right task for each worker and day.
- 2
Report progress
The app suggests progress from hours used and the site team confirms it.
- 3
Check dependencies
Task statuses are updated, with a warning if a predecessor is still open.
- 4
Close the period
Foreman hours are generated and payroll is grouped by worker and bank account.
Screens
Inside the build
Real screenshots from the project. Client names, logos and personal details are blurred.

The result
What changed
- Site hours and progress in one place instead of separate spreadsheets
- Progress reports start from hours against budget, so they’re more consistent
- A complete history of every progress report
- Payroll prepared straight from the logged hours
More work
More case studies
Have a project like this?
Tell us what you need to build. In 30 minutes we’ll map what to build first and follow up with a fixed-scope estimate.
Official Retool Agency Partner5.0 on Clutch, 9 reviewsBuilding software since 2015Reply within one business day