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
Jun 01, 2020
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!
Jun 02, 2020
Hi @Joseph_James - I would do something like this:
“Assigned to Employee” is a link field to the second table:
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.