Project register
Every project from take-on to close-out. Filter by tags, line or client, see them on the map, and export the list to Excel.
| No. | Project | Client | Business line | Status | Date | Value (R) | Tags | Map |
|---|
New project · QMR 300A/B
Opportunity: fill in Stage 1. Active: fill in Stage 1 and Stage 2. Submitting sends it for approval, and the project number is added when it is approved.
Project close-out · QMR 300C
Closing a project completes the checklist and adds its reference record (scope, tags, photos, location, letters) to the database. The QMR 300C form is generated and emailed to the business line lead.
Approvals
Projects waiting for approval. If your Power Automate flow writes the decision back to the database, this list clears itself. Otherwise record the decision and the Fresh Projects number here.
Records to complete
Imported and closed projects that are missing details needed for tenders. Open one, add what’s missing (number, dates, fee, reference contact, letters) and mark it complete. Quickest wins are at the top.
| Project | Business line | Client | Still missing | Done |
|---|
Clients
Built from every project: technical contacts from Stage 1, invoice contacts from Stage 2 and reference contacts from close-out.
| Client | Type | Projects | Closed | Contacts |
|---|
Dropdown lists
The values offered in every dropdown, taken from the QMR 300 sheet. Add business line lead emails so close-out forms reach them.