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?
Tracking amount used in different products
This topic has been closed for replies.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.