Specify number of each linked record on airtable

581 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

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
Screenshot 2022-09-10 at 10.22.37 AM

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!