Overview
This whole coffee-logging setup started as a simple desire: I want to understand why some brews taste magical and others taste like hot disappointment. No app on the market really nailed what I needed with good data structure, clean logging, zero friction, so I built my own system. It lives entirely in Airtable, Fillout.com, and 2 simple iOS Shortcuts. No subscriptions. No janky UX. No vendor lock-in.
It’s a fully custom coffee journal that actually helps me improve as a brewer, learn my preferences, and track far more nuance than any commercial app bothered to expose.
How the Airtable Base Is Structured
The Airtable side is the backbone. I built three tables, each with a clean purpose.
Roasters Table
This is basically the “vocabulary” of where beans come from. Fields include:
- Name
- Location
- Website
- Logo
- Number of beans purchased
- Notes
It keeps identities straight and lets me compare roasters over time. Nothing fancy—just foundational clean data.
Beans Table
This is where the real detail lives. Each record represents a specific bag of beans. Fields include:
- Name
- Roaster (lookup)
- Status
- Received date
- Roaster’s tasting notes
- Roasted date
- Country of origin
- Variety
- Region / Farm
- Process + Process notes
- Altitude
- Bag size (g)
- Cost
- Cost per 100g (formula)
- Rating average
- Rating notes
- Would buy again
- Picture
- Freezer status
- Beans used (rollup)
- Utilization % (rollup)
- Thawed date
This table is my little coffee encyclopedia. It tracks what I’ve tried, what I’ve liked, and how the beans progress as I work through them.
Brews Table
Every brew I make becomes a record here:
- Bean (lookup)
- Method
- Grinder
- Grind setting
- Recipe notes
- Roaster (lookup)
- Extraction
- Dilution
- Rating + rating notes
- Dose (g)
- Water (mL)
- Brew ratio multiple
- Water temp (°F)
- Next-time notes
This is the “event log” of the whole system. It lets me see exactly how I brewed something, how it tasted, and what I should adjust next.
The Secret Weapon: Fillout.com Forms
Airtable forms are fine, but Fillout is better. Cleaner interface, better conditional logic, faster to fill out, and totally free.
I built three forms:
1. Log a Roaster
Tiny, simple form. Just enough to drop in a new roaster the moment I encounter one.
2. Log New Beans Received
Again simple: pick the roaster, enter bean details, attach the bag photo, and done.
3. Log a Brew
This is the form I open every single time I brew coffee. It does the smart stuff:
- Pick the bean I’m brewing
- Automatically show the last brew I made with that bean
- Pull in my “next time” notes
- Let me enter dose, water, temp, extraction notes, etc.
- Let me rate the brew
- Save new next-time notes for the future
This creates a loop: each brew informs the next brew. And if I have several beans open at the same time, it still stays totally organized—each bean always pulls its own history.
That’s the magic. Zero mental load. Just log and learn.
iOS Shortcuts for Instant Logging
To make this whole thing actually usable, I built two shortcuts:
Shortcut 1:
Launch Brew Logger
This opens the Fillout “Log a Brew” form instantly in my browser. One tap. No hunting around.
Shortcut 2:
Airtable Brews Interface
This goes straight to a custom Airtable Interface I built—a dashboard-style view showing:
- Recently brewed beans
- Key data
- Quick links
- Ratings and notes
Together, these shortcuts turn the system into something I can use half-asleep at 6am while juggling a crying baby.
Why This Setup Works So Ridiculously Well
This isn’t just a database. It’s a feedback engine.
Because I’m logging everything:
- I found I’m not a huge Guatemalan-coffee person.
- I discovered I love Ethiopian naturals—floral, fruity, slightly chaotic.
- I noticed I tend to overextract without realizing it.
- I’m learning which varietals actually resonate with me.
And because I have a GPT assistant I can plug my notes into, I can ask deeper questions. Stuff like:
- “Why did this cup taste muted?”
- “What patterns do you see in my high-rated brews?”
- “Am I under-dosing washed Ethiopians?”
It’s like having a personal coffee coach who’s actually paying attention.
But none of this would matter if logging were clunky. Fillout makes the UX lighter than air. That’s the whole point.
The Bigger Lesson
Everything I built here is 100% free. Airtable free tier. Fillout free tier. Shortcuts free. GPT optional.
If an app on the market doesn’t satisfy you, that doesn’t mean the idea is dead. It just means you haven’t assembled the pieces yet. There’s almost always a clever, DIY way to do what you want, especially now that tools like Airtable and Fillout exist.
And in this case, the payoff is huge: I’m learning more about coffee than I ever expected—my preferences, my mistakes, my patterns—and I’m genuinely excited to see what the next few months of data uncovers.
Brewing coffee is already a ritual. Now it’s also a story I can read.