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

Simple Inventory

Topic Labels: Base design
363 1
cancel
Showing results for 
Search instead for 
Did you mean: 

I am trying to set up my inventory to track shirts given to my employees. I can’t get the look up and/or roll up feature to work. Here’s what Im looking for…

TYPE OF SHIRT | SIZE | QTY ORDERED | QTY ASSIGNED TO EMPLOYEE | CURRENT INVENTORY

If I could get here I’d be set. I don’t know why i can’t get the look up feature to work or the rollup but please help!

1 Reply 1

Hi @Joseph_James - I would do something like this:

Screenshot 2020-06-02 at 08.50.16

“Assigned to Employee” is a link field to the second table:

Screenshot 2020-06-02 at 08.50.22

You can then use a “count” type field to count the number of shirts assigned, then take this from the original quantity ordered to get the the current inventory.


If this answers your question, please consider marking this as the "solution". If not, please post again for more help. Thanks!