Skip to content
  • Home
  • Services
  • Work
  • Pricing
Let's talk
HomeServicesWorkPricing
Let's talkinfo@caparisonlab.com

Your work is good. Let's make it easy to find and book.Your work is good. Let's make it easy to find and book.

Tell us about your business. We reply within one working day.

Let's talkinfo@caparisonlab.com

Pages

  • Services
  • Home services
  • Work
  • Pricing
  • About
  • Contact

Elsewhere

  • WhatsApp
  • github
  • linkedin
  • RSS

Our time

--:-- Chittagong, Bangladesh


2026 Caparison Lab

Websites, booking and growth for home service businesses.

Caparison LabCaparison Lab
Questions? Ask our assistant
All work
Client projectWeb application

Office DayOfficeDayVisit 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.

ScopingDesignFrontendBackendDatabaseDeploymentWebTablet kioskZKTeco punch machines

Client

Caparison Soft

Budget
$5k – 8k
Duration
7 weeks
Year
2026
Status
In beta
Team
2

Built with

reacttypescriptpostgressupabasecloudflarevercelreacttypescriptpostgressupabasecloudflarevercelreacttypescriptpostgressupabasecloudflarevercelreacttypescriptpostgressupabasecloudflarevercelreacttypescriptpostgressupabasecloudflarevercelreacttypescriptpostgressupabasecloudflarevercel
d

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.

What we built

One React app on one Postgres database. Every tenant table carries an org id, and 417 row-level policy definitions compare it with the caller's organisation. 28 Deno edge functions on a second Supabase project hold every secret: R2 upload signing, Gemini, OpenAI, Discord and Telegram bots, punch-machine ingest. Files live on Cloudflare R2. Each organisation sets its own name, logo, currency and theme. Deployed on Vercel.

  • Workspace with projects, tasks, nested subtasks, custom fields, seven view types (list, board, table, calendar, gantt, dashboard, my work), saved and private views, roles, automations, button fields and workflow templates.

  • AI builder that turns a sentence describing a team's process into a workflow bundle, applied through the same path as templates, capped at 10 generations per user per hour.

  • Review desk with timestamped comments on cuts, subtask reviews, and public share links for deliverables.

  • Client portal where clients are business records, not logins; a few get portal access to their own projects.

  • HR attendance from ZKTeco punch machines (cloud-server mode, a Python bridge for older firmware, or USB import), plus QR kiosk check-in, leave, working from home, late log and performance.

  • Finance suite with double-entry accounting, payroll, editor payments, loans, expenses, subscriptions, client and staff ledgers, and a currency per organisation.

  • Meeting hub with recording, Gemini transcription, minutes and a linked Discord channel.

  • Storage plans with free and pro tiers, 14-day retention on free, a bring-your-own R2 bucket option and a daily cleanup job.

Seven weeks, from 24 July to 12 September 2026, and 400 commits.

GalleryGallery

Workspace

Workspace
Hr Management
Client View
Workspace
Hr Management
Client View
Workspace
Hr Management
Client View

1 / 3

Key decisionsKey decisions

  1. 01

    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.

  2. 02

    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.

  3. 03

    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 wentHow it went

  1. 24 to 29 July 2026

    Tenancy layer

    Baseline schema imported, org id and policies on every table, signup and organisation provisioning, platform console.

  2. 1 to 2 August 2026

    Clients, portal and storage

    Clients as entities, client portal, R2 storage plans live with the first test organisation.

  3. 5 to 17 August 2026

    Meetings and attendance

    Meeting hub with recording and transcription, punch-machine ingest, QR kiosk, vault folders.

  4. 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.

ResultsResults

organisations provisioned

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

Want something like this?

Multi-tenant means deciding what must never cross between organisations. Tell us who signs up and what they each need to keep to themselves.

Build something like Office Day

Next project

Build & Launch AI