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?
Alright, thanks. I’ll post something after I tried that.
I’m curious to know how you resolved this…
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:

Ingredients table:

Raw materials table:

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