Office DayVisit site
Multi-tenant back office built for video-editing agencies, and usable by any team that runs projects, people, money and files in one login.
An in-house, single-tenant ERP became a product other agencies sign up for themselves: 8 organisations provisioned within 10 days of the first commit.
Built with

The brief
Caparison's in-house ERP ran a video-editing operation for one company. Its name and its currency were hardcoded, ledger accounts were found by fixed IDs, and the Gemini key shipped inside the browser bundle. Editors, reviewers, producers, HR and finance all worked in it, each with a role.
The spec asked for that ERP copied into a new repo and turned into a product other agencies could sign up for themselves. The non-negotiables: an org id and a row-level policy on every tenant table, no path from one organisation's data to another, and a free beta now with a billing-shaped schema from day one.
Office Day is shaped around how a video-editing agency works, but nothing inside it is specific to video. Any team that runs projects, people, money and files can use it as it stands.
Gallery
Workspace
1 / 3
Key decisions
One column and one function for tenancy
Every tenant table has an org id and a policy comparing it with the caller's organisation, read from their profile. No database or schema per tenant, so one migration path, 131 files so far, serves every organisation.
Files on Cloudflare R2, signed by edge functions
The browser never holds bucket credentials. An edge function signs each upload and switches to multipart above R2's single-PUT cap. Plan limits and the 14-day free-tier retention live in one SQL function, so changing a limit is one edit.
The AI builder emits a workflow bundle, not prose
Templates, exports and the AI builder all produce the same bundle format and apply through one RPC. The model is schema-forced and keyed server-side, so an answer is either a valid bundle or an explicit refusal.
How it went
24 to 29 July 2026
Tenancy layer
Baseline schema imported, org id and policies on every table, signup and organisation provisioning, platform console.
1 to 2 August 2026
Clients, portal and storage
Clients as entities, client portal, R2 storage plans live with the first test organisation.
5 to 17 August 2026
Meetings and attendance
Meeting hub with recording and transcription, punch-machine ingest, QR kiosk, vault folders.
22 August to 12 September 2026
Workspace rebuild
73 migrations: views, custom fields, roles, automations, templates, the AI builder, and the client portal for workspace.
Results
8
one on the free storage plan as the first real test, seven on beta
24 July to 2 August 2026, measured by internal storage handover doc
63
screens shipped
plus 28 edge functions and 131 migrations
24 July to 12 September 2026, measured by repository



