Design the lifecycle before the database
- Decision
- Map decisions, owners, states, and handoffs before creating records and views.
- Why
- A flexible tool can reproduce operational confusion just as easily as it can resolve it.
Case study · CRM, ERP-lite, and operations automation
Designing lifecycle logic, approvals, role-based visibility, automation, and handoffs around the way the business actually operated.
Systems Designer — No-Code, Automation & AI Workflows
01 · At a glance
02 · Context
The business needed connected operational logic across intake, approvals, client and project creation, customer success, follow-ups, role-based work, and procedures.
The value was not the novelty of a no-code platform. It was the lifecycle design, governance, visibility, and adoption model built around the business.
03 · The real problem
A Notion-centered CRM and ERP-lite operating system connecting intake, approvals, client and project creation, customer-success handoff, follow-up, SOPs, and role-specific work.
Records, approvals, projects, client context, and follow-ups were difficult to connect.
Different roles needed useful views without duplicating the underlying truth.
Lifecycle transitions and customer-success handoffs depended on memory and manual coordination.
Automations needed to preserve approvals and operating ownership.
04 · Ownership
I owned the framing, operating logic, constraints, acceptance model, and delivery direction. Implementation was completed with engineering and/or AI-assisted tools according to the engagement context; I do not claim to have hand-written every line.
05 · System map
Approved intake creates linked client and project records in the operating system. Role-based views expose the same underlying truth to the right people, while automation supports follow-up and customer-success handoffs under documented governance.
Captures requests, required context, decision owners, and approval evidence.
Boundary: Records do not progress into committed work without the required decision.
Creates linked operational entities after approval and preserves lifecycle context.
Boundary: Shared records support multiple views without creating duplicate truth.
Surfaces the right work, follow-up, and exception context for each role.
Boundary: Visibility follows operational need and record ownership.
Connects delivery to customer success, follow-up, SOPs, and lifecycle automation.
Boundary: Automation supports the handoff but does not replace required approvals or owner judgment.
06 · Decisions and rationale
Tools change. The durable work is deciding what owns truth, what may move, what must stop, and what evidence is enough.
07 · Implementation
Guardrails
08 · Outcomes
09 · Evidence register
Evidence is described conservatively. Any visual proof added to this page must be redacted, captioned, and checked before publication.
Diagram
Shows decision gates, record creation, role views, handoffs, and exception paths.
Sanitized evidence
A sanitized example of how shared records support distinct operating responsibilities.
Narrative record
Explains the relationship between automations, approvals, SOPs, ownership, and fallback behavior.
10 · What this proves