Inventory Base - add quantity for each item in one order?

Topic Labels: Base design
1340 3
Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect

I’m sorry, I’m a little new to this. I have built an inventory base to keep track of inventory or orders, i used a template from the Airtable universe.

In the Incoming table there is a list of the orders (orders from me to the head office, and customer orders), I’m not sure how to create a way to specify the quantity of each item.

Any idea and the best way to do this?

3 Replies 3

You need another “line item” table to show how many of each item was logged. Keep your Incoming table as is except instead of linking directly to products, you’d link to line item records which would have the product and the quantity stored.

Follow this example of of a base that includes a line items table.

I’ll take a look and try to figure it out. Thanks.

We just released an E-commerce base template with line items and many other things. It’s free to download if you want to check it out.

Hannah - - Automated Backups for Airtable