Creating a Budgeting and Expense Tracking System

[111144]

Hello community,
Hope that you may help me with this one.
I am trying to build a system that will help my with inventory tracking. So far so good, and there are many great templates and tutorials out there.
HOWEVER, I haven’t figure out yet how to solve my issue: From time to time, employees take equipment from our warehouse for a specific project, and I want to keep track of everything.
I thought about making a table for each time someone takes something, and then finding a way to reduce the amount of available items from the amount of items that went out from our warehouse. but - I have no idea how to do that.
Making a row for each project is not ideal as well, because each project uses several items with different quantitates.

Any suggestions or tips?

THANK YOU!!!

[Aron · Accepted solution]

Hi there,

There are a few ways to do that.

One way is to create a check-in/check out table where you add a record each time someone takes something out or in and then use rollup/count fields to figure out whether it’s in or out (odd number of records -> out, even -> in).

Best
Aron

Want to learn Airtable? Join me for a webinar at airtable.com/webinar