Conditional Multi-Selection Field

[Joshua_Todd]

How can I change the the multi-select options based on whats chosen in a previous multi-selection field. For Example, if I have 2 multiple selection fields: Field 1 for State and Field 2 for City, if I choose New Jersey, only New Jersey cities would then be in field 2

[W_Vann_Hall]

I’ve got the first pass at a technique supporting conditional conditional logic (that is, conditional logic — but only under certain conditions :winking_face: ) nearly complete – check ‘Show and Tell’ in a couple of hours.

[Elias_Gomez_Sai]

Justin_Barrett:

That’s not something that Airtable can do yet (as far as I know).

And that’s why I am explaining another way.

Anyway, you know what City are you looking for, so why you need to select the State first? It does not matter to select the city, and then the city is populated automatically.

[Justin_Barrett]

Elias_Gomez_Sainz:

Anyway, you know what City are you looking for, so why you need to select the State first?

There’s a lot that we don’t know about Joshua’s situation. Maybe the end user of his base/table doesn’t necessarily know the city up front, and the state needs to come first. Or maybe they want to ensure that city names are spelled correctly, so the user has to choose it rather than typing it. I don’t know. In any case, I’ve seen interfaces that operate the way that Joshua described, so I’d prefer to give him what he wants (if it’s possible; I’m very eager to see what @W_Vann_Hall is brewing).

[Elias_Gomez_Sai]

Justin_Barrett:

There’s a lot that we don’t know about Joshua’s situation

Of course, I write based on the things we do now.

Elias_Gomez_Sainz:

NOTICE: THIS IS NOT A SOLUTION TO THE ORIGINAL POST, BUT A WORKAROUND WHERE YOU ONLY HAVE TO SELECT THE CITY TYPING IN THE SEARCH BOX (IF YOU KNOW HOW IT IS SPELLED -WHY NOT?-), AND THE STATE POPULATES AUTOMATICALLY.

Better?

[Justin_Barrett]

Elias,

It was neither my desire nor intention to turn this discussion into a confrontation. I value your contributions to the forum. If something I said made you feel like I was attacking you or your recommendation, I’m sorry.

The solution you and others offered—to begin with the city—is a great alternative, and it may very well work for Joshua’s needs. The reason I made my initial comment pointing out Joshua’s state-first-city-second request is because sometimes a request gets misinterpreted for any number of reasons, and people offer solutions that go a different direction. I’ve done that plenty of times myself, in this forum and elsewhere. I wasn’t sure if that was the case here, so I simply wanted to clarify Joshua’s initial request in case this might be one of those times. That’s all.

[Antonio_Lino]

I am also waiting for something exactly as you described, to use in a sales table, so I can choose only specific salesperson based on their city

[W_Vann_Hall]

It took me longer than a couple of hours, but my first cut at conditionally limited choices can be found here. However, it works with linked records, not with single- or multi-selects.

[Antonio_Lino]

Hi W_Vann_Hall
thanks, works exactly as I need
airtable should follow your example!!!

[Christine_Kight]

and maybe still are :slightly_smiling_face: