Skip to main content

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

Hi @Ajit_Venkatesh_R



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.


For more information on creating a junction table, check out this article on many-to-many relationships:




Hi @Ajit_Venkatesh_R



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.


Thank you Mohamed. This was a simple solution.


For more information on creating a junction table, check out this article on many-to-many relationships:






Thank you Scott. This gave a detailed explanation of many to many relationship


Reply