Hello! I am new to Airtable and working on setting up inventory for my organization. We have raw materials that are used in different quantities and combinations in different craft kits which correspond to different books. Multiple materials may be in a kit and the number of each material will be different for each kit as well. Some kits go to two or more books.
I currently have a table for book titles, craft kits, and raw materials. I have them linked to each other so that for example, the craft kit “daisy crown” has a field that lists the raw materials needed (white paper, green paper, etc) BUT I’m struggling to figure out how to add the calculation for the number of each material for that craft. A daisy crown requires two sheets of green construction paper whereas other crafts require a different amount. I’d like to link the quantities for each craft so that I can project what I will run out of based on how many kits of each craft I’m making coming up.
If anyone has any solutions or suggestions I’d appreciate it! Thank you!