Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Calculate different resource cost against different jobw

Solved
Jump to Solution
1562 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Ajit_Venkatesh_
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

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

See Solution in Thread

4 Replies 4

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.

ScottWorld
18 - Pluto
18 - Pluto

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

Thank you Mohamed. This was a simple solution.

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