Jason Frasca |||

Migraine Journal in Airtable

Migraine Journal in Airtable

I’ve kept a migraine journal for years.

But I admit, I’ve not done a good job with my consistentcy. The practice of recording tends to coincide with prolonged migraine episodes. And wane when I’m feeling well.

Now I’ve committed to logging my migraines for the long haul. This requires discipline to log many entries per day.

Best Way to Journal Migraines

I’ve experimented and thought about the many ways to log my migraines and how I can leverage the data. I’ve used spreadsheets, Evernote, and many other types of software. Some are too simple. Some too complex. Some are self-indulgent. Some focus on text instead of data and others the opposite.

Each has its strengths and limitations. What I am after is the perfect migraine journal - for me.

For the past few months, I’ve been using Ulysses as a migraine journal. It’s worked well while I was stuck in a difficult time. The long-form free writing allowed me to express my experiences.

But there is data in these journal entries that I want to analyze. I cannot do that in a text-based migraine journal. The logs need software that can quantify my migraines.

Migraine Journal in Airtable

I created a migraine journal in Airtable. In the grid view, I entered the fields I’d been using in Ulysses. It allows me to analyze my migraines for patterns. It’s a start.

Then I created a form view in Airtable. This allows me to enter my migraines, workouts, sleep, and diet on the go.

Migraine Journal Form in Airtable

This took me about 15 minutes to set this up.

Airtable Improves Migraine Logging

Airtable improves my migraine log in the following ways:

  1. Speed: I select a date for each entry and it adds the time. I can do this with Text Expander, but it never worked out.
  2. Consistency: Each entry now has structure. Critical for analysis.
  3. Numerical ratings for intensity and sleep.
  4. Dropdowns of common symptoms.
  5. Designed to enter more often throughout the day to capture more data points.
  6. Analysis: By grouping fields and ranking ratings.

Airtable is an Intermediary

I like Airtable but it is only a stopgap. After several years they still lack a viable mobile application. Their integrations are hype and basic.

For now, I can collect more migraine data faster. But Airtable is not the long term solution. I plan to explore NoCode software platforms to develop a better log. The key will be integration into my workflow.

For now, it is a step up.

If you would like to see or use my Migraine Log, here you can try the grid or spreadsheets view and the entry form.

Up next Pandemic Network Effect Podcast Editing
Latest posts Long Overdue Update Tools To Name Your Startup Company Only Good has Come From Learning Search Engine Optimization EMCee of the 2021 Startup Montclair Pitch Competition Journaling is the Game Film of Your Work No Such Thing as an Overnight Success Keyword Research to Determine Supply and Demand Building Long IF Statements in Google Sheets Thoughts: Super Wildcard Weekend 2021 Website Images: The Hidden Sunk Cost Fall 2020 Semester Recap - No Code ROT13 to Obfuscate for Better Search Results 2020 MIX Lab - A Year in Review Differences in SEO Tool Evaluations Improvements to the 3D Printing Lab’s Network Trust At A Glance - TAAG Selective Web Scraping Going Global: Entrepreneurship Abroad at Montclair State University Drafts Action Posts to Blot Write Once Use Twice Research Ways To Present My Newsletter Podcast Editing Migraine Journal in Airtable Pandemic Network Effect Helping Local Business During the Pandemic Getting the Copyright Right Juxtaposed Setting Up The Day With Intention How I Measure Sprint Progress What Will The Kids Do This Summer? Power of the Daily Standup

© 2020 Jason M. Frasca