Weekly meal plan with shopping list


#1

First off I have learned through this process that I suck at databases, I have learned everything I know (still very little) about them in the past 4 weeks and have gotten my butt kicked.

I am trying to build a weekly meal planning database, that I can export 10-15 meals per week document with compiled shopping list by aisle/area of the grocery store. I am about to pull my hair out. I have used some of the ready-made bases and those get me there partially but I am getting lost in how to compile the weekly shopping list (ingredients compiled and labeled with recipe its associated with) and how to export the weekly meal plan in a separate document (recipe name, ingredients, instructions)

Anyway I have just hit a caffeine and knowledge wall any help or guidance how to pull this off would be much appreciated.
Here are two pics of the tables I have developed


#2

Here is the second photo of what I have


#3

:grimacing::confounded::scream:
Just found another potential issue for me especially when rolling up. Fractions… like 1/4 cup
is there any way to either convert this to .25 or that it will roll this up properly

thanks in advance


#4

Hi @J_J_Gregor,

Would you mind sharing your base to this thread?
What you can do to avoid making the base you are working in later down the road being public is to make a duplicate of your current base (including records would make it easier for me to help you out). Then share that duplicate to this thread. I will then be able to create a copy of your base as it is now, and try to help you out. Then later you can delete the duplicate base that you shared here.

Here’s how you do that if you need help with that:

Then just paste that link into a post here. Like I said, make sure this is a duplicate of your base that you share, that way future forum goers aren’t able to go view your weekly shopping list :wink:.


#5

Awesome thanks!


#6

Ok, so I played around a bit - I created a new table called “Calendar” which you would use to join a recipe onto a date. You can use it in the actual “Calendar” view to flesh out your meal plan for a week, month, etc…

That table pulls in the ingredients and preparation info from the recipe attached to a meal plan date. I created a grid view that filters to show only the recipes planned for the next week, and then I created a quick little Page Designer template that pulls from that filtered view, and combines all the info together into a “card” like view:

And which has printable output that comes out like this:

You can replicate these things into your main base as they are, and then continue to fiddle with them to your liking.

The main thing you were missing was a separate table for planning out your meals. This separate calendar table allows you to create a new “Calendar” item that links to a recipe, rather than having to change the date on a recipe for every new week. This way, all your historical data stays around too - you could even, if you felt so inclined, use this historical data to get statistics, such as how many times you’ve used each recipe. You could add all kids of other fun stuff too - rating the recipes; rating the recipes on a per meal basis instead of on a recipe basis to see if you rate the same recipe the same way each time, etc…

If you have questions about how it all works, ask away.


#7

I LOVE YOU!!! This is awesome!!! Thank you so much!!!


#9

:confounded: oh no!!

I tried to help you avoid that! I would contact support@airtable.com ASAP and explain what happened. Also, if you are using this particular copy of the base for all your stuff, you should duplicate the base, and then delete the one you shared here. All the people you invited to collaborate will not be collaborators on the duplicated base.

Sorry, @J_J_Gregor