Recipe Book, Meal Scheduler, Grocery List

[Patrick_Ford1]

Hi everyone,

Originally I started making this for my wife, but she decided to use another app instead so I figured I would finish it out and share it.

https://airtable.com/shrXDCU2NXyGNLVV5

Summary

This base is designed to hold recipes and then use those recipes to schedule meals and create shopping lists using the IFTTT applet with the trigger “When a new record is created in view”.

It’s a great way to keep track of recipes you like. The meal planner uses a simple form view so that you can choose existing recipes and then the date on which you want to make them. The shopping list view takes what meals you have scheduled and looks up the ingredients. This view only shows what meals are within the next week, but if you shop more or less than once a week, you can adjust accordingly in the filter. While the shopping view shows the ingredients for each recipe, you can use IFTTT or Zapier to create a shopping list using ToDoIst or other listing app to create a compiled shopping list. This is especially useful since Airtable only supports Grid view on the Airtable app. It makes shopping a breeze. Then, at the end of each shopping trip, simply delete the list, and the process starts over, without any adjustment to Airtable.

Feel free to copy and customize the base to suit your needs as it’s built based on my preferences.

If you have any questions or suggestions on how to make this Base better, please reply or email me! I’m always open to questions or improvements!

Thanks!

[Justin_Barrett]

Can you be more specific about the steps you’re taking to build the email? There’s likely a way to format the list more cleanly, but it would help a ton to know what you’re working with.

[Patrick_Ford]

I’m basically just building it with HTML, but my issue is that the .json blob being sent from Airtable is from a long text field so it just lumps it all together. Is there a way to delimit what’s in the field and have it easily parsed and placed into an HTML email?

[Justin_Barrett]

One way to do that is to parse the text in Airtable, building the HTML in a formula field based on what’s in the long text field, and then send that HTML via JSON instead of the raw long text content.

[Patrick_Ford]

Ah man that’s brilliant. I’ll give that a shot for sure!