Notion is great until your data needs relationships

Last updated
•
09.11.2026
•

Notion is one of the best places a team can write, plan and share what it knows. It starts to strain when your information stops being a collection of pages and becomes a web of connected records, where customers own orders, orders generate invoices and invoices roll up into projects. Once your team spends more time maintaining relation properties and rollups than using the data inside them, the fix is to move that operational data into a relational database built for it and keep Notion for the writing it does best.

Notion owns the blank page

Somewhere in your company, there's a Notion page holding the onboarding checklist everyone swears by. As CNBC's Disruptor 50 ranking noted this year, Notion's modular approach, which CEO Ivan Zhao compares to Lego blocks for work, has won over 100 million users and more than half of Fortune 500 companies.

The appeal is easy to see. A wiki, a meeting note, a product roadmap and a content calendar all begin life as text, and Notion makes that text simple to structure, link and share. Its databases handle lightweight lists well too, like a hiring pipeline, a reading list or a sprint board with a handful of properties.

Linked pages are not the same as related records

Here is the distinction that decides whether Notion keeps up with you. Every row in a Notion database is a page, and a relation connects one page to another. That model works beautifully for knowledge, where a link between two documents is a convenience.

Operational data behaves differently. In a CRM, an inventory or a project billing setup, the relationship is the business: which customer owns which order, what happens to the line items when an order is cancelled, who is allowed to see which record. Those rules need to live in the data model itself, not in a page property someone has to remember to update.

Notion's own documentation draws the line

Notion is refreshingly open about where its databases slow down. Its help centre notes that each database holds up to 250,000 rows, and that a formula depending on other formulas built on rollups can take longer to calculate. It also documents a limit on two-way relations: once a single page has been referenced 10,000 times from a related database, new references stop showing up on the other side.

None of these limits matter for a team wiki. They matter a great deal for a growing customer base, where one key account can collect thousands of linked orders, tickets and invoices. Teams that built their operations in Notion often get caught flat-footed here, because the structure held up perfectly until the day the business grew into it.

Workarounds turn into a data quality problem

When relations get slow or unreliable, people improvise. They type a customer name into a text field instead of linking it, duplicate a database for each team or paste totals by hand because a rollup takes too long to load. Every one of those shortcuts creates a second version of the truth.

That costs more than it seems. Research by Tadhg Nagle, Thomas Redman and David Sammon, published in Harvard Business Review, found that only 3% of the data quality scores in their study met the bar managers themselves set as acceptable, and that nearly half of newly created records contained at least one critical error. Duplicated, hand maintained data is exactly where those errors breed.

Relationships belong in the data model, not on top of it

This is where a relational foundation pays off. Ninox is an AI-native low-code platform built on tables and links from the ground up, so connecting customers to orders and orders to invoices is the starting point of what you build, not a property you bolt on later.

In practice, that gets concrete fast. You link tables once, and from a customer record you can open and edit its linked records inline with an embedded form instead of hopping between pages. Set the link from line items to orders as a subtable and deleting an order removes its line items with it, so orphaned records never pile up.

Unique fields stop duplicates at the point of entry, and per record permissions decide who can read, edit, create or delete each record, enforced on the server. Each table holds up to around 10 million records, and indexed fields keep frequent filters fast as tables grow.

Because Ninox is AI-native from day one, you can describe the system you need in plain language and get a working starting point with tables, fields and logic in place, then shape it yourself. None of this means leaving Notion behind. Plenty of teams keep their wiki in Notion and run the operational side on a low-code platform designed for relational data.

The quickest way to see the difference is to kick the tires with your messiest Notion database. Export it as CSV, import it into Ninox and link it to the tables it was always meant to connect to.

Teams building their own data systems is the new normal

More businesses are building the software that runs their operations instead of bending to someone else's. Gartner forecasts the low-code development technologies market will reach $58.2 billion by 2029, growing at 14.1% a year. The teams that get the most out of that shift will be the ones that pick a low-code platform with a real data model underneath, before their workarounds harden into habits.

Take the next step.

Start building for free
Stop working around tools that weren't built for you. With us, you can build exactly what you need.

Table of Contents

Nothing explains better than using it.
Build in minutes
Related posts
Industry Knowledge

Built in Ninox: a medical equipment tracker in minutes

Two plain-language prompts to Ninox AI build hospital software for equipment, maintenance, and repairs.
Industry Knowledge

Buy standard field service software, build what sets you apart

Six criteria help SMEs decide whether to buy field service software or build their own.
Industry Knowledge

Facility management: your CMMS is only as good as its asset data

Most CMMS problems start before the upload. Fix asset data capture and Maximo and SFG20 pay off.

Ready to work smarter?

Start for free and let our AI do the heavy lifting. Ninox builds workflows and solutions from scratch, designed around your team’s unique needs.