
Zollie

10 - Mercury
Comment Post Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
โJan 09, 2020
12:41 PM
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.
See more ideas labeled with:
1 Comment