Skip to main content

Can we connect two “multi select” rows with each other?

  • February 20, 2020
  • 5 replies
  • 43 views

can we connect two “multi select” rows with each other? Example:
Column 1: A, B, C
Column 2: 1,2,3
We would like to associate A with 1, B with 2 and C with 3.

In a nutshell, what we’re trying to do is this: For each software developer in our database, we want to display the number of years they have in a specific technology. Say 5 years in PHP or 2 years in Airtable etc

Can this be done?

5 replies

Mohamed_Swella1
Forum|alt.badge.img+17

Hi @Dstep,

You won’t be able to have a multi select field that changes, the field should be a Formula field. You can use this Switch({Coulmn1}, ‘A’, 1, ‘B’, 2, ‘C’, 3)


  • Author
  • New Participant
  • February 20, 2020

Hi @Dstep,

You won’t be able to have a multi select field that changes, the field should be a Formula field. You can use this Switch({Coulmn1}, ‘A’, 1, ‘B’, 2, ‘C’, 3)


That won’t work for us I don’t think because our values change. No other way eh?


Mohamed_Swella1
Forum|alt.badge.img+17

That won’t work for us I don’t think because our values change. No other way eh?


Hi @Dstep,

Please show me a screenshot of your current setup and maybe I have another solution. Maybe a Lookup Field?

BR,
Mo


  • Author
  • New Participant
  • February 20, 2020

Hi @Dstep,

Please show me a screenshot of your current setup and maybe I have another solution. Maybe a Lookup Field?

BR,
Mo


Hi Mohamed,

This is what I’m trying to accomplish.


Mohamed_Swella1
Forum|alt.badge.img+17

Hi Mohamed,

This is what I’m trying to accomplish.


Hi @Dstep,

And how is your current setup? Screenshot your table.