How I used Airtable to swap my daily fast-food habit with 5-minute meal planning


I built a custom Airtable database to track my food planning. Here is how it is set up

Elyse Betters Picaro / ZDNET

Follow ZDNET: Add us as a preferred source on Google.


ZDNET’s key takeaways

  • I built an Airtable database to plan meals before eating.
  • Food planning helped reduce takeout and decision fatigue.
  • A simple database can quiet food noise without diet apps or pills.

I built a custom Airtable database to track my food planning. If you knew me as a younger adult, you’d realize how ridiculous that idea is. For years, my “food planning” consisted of deciding which fast-food drive-thru to hit on my way home from work.

Until I got married, I ate almost every meal away from home. When I did eat at home, it was leftovers from previous restaurant visits or pizza delivery from New Jersey’s excellent pizza shops. Often, breakfast either consisted of Dunkin’ Donuts or the previous night’s pizza. One Saturday, my buddy and I went to the mud races (a form of motorsport where vehicles like dune buggies on steroids race through muddy terrain for fun and profit), fueled by a pizza that had lived in the back seat of the car since the previous evening. 

But eating out changed around pandemic time. We stopped going out to restaurants. My favorite Tuesday discount sushi visit was off the table, since the sushi place was closed. We started trying to cook at home.

Eating at home provided a bit of a health awakening. First, I didn’t feel quite as ick as I almost always did from that constant diet of fast food and pizza. I then started to modify my eating more completely, avoiding refined sugar and flour. By the time I cut out the constant supply of my beloved baked goods, I started to lose weight.

This is where food planning came in. Most diets I’d participated in over the years promoted tracking what you eat. Whether it was calories, macros, or points, you recorded it after the fact. You still had to decide every meal, day after day.

Also: What you give up when you put on a smartwatch or ring

But planning means figuring out your food choices before you eat.

“Our stressed and hungry brains are not reliable when it comes to making good food decisions at meal time. Give your future self the gift of a plan,” said Karen Kennedy, author of “Hack Your Blood Sugar.” She is a certified nutritionist and an integrative and functional nutrition certified practitioner, an advanced practice credential earned after getting specialized training in root-cause medicine and holistic nutrition.

Kennedy also said that her patients who meet their health goals plan most of their meals. She’s not the only believer in meal planning.

“In my experience, pre-planning meals reduces what I call nutritional decision fatigue, the constant low-level mental negotiation around food that quietly drains willpower, increases impulsive eating, and disconnects people from eating with intention rather than emotional convenience,” said Dr. Naheed Ali.

Ali has three doctorates: an MD, a PhD, and a SciD. He completed Harvard Medical School’s lifestyle medicine training program and is also certified in clinical research by the National Institutes of Health.

Also: This OTC glucose monitor encouraged me to change my eating habits – here’s how

As I discovered, once I stopped ordering pizza on demand, planning food also helps when you need to create a shopping list. I’d used shopping lists before, of course. How else would you know what you needed to buy at Home Depot? But who knew you could also use the same tool at a supermarket? Actually, through most of the 1990s and early 2000s, I don’t think I ever went inside a supermarket. Ever. Wawa and Taco Bell were my supermarkets.

But you can’t, or at least shouldn’t, live like that forever. At some point, living like college students has to change as you get older and realize there are only so many all-nighters you can pull, and only so much junk and fast food you can safely consume without permanent damage. 

My wife is an RN, a very patient RN, and after years of listening to her talk about health and wellness, some of it rubbed off. Besides, I love her and want to be with her for as long as possible. Better eating is part of that. And, as you might imagine, I found a technical solution to help me out.

Using Airtable

Now, not only can I plan my shopping list, I can even tell you that my wife and I ate oatmeal 189 times this year, and had cottage cheese 184 times. We eat just about the same amount of blackberries, strawberries, and grapes. Bell peppers and carrots are regular eats, but mixed veg is by far our most commonly consumed vegetable choice.

popularity

Screenshot by David Gewirtz/ZDNET

That information is available because not only do we track our food for the next day, we also keep a log of how often we choose those foods, along with where we buy them.

We do this using a cloud service called Airtable. I built this database back in 2021, and we’ve been using it since.

I chose Airtable over Notion (which I use to track other projects) because Airtable is like a low-code relational database. Notion uses page-based blocks, so every entry in Notion is a page in its unstructured and not-really-relational database.

Also: Wearables produce huge amounts of health data – and doctors are struggling to keep up

To be clear, I could have used one of the thousands of food-tracking apps out there, but I wanted one that was tailored precisely to my needs. I didn’t want to track food after it was consumed. I wanted to track food based on whether it’s grain, protein, vegetable, fat, fruit, or condiment. I didn’t want to enter calories or macros. I just wanted to choose the food.

