← Back to all case studies
Case Study 03Multi-tenant SaaSOhio, US7-Week BuildUpwork Verified · 5.0★

Building "The Board Matrix" — A Multi-Tenant SaaS Platform for Executive Board Recruitment

How a consulting methodology that lived in Excel spreadsheets became a white-labeled, client-facing SaaS platform — in 7 weeks, fixed price.

Client
US Marketing Agency, Ohio
Engagement
7 weeks + ongoing retainer
Rating
★ 5.0 / 5.0 + $200 bonus
Live at
boardmatrixscore.com
The Board Matrix — live portal at boardmatrixscore.com showing candidate ranking
7 wks
Fixed-price
build time
12+
Airtable tables
fully relational
7
Automations
in production
+$200
Client bonus
on delivery

The BriefTurn a consulting service into software

The client is a US-based marketing and media agency that helps companies recruit board members and executive advisors. They were running this entire workflow in offline Excel spreadsheets, scored by hand, with no consistent methodology across clients.

They wanted to productize it — turn their internal hiring methodology into a branded, multi-tenant platform their end clients could log into and use directly. In short: take their consulting service and turn it into software.

The ProblemThe process broke down at every layer

  • No consistency between clients. Every engagement was scored differently because the methodology lived in a consultant's head, not a system.
  • No structured candidate evaluation. Scoring was largely subjective. There was no way to say "this candidate ranks higher because of these specific factors."
  • No client-facing surface. End clients had no portal — every interaction was email back-and-forth with the agency.
  • Excel didn't scale. Adding a new client meant duplicating a spreadsheet. Adding a new board position meant editing a tab. No way to operate at volume.

What I BuiltThe Board Matrix — multi-tenant SaaS on Airtable + Softr

Published at boardmatrixscore.com — a fully branded, client-facing portal where the agency's end clients log in, manage their companies and open positions, define evaluation criteria, evaluate candidates, and receive ranked results.

The Data Architecture

A fully relational, multi-tenant Airtable base with 12+ interconnected tables:

Clients
The agency's end customers
Admin Access
Per-client login and permissions
Companies
Company entities under each client
Positions (Requisitions)
Open board roles per company
Attribute List
Master library of evaluable attributes
Matrices
Per-position scoring matrices
Board Members
Registered candidate pool
Applications
Candidate applications to specific positions
Candidate Attribute Ratings
Per-attribute scoring per candidate
Matrix Final
The calculated ranking output
Airtable Board Matrix backend — 12 tables showing relational structure

The Scoring Methodology

For each open position, the client defines a custom matrix of attributes, with each attribute weighted A through D (A = highest). Each candidate is profiled against a set of personal traits scored 1–5. The system applies position-specific weighting and calculates a final weighted ranking — surfacing the top candidate automatically.

This replaces subjective consulting judgment with a transparent, defensible scoring methodology the agency can explain to its clients.

The Client-Facing Portal (Softr)

Started with Airtable Interfaces, then migrated to Softr — published to a custom domain with full white-label branding, per-client logins, role-based access control, candidate intake forms, and ranking dashboards. Each end client sees only their own data.

Softr Board Matrix portal — published and live at boardmatrixscore.com

The Automation Layer

Seven automations run the platform end-to-end:

01New board members created in Softr automatically sync to the Airtable backend
02Board member updates trigger downstream record updates
03New matrix attributes auto-propagate across relevant matrices
04Matrix changes trigger scripted attribute synchronization
05Attribute additions cascade across all matrices that should inherit them
06Matrix sync flags ensure scoring stays current as criteria evolve
07Candidate ratings auto-update on matrix saves
Airtable automations panel — 7 production automations

The OutcomeA consulting service became a product

A consulting service was productized into a software platform. What was previously billable consulting hours is now a system the agency's clients use directly.
Subjective scoring became transparent and defensible. Every ranking can be explained back to the client with the underlying matrix and weights.
Multi-tenant from day one. Adding a new client is configuration, not engineering — every new account inherits the same scoring infrastructure.
Days saved per recruitment cycle. What used to take days of manual spreadsheet work per position now happens in real time as candidates apply.
$200 client bonus on delivery + continued engagement with $500 retainer for design polish. Still live at boardmatrixscore.com.

What the Client SaidVerified Upwork review, January 2026

Upwork · Verified
5.0 / 5.0 · $200 bonus paid

Very responsive and willing to quickly address any issues. Committed to success.

Committed to QualitySolution OrientedClear CommunicatorAccountable for Outcomes
Marketing & Media Agency
Ohio, US · Executive Board Recruitment · January 2026
Tech Stack
AirtableSoftrboardmatrixscore.com7 AutomationsScripted Matrix Logic

Want a platform like this?

If you run a consulting or services business that depends on a methodology in someone's head — there's almost certainly a productized version that can run on Airtable + Softr. Book a free audit call.

Book a free audit →