Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Bread baking journal in Airtable - Linked to another record with quantities

3151 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Thomas_Holth
5 - Automation Enthusiast
5 - Automation Enthusiast

Just for fun I thought about using Airtable as a journal for my bread baking, so that I’ll maybe improve and learn something over time. It’s easy to set up a basic table where I have ingredients as a long text, flour, water and yeast content as number, a rating column and so on…

But, to make it more interesting I thought I could link the bread table with an ingredients table, where I store data for each ingredient, so that I could get nutritional data for each bread I make, according to how much of each ingredient I use. Also I could pull out information on how much I use in total of the different ingredients.

The problem is that I cannot find a way to do this so that I, in the bread table, assign a quantity to each linked ingredient in the ingredients table. Is this even possible in Airtable?

Do anybody have any ideas on this? Help would be appreciated.

4 Replies 4
Oli_Steadman
7 - App Architect
7 - App Architect

Hi Thomas have you explored the “Count” and “Rollup” field types? Pretty powerful - I am linking around 30 tables in one of my bases which all calculate using each other’s numbers.

Happy to help if you can give an example?

Thomas_Holth
5 - Automation Enthusiast
5 - Automation Enthusiast

Alright, thanks. I’ll post something after I tried that.

Valentin_GUENIC
6 - Interface Innovator
6 - Interface Innovator

I’m curious to know how you resolved this…

Thomas_Holth
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @Valentin_GUENICHON

I solved it by using 3 tables in the bread base: a bread table, an ingredients table and a raw material table.

The bread table is linked to the ingredients table, and the ingredients table is linked to the raw materials table. I used lookup and rollup to fetch information between the tables.

The raw material contains all the different flours and seeds I use, together which information about weight, volume to weight ratio (since I use cups when I measure the quantity of flour), brand, energy/100g and price per kilo.

The ingredients table contains all the ingredients used in each spesific bread. An ingredient is a raw material in a certain quantity, i.e. 3 cups of white wheat flour. I also pull into that table some information from the raw materials table to be able to calculate weight and price of each ingredient. I group the table based on which bread each ingredient belongs to. easy see a recipe.

The bread table is a list of all the breads I make. Most of the information in that table is gathered from the ingredients table (total price, weight, energy), but it also contains information such as cooking time and cooking temperature, a comment and a rating, and a photo.

In the end I didn’t really use the base so much, but maybe I will if I start to experiment more with different breads…

Here are screenshots of the tables (They are all in norwegian…):

Bread table:
image.png

Ingredients table:
image.png

Raw materials table:
image.png

Tell me if you would like to know more about the rollup functions and formulas…

-Thomas