So, each day, Airtable creates a form. This is my food plan for today. As you can see below, there are views for both my wife and me. We have foods for breakfast, lunch, and dinner, as well as a mini-meal option (usually a protein shake or more vegetables).

food-log

Screenshot by David Gewirtz/ZDNET

Each night, I use a little script called Build Day that builds out a blank day.

build-day

Screenshot by David Gewirtz/ZDNET

This script uses Airtable’s automation feature to insert a set of standard values into fields for that day’s record. Then the planning process consists of clicking on the field and choosing a food.

select-food

Screenshot by David Gewirtz/ZDNET

The automations are fairly simplistic. They consist of a sequence of actions that push values into the fields. Actions chain to other actions, so when Airtable is done creating tomorrow’s breakfast records, it moves on to tomorrow’s lunch records, and so on.

automations

Screenshot by David Gewirtz/ZDNET

Now that the tool is built, using it takes just a minute or so. The biggest challenge is the discussion my wife and I have about what our main lunch protein will be.

Also: Asking AI for medical advice? There’s a right and wrong way, one doctor explains

About a month ago, we decided to swap our big meal from dinner to lunch, and this switch seems to be working out pretty well. We realized we were often eating our big meal of the day quite late. This way, we have time to eat and digest the main meat, fish, or poultry protein source earlier in the day.

Our food at night is almost always fruit, some cottage cheese, some vegetables, and an ounce of fat. Simple, easy, and surprisingly filling.

You could vibe code this, but why?

I put this system together before generative AI was a thing. Today, you could vibe code a web app in a matter of hours. But why bother?

Airtable is robust and managed by the company. Bugs might exist in the automations, but will rarely be found in the underlying database layer. Everything is deterministic, so you can count on the tool performing as expected. Plus, the whole thing costs only $12/month, so it’s not even as costly as some of the typical food-tracking apps.

Also: I’m using these 7 Linux wellness apps to take better care of myself in 2026

“Generic health apps give you what they think you need. With Airtable, you can describe your food planning system in plain language and get a real app built around your data — one where AI agents can actually do work for you, from logging meals to spotting patterns over time,” Andrew Busse, VP of AI operations at Airtable told me.

As you can see from Busse’s comment, Airtable also has AI. But as much as AI agents could do the work, I haven’t needed to use them for my tracker. Frankly, I prefer it that way, at least for this project. There’s at least one tech place in my life where AI hasn’t managed to intrude, and I don’t have to spend my time begging an inanimate machine to build my app.

There’s no doubt that the time/benefit analysis is strong in this one. I built the tool one weekend back in 2021, and have used it every day for the past five years. That’s a pretty solid result from some minimal engineering. Plus, all that takeout and restaurant food adds up. Eating simple vegetables and protein has been great for our food budget.

Food noise

Food noise is a fairly new term describing the relentless thoughts about food that many people experience. In “The Day the Food Noise Died,” an April article in The New York Times, author Gina Kolata described how the constant internal chatter about food distracts people who are struggling with their weight.

In the article, she discussed how food noise could be described as internal voices urging people to eat and then shaming them for eating. My grandmother was like that. If I didn’t eat my whole meal at holiday gatherings, she was personally insulted. But then later, she’d tell me I could do with losing a little weight.

In any case, food noise is like having my grandmother living in your head 24/7. The main premise of the article was that once folks started taking GLP-1 weight-loss drugs like Ozempic, Wegovy, Mounjaro, and Zepbound, the food noise stopped or was substantially reduced.

I haven’t taken any of those drugs, but I’ve found that food planning reduces a lot of the food chatter.

Not only can we plan our grocery list, but we also enter the day knowing we need to take something out of the freezer to thaw. We have a quick five-minute conversation about tomorrow’s food. Gone are the 20-minute debates about what we’re in the mood for for dinner, which inevitably ended in an emergency call to the local Domino’s.

Would planning tomorrow’s meals ahead of time reduce food stress in your household? Let us know in the comments below.


You can follow my day-to-day project updates on social media. Be sure to subscribe to my weekly update newsletter, and follow me on Twitter/X at @DavidGewirtz, on Facebook at Facebook.com/DavidGewirtz, on Instagram at Instagram.com/DavidGewirtz, on Bluesky at @DavidGewirtz.com, and on YouTube at YouTube.com/DavidGewirtzTV.





Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


Lincolns often get written off as just fancy Fords, but that really undersells what they’re trying to do. Sure, they share parts underneath, but Lincoln usually goes all-in on making things feel quieter, softer, and more premium inside.

A good example is the Lincoln MKC from about a decade ago. It’s closely related to the Ford Escape, but the way it drives and feels puts it closer to compact luxury SUVs like the BMW X3 than you might expect.

Fast-forward to today, and depreciation has done its thing. That same MKC has quietly become a bit of a bargain if you’re shopping used and trying to avoid modern new-car prices.

