Skip to main content

Quantity of Ingredients in Recipe Manager

  • January 12, 2017
  • 7 replies
  • 69 views
V

Well, I’m new to Airtable and have been stuck in this dillema:

I created a table called Recipes (where I log ingredients and other info), and another one called Ingredients (Where I keep average prices, and quantity on stock), so I can keep up with my groceries.
I want to calculate how much will I spend for each recipe, so I can calculate the average dish price.
Is there a way that I can put a value for each ingredient in the recipe (like, 1kg of meat, and 0,3kg of onions ), so I keep my inventory updated?

Below it’s some screenshots of what I’ve got so far…

Thx!

    7 replies

    K
    Forum|alt.badge.img+5
    • Katherine_Duh
    • Inspiring
    • 332 replies
    • January 12, 2017

    To log the quantity of ingredients, you’ll need to make a separate table for recipe line items. Here’s a tutorial on implementing line items (which also contains an explanation of why you need to make a separate table in order to hold information about quantities). The example in that tutorial is related to the product catalog example, but I’ve also built a sample recipe base myself which uses the same concepts:


    Ingredients table, with cost per cooking unit.


    Line items table, which is basically ingredient x quantity per each record


    Recipes table, which uses a rollup field to sum up the total cost of all the line items.

    Let me know if you need more assistance.

    V
    • Vinicius_Foscac
    • Author
    • New Participant
    • 2 replies
    • January 13, 2017

    To log the quantity of ingredients, you’ll need to make a separate table for recipe line items. Here’s a tutorial on implementing line items (which also contains an explanation of why you need to make a separate table in order to hold information about quantities). The example in that tutorial is related to the product catalog example, but I’ve also built a sample recipe base myself which uses the same concepts:


    Ingredients table, with cost per cooking unit.


    Line items table, which is basically ingredient x quantity per each record


    Recipes table, which uses a rollup field to sum up the total cost of all the line items.

    Let me know if you need more assistance.


    Thank You Kat! That’s exactly what I was looking for!

    R
    • Ryan_Anderson
    • New Participant
    • 4 replies
    • August 11, 2017

    To log the quantity of ingredients, you’ll need to make a separate table for recipe line items. Here’s a tutorial on implementing line items (which also contains an explanation of why you need to make a separate table in order to hold information about quantities). The example in that tutorial is related to the product catalog example, but I’ve also built a sample recipe base myself which uses the same concepts:


    Ingredients table, with cost per cooking unit.


    Line items table, which is basically ingredient x quantity per each record


    Recipes table, which uses a rollup field to sum up the total cost of all the line items.

    Let me know if you need more assistance.


    Hi Kat, any chance you’d be willing to share that doc as a template?

    K
    Forum|alt.badge.img+5
    • Katherine_Duh
    • Inspiring
    • 332 replies
    • August 11, 2017

    Hi Kat, any chance you’d be willing to share that doc as a template?


    Feel free to make a copy for yourself using this share link!

    T
    • Tom_Tiernan
    • New Participant
    • 4 replies
    • January 17, 2018

    Is there a template for recipes/ cookbooks?

    I’d really appreciate not having to invent one as this is not my strength.

    Thanks!

    M
    • Marla_McGee
    • New Participant
    • 1 reply
    • November 4, 2022

    This is great thank you for sharing. I have a question, in the cooking unit cost field how is this being calculated?

    H
    Forum|alt.badge.img+4
    • himg1509
    • Participating Frequently
    • 8 replies
    • January 27, 2024

    Is there a template for recipes/ cookbooks?

    I’d really appreciate not having to invent one as this is not my strength.

    Thanks!


    Hi @Tom_Tiernan were you able to find the recipe/cookbook template and willing to share?

    heman


    Terms & ConditionsAccessibility statement