Founders Box , Fundraising Cockpit (Phase 1)
A documented, developer-ready Airtable schema and Softr app architecture (ERD, table/field definitions, wireframes, visibility/role model, automation opportunities and a prioritized Phase 1-3 backlog) enabling a 2-day Phase-1 build for founder-facing fundraising cockpits.

The problem
Design and deliver a clean, extensible Airtable + Softr architecture for Crampton Partners to run CRM, client-facing portals, investor targeting pipelines and event/activity tracking , including a prioritized Phase 1 build that a developer can implement in a 2-day sprint and a roadmap for Phases 2-3.
What we built
Purpose: Audit existing Airtable bases (anonymised if needed) and deliver a simple, scalable operational architecture that supports investor targeting pipelines, activity tracking, founder dashboards, and future cohort/mentor features.
Phase 1 focuses on an MVP fundraising cockpit (founder dashboard, pipeline Kanban, investor details, recent activity, add target/log update actions). It intentionally excludes cohorts, mentors/permissions model, staging/normalisation tables, advanced automations, and narrative tagging , these are scoped for later phases so Phase 1 remains deliverable in ~11-14 developer hours.
A production-ready architecture that the client team can either build themselves from the provided checklist and assets or retain the architect to implement. The schema is Postgres-ready to support future migration to Supabase/Postgres if required.
- ERD diagram covering entities and their relationships.
- Five-table Airtable schema: companies, investor firms, investor contacts, targets and progress updates.
- Softr wireframe and page tree for the founder and admin interfaces.
- User roles, permissions, visibility rules and editable versus read-only field definitions.
- Data flow map with recommended Make and Zapier automation touchpoints.
- Prioritized backlog across three phases, with a two-day developer checklist.


How we built it
This was an architecture engagement, not a build. The deliverable is a schema, a wireframe, a data flow map and a backlog a developer can implement in a two-day sprint, rather than a running application.
Phase 1 was deliberately narrowed to a fundraising cockpit: founder dashboard, pipeline Kanban, investor details, recent activity. Cohorts, the mentor permission model, staging tables and advanced automation were pushed to later phases so the first build stays deliverable.
What changed after launch
Topics
- Coaching, Consulting & Professional Services
- Airtable
- Softr
- HubSpot
- Google Sheets
- Make (Integromat)
- Professional Services
- Client Portals
This was a client portal development build. See what a build like this costs, or hire a Softr developer to do the same for you.
Want something like this?
Tell us what you're building. First conversation is on us. Fixed quote in 24 hours, mutual NDA signed on request.
.png&w=1920&q=75)