In order to give you the most up-to-date and accurate information possible, the data used to compile this article was sourced from BMW and Lincoln, as well as other authoritative sources including CarBuzz, CarComplaints (1/2), and RepairPal.


Close-up shot of the dashboard of a 2024 Toyota RAV4 at night with its ambient lighting.


Luxury Car Features That Are Now Available in Affordable Vehicles

Even the most affordable cars now offer luxury experiences with advanced technology and premium comforts once reserved for high-end models.

Lincoln’s quiet shift into compact luxury

How the brand moved beyond its old-school limo image

2009-2011 Lincoln Town Car Silver Front View Driving Credit: Lincoln

For a long time, Lincoln was all about big, plush sedans and the heavyweight Navigator SUV. It wasn’t really a brand people thought of for small, everyday crossovers.

That started to change when luxury makers began chasing more mainstream buyers with compact SUVs. Lincoln stepped in with models like the MKC, especially after Mercury was shut down in 2010 and Ford needed Lincoln to cover more of that “premium but not outrageous” space.

Lincoln jumped straight into the segment with the MKC, which first appeared as a lightly disguised concept at the 2013 Detroit Auto Show. It then reappeared later that year in near-production form at the Los Angeles Auto Show.

Static side profile shot of a white 2013 Lincoln MKC Concept. Credit: NetCarShow.com

Sales began for the 2015 model year, backed by a marketing push starring Matthew McConaughey. His moody, slow-burn commercials helped give Lincoln a more modern image and got people talking.

The strategy worked, especially with younger luxury buyers. Around half of MKC buyers were new to Lincoln, many coming from Mercedes, Lexus, and BMW.

The MKC shared its front-wheel-drive architecture with the third-generation Ford Escape and stayed on sale through 2020 before being replaced by the current Lincoln Corsair. Despite that mainstream foundation, it still managed to feel properly upscale in day-to-day driving.

It launched at just under $34,000 for 2015 and came loaded with features, punchy turbocharged engines, and one of the quieter, more relaxed rides in its class. For a vehicle with Escape roots, it did a surprisingly good job of feeling like something more premium.

Static rear 3/4 shot of a silver 2015 Lincoln MKC. Credit: NetCarShow.com

Lincoln gave the MKC a pretty big refresh for 2019, and that’s the version most buyers should be looking at today. It brought a cleaner front-end design, a nicer interior, and more standard tech across the board.

On top of that, it refined what was already a fairly comfortable, quiet SUV. The result is a 2019 MKC that feels even more like a genuine alternative to the BMW X3 than earlier models did.


2026 Buick Envision


Forget the Lexus NX—This American SUV offers more value for less money

This hidden gem from GM may outshine the NX terms of value and features.

How the MKC holds up today

A budget luxury SUV that still feels surprisingly refined

The 2019 MKC came with two turbocharged four-cylinder engines, with the more powerful one reserved for higher trims. That engine was paired exclusively with all-wheel drive, pushing fully-loaded Black Label models close to $50,000.

By comparison, the 2019 BMW X3 started around $41,000 with its turbo four, offering similar real-world performance but in a more tightly engineered package. The Lincoln doesn’t really try to win on dynamics—it leans hard on equipment instead.

Even base MKC models were well-equipped with 18-inch wheels, a power tailgate, parking sensors, remote start, a Wi-Fi hotspot, Apple CarPlay, and Android Auto. Forward collision warning and automatic emergency braking were standard, while blind-spot monitoring, lane-keeping assist, cross-traffic alert, and active park assist were available higher up the range.

The X3, despite its higher price, made Apple CarPlay part of an optional package and didn’t offer Android Auto at all.

2019 Lincoln MKC

2019 BMW X3

Engine

2.0-liter inline-4 turbo

2.3-liter inline-4 turbo

2.0-liter inline-4 turbo

3.0-liter inline-6 turbo

Transmission

6-speed automatic

8-speed automatic

Drivetrain

FWD/AWD

AWD

RWD/AWD

AWD

Power

245 hp

285 hp

248 hp

355 hp

Torque

275 lb-ft

305 lb-ft

258 lb-ft

369 lb-ft

0–60 mph

7.5 seconds (est)

6.8 seconds (est)

6.0 seconds

4.6 seconds

EPA fuel economy

18–20 mpg city / 25–27 mpg highway / 20–23 mpg combined

20–23 mpg city / 27–30 mpg highway / 23–26 mpg combined

Starting MSRP

$33,995

$43,035

$41,000

$54,500

Inside, the MKC is very much focused on comfort. The front seats are soft, supportive, and come standard with heating, which on the X3 was only available through an extra package.

You also get 12-way power adjustment with four-way lumbar support, while the BMW sticks to 10-way seats without power lumbar adjustment. It’s a clear win for the Lincoln on everyday comfort and convenience.

