Meal Planning: fields autopopulate

Topic Labels: Formulas
797 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I’m trying to make a meal-planning table that will produce a sheet like this:
Screen Shot 2020-07-23 at 8.25.12 AM

Right now I’ve got this:
Screen Shot 2020-07-23 at 8.28.25 AM
What is the best way to efficiently get columns for each ingredient, which will populate with quantities (I have them broken down in another sheet) if that ingredient is listed for that recipe? Heads up, I’m no good at coding. I’ve copied and pasted the exact airtable instructions into the scripting block with no success.


2 Replies 2

Hi @Angie_Belle - I don’t think you can easily get to this layout in Airtable. It is really a custom layout and doesn’t really reflect how that data would be stored in a database. If I was designing this base, I’d end up with a table something like this:

Screenshot 2020-07-29 at 17.36.47

The closest I can get from this to your layout is using the pivot table block which gives this:

Screenshot 2020-07-29 at 17.37.58

But you can’t build in the units of measurement and the pivot table isn’t really designed to do this sort of thing.

It is tempting to have all of the ingredients as fields/columns in one of the tables, but this isn’t a great table design tbh and you’ll come up against scalability issues if you have more than a few ingredients over time.

You might find exporting the data and pivoting it in Excel/GoogleSheets works better.

Sorry I can’t recommend anything!