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.