Materials up front are generally decent, but things do feel a bit cheaper as you move into the rear. Rear headroom is also on the tight side, especially with the panoramic roof, and that’s where the X3 pulls ahead.

The BMW also has a noticeable advantage when it comes to cargo space.

Make and model

2019 Lincoln MKC

2019 BMW X3

Headroom front / rear

39.6 inches / 38.7 inches

41.1 inches / 39.1 inches

Legroom front / rear

42.8 inches / 36.8 inches

40.3 inches / 36.4 inches

Cargo space behind rear seats / maximum

25.2 cu ft / 53.1 cu ft

28.7 cu ft / 62.7 cu ft

Dimensions L/W/H

179.2 inches / 73.4 inches / 65.2 inches

185.9 inches / 74.4 inches / 66.0 inches

On the road, the MKC is more composed than you’d expect, and even a bit sporty if it’s fitted with the adaptive dampers. It doesn’t come close to the X3 for steering sharpness or overall balance, but it’s more capable than its comfort-first image suggests.

The BMW still feels like the better driver’s SUV, thanks to its rear-wheel-drive foundation. It delivers tighter body control, better feedback, and a more cohesive feel overall.

The MKC’s engines are responsive enough for everyday driving, but they’re not exactly exciting. The X3, on the other hand, feels more energetic across the board, with a sharper turbo four and a much stronger inline-six option—though you’ll pay a lot more for it.


Front 3/4 shot of a 2026 BMW iX3


How BMW Takes the Fight To Tesla With the New 2026 iX3

BMW has just revealed its all-new 2026 iX3, a sleek electric SUV designed to rival Tesla with cutting-edge tech, bold design, and impressive range.

What you’ll pay for a used MKC today

Luxury SUV comfort without the luxury price tag

Looking on the CarBuzz Marketplace, used MKCs are still surprisingly affordable, even for later models with lower mileage. As mentioned earlier, the 2019 version is the one to aim for thanks to its updated styling, tech, and overall refinement.

With around $15,000 to spend, you get a lot of SUV for the money considering the standard equipment. Prices can start near $10,000, but those examples usually come with well over 100,000 miles.

Push closer to that $15,000 mark and the options open up quite a bit. Clean 2019 MKCs with around 60,000 miles or less start to become realistic, making it feel like a proper bargain.

Most listings come with the standard 2.0-liter turbo engine, while AWD typically doesn’t add much to the price. The more powerful 2.3-liter turbo usually costs a bit more, often a couple thousand dollars extra.

Dynamic front-end shot of a white 2019 Lincoln MKC. Credit: NetCarShow.com

Compared to the 2019 BMW X3, the MKC looks even more tempting, since clean X3s with under 100,000 miles rarely drop below the $15,000 mark. Based on CarBuzz pricing trends, the BMW typically costs about $4,300 more on average, although there are far more listings to choose from.

That said, there are a few things to keep in mind. The 2019 MKC has above-average reliability ratings from RepairPal, but it’s not completely trouble-free.

CarComplaints has reported recurring engine issues, especially coolant intrusion problems with the 2.0-liter that can lead to serious failures. The optional 2.3-liter turbo is generally considered the safer bet, with stronger performance and better long-term durability.

Earlier MKCs can show similar issues, so it’s important to check service history carefully. A full pre-purchase inspection is a must before committing to any example.

Dynamic rear 3/4 shot of a white 2019 Lincoln MKC. Credit: NetCarShow.com

The 2019 X3 generally scores better for reliability, but it’s still not completely problem-free. CarComplaints notes reports of coolant leaks, cooling system failures, and the odd electronic issue, especially as mileage climbs.

The six-cylinder models tend to be seen as the most solid and desirable, but they also come with a much higher price tag on the used market. And like most older BMWs, running costs and repairs can end up being noticeably higher than what you’d typically see with domestic brands.


Front 3/4 shot of a 2019 Lexus UX


10 Used Hybrids That Deliver Luxury On A Budget

These 10 used hybrids offer premium features, smooth rides, and great efficiency—proving you don’t need to spend big for luxury.

Luxury SUV value, but not without trade-offs

Big comfort and low prices, balanced by a few ownership risks

Static front 3/4 shot of a white 2019 Lincoln MKC parked on a driveway. Credit: NetCarShow.com

For buyers willing to live with a few compromises, the Lincoln MKC offers a lot of luxury SUV for not much money. A clean 2019 example can undercut a comparable BMW X3 by thousands while still bringing strong comfort, plenty of features, and decent performance.

That said, it’s not a totally worry-free buy. Known issues—especially around the 2.0-liter engine—can take some of the shine off the deal. Shopping carefully and leaving room in the budget for potential repairs is key if the MKC’s bargain pricing is going to stay that way.



Source link