Prefab Tracking template
One record every department reads: an assembly register with drawing revisions, a fabrication board moving orders Design → Cut → Weld → QA → Ready → Shipped → Installed, and deliveries that compare the promised date on site with the day the load actually arrived.
Tables
Assembly register
Assembly mark, Type, Drawing revision, Unit weight (kg), Length (m), Width (m), Design approved, Transport class, Fabrication orders, Orders raised, Units ordered, Notes
Fabrication orders
Order, Assembly, Assembly record, Unit weight (kg), Shop, Currently with, Destination site, Quantity, Stage, QA result, Planned start, Planned finish, Actual finish, Batch weight (kg) and 5 more
Deliveries
Delivery note, Fabrication order, Order record, Destination site, Haulier, Units on the load, Dispatched, Promised on site, Arrived, Crane booked, Delivery status, Days late, Notes
Views
- Shop floor board (kanban)
- All orders (grid)
- Fabrication programme (timeline)
- Weight by shop (chart)
- On QA hold (grid)
- Delivery calendar (calendar)
- Delivery log (grid)
- Assembly register (grid)
Forms
- Raise a fabrication order
Automations
- Notify the shop on a new order
- Email all departments on a stage change
- Notify the site on dispatch
- “Fabrication orders” reached “Installed”
- Daily sweep — still open in “Fabrication orders”
- “Crane booked” was ticked in “Deliveries”
- Large value in “Quantity”
It is a starting point, not a fixed product
Installing the template creates these tables in your own workspace. Rename a column, add a field, change a view or delete a table you do not need — it is an ordinary Appdor app from the first minute, and your existing spreadsheet can be imported into it.