Guides to working with data that connects
Most operational work does not fit in one table. These are practical guides to the ideas and the builds that make relational data manageable — written to be read once and used, not to rank for something.
How to build a CRM you'll actually use
Most CRMs fail because they ask for more data than they give back. Here is a five-table model that stays useful, and the fields that earn their place.
Relational basicsLinked records: the one idea that replaces half your formulas
A linked record is a pointer to a real record, not a typed name. Understanding that single distinction removes most of the maintenance work from a spreadsheet.
Comparisons and alternativesLooking for an Airtable alternative? Read this first
Most people searching for an Airtable alternative are hitting one of four specific walls. Identify which one, because it determines whether switching helps at all.
Relational basics
All 7 →The handful of ideas — relations, lookups, rollups, junction tables — that separate a spreadsheet from a system.
Linked records: the one idea that replaces half your formulas
A linked record is a pointer to a real record, not a typed name. Understanding that single distinction removes most of the maintenance work from a spreadsheet.
Lookup vs rollup: which one do you actually need?
Both read data across a link. A lookup borrows one record's value; a rollup summarises many. Here is how to tell them apart and pick correctly every time.
Database normalization for people who aren't engineers
Normalization has an intimidating name and a simple rule: every fact should live in exactly one place. Here is what that means in practice, without the formal theory.
One-to-many vs many-to-many, explained without the jargon
Getting the shape of a relationship right takes thirty seconds and saves weeks. Here is how to tell which one you have, using two plain-English questions.
Rollups, formulas and when to reach for each
Calculated fields come in three kinds, and picking the wrong one is why your numbers drift. Here is the decision rule, plus the patterns worth stealing.
What is a junction table (and when do you need one)?
When two things relate many-to-many, the relationship itself has data. A junction table is where that data lives — and it is the most useful structure in operational modelling.
Why every table needs a stable ID (and why it shouldn't be a name)
Names change, duplicate and get mistyped. If your records are identified by name, every link you build is standing on sand. Here is the fix, and it takes five minutes.
Spreadsheets, databases and the space between
All 5 →Why teams outgrow the sheet, what a relational workspace actually is, and how to tell which one you need.
Seven signs your spreadsheet has quietly become a database
Spreadsheets rarely fail loudly. They degrade. Here are the seven symptoms that mean your sheet is now doing a database's job badly — and what to do about each.
What is a relational workspace?
A relational workspace is what you get when a spreadsheet's ease of use meets a database's structure. Here is what that actually means, and when you need one.
Spreadsheet vs database: what actually changes
Not which is better — what is genuinely different. A clear-eyed comparison of the trade-offs, and the specific jobs each one wins.
The no-code database: a plain guide
What "no-code database" actually means, what these tools can and cannot do, and how to evaluate one without getting sold to.
Why VLOOKUP keeps breaking your spreadsheet
VLOOKUP is not a bad function. It is a fragile substitute for a relationship, and it fails in five specific ways. Here is each one, and what replaces it.
Build it: playbooks
All 8 →Step-by-step builds for the systems teams actually run — CRM, inventory, hiring, projects, content.
How to build a CRM you'll actually use
Most CRMs fail because they ask for more data than they give back. Here is a five-table model that stays useful, and the fields that earn their place.
Orders and line items: the classic build, done right
Every order system is the same three tables. Getting them right — especially the frozen price — is the difference between accurate revenue history and quiet corruption.
A project tracker that survives contact with a real project
Most project trackers die because updating them is work that benefits someone else. Here is a model where the person doing the update gets something back.
Build a content calendar that connects to the work
A calendar of dates is not a content system. Model pieces, channels and distribution separately and you get planning, production and performance in one place.
Build an applicant tracking system in an afternoon
Hiring is the textbook many-to-many problem. Model applications as their own table and the pipeline, the reporting and the candidate history all work.
Build an inventory system that reconciles itself
The single biggest inventory mistake is a stock level you edit by hand. Track movements instead and the number becomes both correct and explainable.
Collect work from clients without email ping-pong
Requests arriving by email are unstructured, unassigned and untracked. Structured intake fixes all three, and takes about an hour to build.
Track equipment and assets without a spreadsheet graveyard
Asset registers rot because they record state instead of events. Model custody and maintenance as movements and the register stays true on its own.
Comparisons and alternatives
All 6 →Honest comparisons against the tools you are probably already evaluating.
Looking for an Airtable alternative? Read this first
Most people searching for an Airtable alternative are hitting one of four specific walls. Identify which one, because it determines whether switching helps at all.
monday.com alternatives for relational work
monday.com is built around boards of work items. If your problem is entities that relate to each other rather than tasks moving through stages, that is the mismatch.
Notion databases vs a real relational database
Notion databases are excellent at what they are for. Here is the specific line where they stop being the right tool, and how to tell if you have crossed it.
Smartsheet alternatives: what to actually look for
Smartsheet is a project tool with a spreadsheet interface, not a relational database. If that mismatch is your problem, here is what to evaluate instead.
The Excel alternative for teams who outgrew tabs
You are not looking to replace Excel. You are looking to stop asking it to be a shared database. Here is where the line sits and what to move.
When Google Sheets stops being enough
Sheets solved collaboration, which is exactly why teams push it further than they should. Here are the four ceilings, and what to do at each.
Tool roundups
All 4 →What is genuinely good, what it costs, and who each option really suits.
The best no-code database tools, and who each one suits
A structural comparison of the main options — where each one's design centre sits, and the kind of team it genuinely fits.
The best Airtable alternatives, compared by what actually differs
Six alternatives, organised by the reason you are leaving — cost, relation depth, permissions or self-hosting. The right one depends on which wall you hit.
The best CRM options for small teams (including not buying one)
Most small teams do not need a CRM platform. They need four tables and a discipline. Here is how to tell which category you are in before you spend anything.
The best inventory tools for small teams (and when to build instead)
Inventory software splits into three categories that solve different problems. Buying from the wrong category is the most common and most expensive mistake.
Stop fighting your spreadsheet
RowFold gives your data the structure it already has in your head — tables that know about each other, views that fit the work, and AI that can actually answer questions about it.