Duplicating fields, for 1-6 products the same questions?

[Andrea_temp]

Hi there, I have a form/table to help customers request between 1-6 products.

do i just copy and paste the same fields 6 times in case the customer wants 6? or, there must be a better way?

TY!

[Zollie]

UPDATE: Please see the bottom solution instead.

Depends. If customers are only selecting one of each product, you can try changing the field type to multi-select.

It’ll look like this:

Products (multi-select)
Product1, Product3

But if they need to specify quantity, I’d probably split it up. So:

Product 1 (checkbox)
X
Product 1 Quantity (integer)
5
Product 2 (checkbox)
X
Product 2 Quantity (integer)
2
…

[Andrea_temp]

Hi - yes, ty so much - each product has a different quantity…

[Zollie]

UPDATE: Please see the bottom solution instead.

Another idea (which has scaling limitations as well).

Product 1 (single select)
Oranges

Product 1 Quantity (integer)
3

Product 2 (single select)
Apples

Product 2 Quantity (integer)
2
…

Ideally you’d have a dynamically growing interface as demonstrated below, but Airtable doesn’t yet support it.

Product (single select): Oranges
Quantity (integer): 2
[+ button to add another product]

[Zollie]

Not sure why I didn’t think of this before, but linked records is the proper solution. If you split orders and products into separate tables, you can have users generate multiple products per order form. In the Orders table there is a field called Products which will contain references to rows in the Products table.

Orders (table)
Products (linked record field)

Products (table)
Quantity (integer field)
Color (single select field)
…