Skip to main content

Field Type: Key/Value Multi-Select

  • January 9, 2020
  • 1 reply
  • 0 views
Z
Forum|alt.badge.img+18

I’d like to be able to create the following column:

Product(s)/Quantity (Key/Value Multi-Select)
Oranges: 4
Apples: 2

Oranges: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.

    1 reply

    M

    I would like to add a use case that this feature would address.

    I am an operations manager who wants to build a directory of contractors. Each contractor can perform multiple roles (Role A, Role B, Role C, etc.) and has a day rate associated with each of those roles.

    I would like to represent this data in the form of an object of key-value pairs such as:

    
{
  "Role A": "$500 USD",
  "Role B": "$350 USD",
  "Role C": "$700 USD",
}

    So on, so forth. I would also like to be able to create a form which allows the contractor to:

    1. multiple select roles (keys)
    2. enter their day rate for each role (values for each key)
    H
    1 person likes this
    • H
      Hadleigh_Waldeg

    Reply


    Most helpful members this week

    Terms & Conditions