Skip to main content

Specify number of each linked record on airtable

  • September 9, 2022
  • 1 reply
  • 13 views
L

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

    TheTimeSavingCo
    Forum|alt.badge.img+31
    • TheTimeSavingCo
    • Brainy
    • 6460 replies
    • September 10, 2022

    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:

    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:

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

    Adam, Airtable Consultant - thetimesaving.company


    Terms & ConditionsAccessibility statement