Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate different resource cost against different jobw

Solved
Jump to Solution
164 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

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