Assembly hours tracking for a racking installer in Belgium

The problem

The company installs warehouse racking, with its own fitters and freelancers working on different projects. To know what a project really cost, it needed every person's hours, breaks and project recorded the same way, checked by a manager, and added up correctly when several people worked the same job.

What I built

A time and cost tracking system in the tools the team already had, Google Forms and Google Sheets, held together with Apps Script:

• One personal form per fitter, with a link that never changes, so it can sit on their phone's home screen. The date defaults to "Today", start and end times and break minutes are pre-filled with sensible defaults, and past dates can still be picked when someone logs late.

• Adding a new person takes minutes. When a freelancer joins, they get their own form and their hours flow into the same system.

• An approval queue for the manager. Every entry lands in a queue to be checked before it counts, and a short email each morning says how many entries are waiting, with a direct link.

• Project reports that add up. A reporting file turns approved hours into net hours per project, multiplied by the number of people on the job, with a summary of every active project.

The result

• Hours are logged on site, on the day, in under a minute.

• Nothing gets paid or invoiced unchecked, because every entry goes through the approval queue.

• Project costs are visible while the job is still running, not weeks later.

Still collecting hours by message? Book a free rant session.