I’m trying to track material use among different products. Each material has a unique identifier as well as each product. Materials can be used in more than one product. I’ve figured out how to log what material I have used in each product, but not how much of each material. I would also love to be able to track total of each type of material used. Any suggestions how to set this up?
1 table for Products, one table for Materials, and joining table for Usages. Check this: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships.
In the last table you will can Group By materials or products.