Multiple Select - Select multiple times

You need a junction Table to have Line Items.

Hi Elias,

Thanks for your fast answer!
I did in fact make a junction table for this issue.
The problem I’m facing at this point is adding certain products twice.
Imagine the following a table containing all products.
The table containing the order lines then shows all products that are used in one order.
However I want to add a certain product twice, instead of just once.
How does that work then?

You could add a “quantity” field so users can identify how many LED bars they require. Now your problem becomes “what if the customer needs an LED bar and an LED bulb?” I’m not sure how to then handle this with Airtable alone.

I use Cognito Forms and Integromat to have multi-entry forms, which in your case would allow you to create multiple order line items from one form submission (2 LED bars, 3 LED bulbs, 1 light shade, etc).

The Product Catalog and Orders base in Airtable Templates offers an example of how to handle multiples of an item.

In my own designs, I often define separate {Amount} and {Multiplier} fields. {Amount} is used if the customer orders more than one of anything; {Multiplier} is a formula field with the formula IF({Amount},{Amount},1). I then display {Multiplier} on the printed invoice, and I use {Multiplier}*{UnitPrice} to arrive at the total price for that line item.