The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Sep 15, 2022 09:22 AM
Hi
I am trying to create an airtable with resources, rate, jobs no. quantity, amount and total.
To do this I have created a master of inventory type with rate against each item.
Eg: Small Carton $ 5, Large Carton $10 etc.
Now I want to use that data for different jobs numbers. In each job i want to track the different types of resources used, quantity used, cost of each resources and total cost of resources used for each job.
Eg: Job no. 50 -
Small Carton $5 x Quantity 2 = $ 10
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $30
Eg: Job no. 51 -
Small Carton $5 x Quantity 1 = $ 5
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $25
Eg: Job no. 52 -
Small Carton $5 x Quantity 0 = $ 0
Large Carton $10 x Quantity 2 = $ 20
Total Cost = $20
Could you please help.
Thanks
Ajit
Solved! Go to Solution.
Sep 15, 2022 12:43 PM
For more information on creating a junction table, check out this article on many-to-many relationships:
Sep 15, 2022 10:09 AM
Welcome to Airtable Community !
To do that, you have to do a Junction/Line Items table. This table will be linked to Products and to Jobs. In this table, you will enter each line item as a separate record to input the relevant quantity.
Then. using a simple Rollup field with the expression SUM(VALUE) you can get the Total Cost.
Sep 15, 2022 12:43 PM
For more information on creating a junction table, check out this article on many-to-many relationships:
Sep 16, 2022 08:00 AM
Thank you Mohamed. This was a simple solution.
Sep 16, 2022 08:01 AM
Thank you Scott. This gave a detailed explanation of many to many relationship