Jun 06, 2022 12:01 PM
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?
Jun 06, 2022 12:26 PM
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.
Jun 08, 2022 07:52 AM
I’ll take a look and try to figure it out. Thanks.
Jun 09, 2022 08:53 AM
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.