Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Specify number of each linked record on airtable

117 1
Showing results for 
Search instead for 
Did you mean: 

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!