Specify number of each linked record on airtable

Hello, so ive been doing this inventory app for my company and kinda hit a roadblock, so ive created a sales table where a sales record is created with a date, order no., products, price of each product, quantity, discount and a total but what i want to accomplish is that when i put multiple items into a single sales record like in the last record in this screenshot

i want to be able to put how many of each product in that sales record were sold so that the total comes out to be the correct amount

Hi @Luyz, to achieve this you’re going to need a table for line items I’m afraid. I’ve put an example together here

You’d have a Products table with product information, including the price:
Screenshot 2022-09-10 at 10.22.34 AM

A Line Items table where you would put in the Quantity sold where each record was linked to a Product

And a Sales table where each sale can be linked to multiple Line Items:
Screenshot 2022-09-10 at 10.22.40 AM

This would allow you to set the quantity per product and get the correct total!

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.