Airtable and Notion for Order Tracking: How Far They Actually Get

The competitor most software in this space still writes about is Excel. In 2026 it usually is not. When a maker outgrows a sheet, the next stop is an Airtable base or a Notion database, often built over one weekend from a template someone posted, and often good enough that the question closes for a year.

That is worth taking seriously rather than dismissing, so this is an honest account of where those tools hold up, where their free plans stop, and what you take on when the model is yours.

Why they genuinely beat a spreadsheet

A spreadsheet has one shape: a grid of rows. A commission is not one shape. It is a customer who has several orders, an order that has several payments, and a piece that came out of a batch that produced other pieces too. Forcing that into rows is why the sheet grows columns like deposit 2 date and why nobody can answer a question about it six months later.

Airtable and Notion both hold linked records, so those four things can be four tables that know about each other. Three consequences follow, and all three are real improvements:

• One order, many payments, no extra columns. A deposit in March and a balance in June are two records against the same order rather than two cells you keep aligned.
• Views instead of copies. The workshop sees pieces in production, you see money outstanding, and both are the same data filtered — not two tabs that drift.
• Intake stops being retyping. A form writes straight into the table, so an order agreed on the phone is entered once.

If your current answer is a sheet and those three sentences sound like relief, the move is worth making. The rest of this is about what comes after the relief.

Where the free plans stop

Start with the published ceilings, because they are the part people discover at the worst moment.

Airtable. The free plan allows 1,000 records per base, 1 GB of attachments, two weeks of revision and snapshot history and up to five editors. The Team plan is $20 per user per month billed annually and raises that to 50,000 records per base, 20 GB and a year of history. Business is $45 per user per month billed annually with 125,000 records and 100 GB.

Notion. The free plan caps individual file uploads at 5 MB, keeps seven days of page history, allows ten guests, and limits blocks once a workspace has more than one member. Plus is $10 per user per month billed monthly or $8 billed annually, with unlimited uploads and 30 days of history; Business is $20 monthly or $16 annually, with 90 days.

The real cost: you own the model

A base does not know what a deposit is. It knows about numbers, links and formulas, and every concept in your business has to be assembled from those. For a made-to-order workshop that means building, and then maintaining, at least this:

1. A payments table linked to orders, so several payments can belong to one order.
2. A rollup that sums payments per order, and a formula that subtracts it from the price to give the balance.
3. A batch table, with the units it produced, so a cost can be divided across them rather than guessed.
4. A link from each order line back to the batch it came from, which is the join everyone skips because it can only be made after delivery.
5. A margin formula that reaches through all of the above, and holds up when a batch cost arrives two weeks after delivery.

None of that is hard. All of it is yours. Six months later a field gets renamed to tidy a view, three rollups quietly return blank, and the dashboard still displays a number — just the wrong one. That failure is silent, which is what makes it expensive.

A spreadsheet lies loudly: a cell shows #REF and you go and fix it. A base lies quietly, because a broken rollup returns zero and zero looks like an answer.

The part nobody prices in

Whoever builds the base becomes the only person who can change it. In a two-person studio that is not a hypothetical risk, it is Tuesday: the person who built it is also the person quoting, and the request "can you add a field for the finish" waits behind a delivery.

Compare that with the same request in a bought tool, where the answer is either that it exists or that it does not, and neither answer costs you an evening.

Showing a customer their order

Both tools can share something outward, and this is where care is genuinely required rather than a competitor's talking point.

A shared Airtable view shows the fields in that view, which means every field you did not remember to hide — including the cost column, if the view was cloned from the one you work in. A published Notion page is readable by anyone holding the link. Neither is designed around the idea of one customer seeing one order, so the boundary is redrawn by you each time you share.

Whether the page comes from a base or from a tool, what it should contain is the same short list. What a customer order page needs to show covers it, and it is worth reading before you publish anything.

Which of the two, if you are going to do this

Airtable, if the answer you need is a number

Money outstanding across open orders, margin by piece type, what June actually earned. Rollups across linked tables are what Airtable is for, and the interface layer makes a workable dashboard without code.

Notion, if the order list is one part of a bigger workspace

Production notes, supplier contacts, finishes, your own process documentation, and the order table living beside them. It reads better, people actually update it, and the numeric side stays lighter than you would like.

The mistake is picking on aesthetics and then discovering the workspace needs to answer a money question every Friday.

Four options, side by side

The row to read twice is the second to last one. Everything above it is a feature; that one is who spends the evening.

What it costs once it is real

The free tier is free until the workshop needs to see it too. On Airtable's Team plan a two-person studio is $40 a month, and a third person makes it $60 — per-seat pricing is the shape of the bill, not the headline number.

That is not an argument that self-building is expensive; $40 a month for a system fitted exactly to your process is good value. It is an argument that the comparison is not "free versus paid". It is one subscription against another, with the maintenance sitting on your side of one of them.

When a self-built base really is the right call

• Your process is genuinely unusual. Two workshops, a licensing arrangement, staged pricing nobody else has. A product will not fit, and bending one is worse than building.
• The volume is small and stable. Ten or fifteen orders a year, all of which you remember anyway. The base is a filing cabinet, not a system.
• The workspace does more than orders. If Notion already holds your documentation and the team lives in it, splitting the order list out has a real cost.

And when it is not: when the base exists to answer what you are owed and what a piece earned, and you rebuild it every few months to keep answering that. Spreadsheet, accounting software or an order tool sets the same comparison out across the wider set of options.

If you decide to move

Whichever direction you go — sheet to base, or base to a purpose-built tool — the migration is smaller than it looks, and the mistake is always the same one: trying to carry the history. How to move without losing your history is the short version: open orders only, export the rest once, and delete nothing for three months.

The bottom line

Airtable and Notion are the honest middle of this category. They fix the shape problem a spreadsheet has, they cost less than most software, and for an unusual process they can be better than anything you could buy.

What they cannot do is hold an opinion about your business. A deposit is a concept you build, a balance is a formula you maintain, and margin is a chain of rollups that has to survive every change you make. That is the real price, and it is not on the pricing page.

Frequently asked questions