I am trying to set up a base that lets me plan out my purchasing for the next year. I have something similar set up in Google Sheets, but was hoping for more views and control by moving it to Airtable.
In my base I have a recipe book table (BoM) that says, for example, for a cake I need 50 flour, 20 sugar, 5 strawberries. For cookies I need 20 flour, 10 sugar, 30 chocolate chips. The structure of that table is:
(Concat A and - and B) | Final product | Ingredient | Quantity
Cake - Flour | Cake | Flour | 50
I have table that is a schedule of things I am planning on making (Build Schedule). The structure of that table is (currently)
Month Year | Cake | Cookies
September 2021 | 30 | 28
October 2021 | 50 | 80
Want to create a table that will plan out what ingredients I need to have by each month. For example:
Ingredient | Qty on hand | Multiple | Needed his month | To buy this month | Amount remaining after this month | Needed next month | etc.
Flour | 0 | 200 | 2500 | 2600 | 100 | 2200 etc
And then next month it automatically changes the calculation so that “This Month” is October instead of September, etc.
Is this even possible to do with Airtable or should I be looking for a different tool? Like I said, I have this working in a spreadsheet, but I would love to have customizable views I can share with different people, and data that’s less fragile when I decide I need to work in a new features (such as scheduled deliveries)
Thanks in advance!