I’d like to be able to create the following column:
Product(s)/Quantity (Key/Value Multi-Select)
Oranges: 4
Apples: 2Oranges:3
Bananas: 1
Why Alternatives are Insufficient
Multiple Columns
Separating the product from the quantity means that data is disassociated unless each option has it’s own columns (Oranges, Oranges Quantity). So solutions are verbose and the bases grow unnecessarily wide.
Advanced Linking
Another approach would be to separate each product as its own line item (or table row), or even split them out to separate tables. All of this is too much to ask from a client using a form view or a non-Airtable savvy user.