Field Notes

Practical breakdowns of Airtable, Notion and Coda, and the exact moment a spreadsheet stops being enough.

For non-technical professionals

You don't need to know how to code to build something useful

Picture someone in office administration who has never opened a line of code in their life, staring at a shared spreadsheet that six people have quietly stopped trusting. This page is for that person, and for the marketing coordinator, the ops assistant, and the HR generalist who feel the same way.

A woman in business casual attire sitting at a desk building a project tracker on a laptop, looking focused and calm

Building your own tool isn't going around IT

There's a common worry that setting up your own Airtable base or Notion database is somehow overstepping, or that it'll create a mess someone else has to clean up later. In most workplaces, it's the opposite. A well-scoped internal tool for a small, low-stakes process is exactly the kind of thing IT teams are usually relieved not to have to build themselves.

The line worth respecting is around sensitive data and anything that touches customer information, payment details, or systems already managed centrally. For a task tracker, a simple sign-up sheet, or an internal directory, building it yourself is generally a reasonable and welcome thing to try, and telling your IT contact what you built afterward is usually appreciated more than asked for permission upfront.

A short conversation, not a proposal

How to mention what you built without sounding like you're asking permission

Describe it plainly

"I set up a small tracker in Airtable for our team's requests, nothing connected to customer data." A sentence, not a slide deck.

Mention who has access

IT teams generally care most about who can see what. Being upfront about the handful of people with access answers the first question they'd ask anyway.

Say what data it touches

Task names and internal statuses are a very different conversation to anything involving customer records or financial details.

Ask if it needs a heavier home

If the tool grows past your team, it's fair to ask whether it belongs somewhere more centrally supported. That question tends to land well.

A whiteboard covered in handwritten definitions of technical terms like database, automation and API, photographed in an office setting
Plain-English glossary

Terms you'll bump into, explained without jargon

Database
A structured collection of records, like tasks or contacts, where each entry follows the same set of fields.
Relational / Linked records
When one record connects to another, like a task connected to its parent project, so updating one place updates every view.
Automation
A rule that runs on its own, such as sending a message when a status changes, without a person doing it manually.
API
A way for two pieces of software to talk to each other. Most no-code tools use APIs behind the scenes to connect to other apps.
View
A different way of looking at the same underlying data, like a grid, a board, or a calendar, without duplicating anything.
Formula field
A field that calculates its value automatically based on other fields, similar to a spreadsheet formula but tied to the record.
Before you open a blank workspace

A short checklist worth five minutes

Skipping this step is the most common reason a first tool ends up abandoned within a month. It's tempting to jump straight into building, but a little thinking upfront saves a rebuild later.

Write down the actual problem in one sentence

"I need to know which invoices are overdue" is clearer than "we need better tracking."

List who touches the tool, roughly

Two people entering data and five people viewing it is a very different build than fifteen people editing simultaneously.

Decide the one view people will open first

Most tools are judged by their default screen. Pick the view that answers the most common question at a glance.

Give yourself permission to rebuild it once

The first version is rarely the final shape. Expect to adjust fields after a week of real use, and don't treat that as failure.

Choosing between the three, by role

A rough starting point, not a rule

These are tendencies observed while rebuilding the same tools across different scenarios, not fixed assignments. Plenty of teams do perfectly well outside these patterns.

Marketing coordinators

Content calendars and campaign trackers tend to sit comfortably in Notion, where the plan and the supporting notes live on the same page.

Operations and admin

Process trackers with several linked stages, like approvals or intake requests, often fit Airtable's structured views more naturally.

HR generalists

Onboarding checklists linked to new-hire records work well in either Airtable or Notion, largely depending on whether documentation or database structure matters more.

Small sales teams

A lightweight CRM with custom stages and buttons for follow-up actions is where Coda's formula flexibility tends to pay off, once the setup time is invested.