Skip to main content

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

Is there a way to make a logic select type?

For example, I have a Field1 and Field2

I want to make If Field1=A then Field2 has PackA of selecting items,

if Field1=B then Field2 has PackB of selecting items.

Is there a way to realize it?


From what I hear, they’re working on this one. 🙂


Any update here with this? I was trying to do the same thing if type = P then it returns options for picking only from the types that relate to P


I was actually just logging into the forum to ask for this! Would love to know if there’s an update.


Since it has been a while, is there any update on the process?


Same problem.


How i can have selection depends on selection in previous field.


Thank you


Same problem.


How i can have selection depends on selection in previous field.


Thank you


features features missing features ! i like the product but I am super surprised that small features like multi-select based on another table (reference data for multi-select), conditional multi selection, etc etc. does not exist !


features features missing features ! i like the product but I am super surprised that small features like multi-select based on another table (reference data for multi-select), conditional multi selection, etc etc. does not exist !


agree - badly needed! any workarounds for this?? @airtable


Like you, I require the use of City/State on one of my tables. However, I do it a little differently with a formula. I created a formula, so that when the zip code is entered into a number field, the city and state automatically populate. I really like this way. However, every time I enter a new zip code, I have to add it to my formula field. I tried to jump the gun and found a list of every zip code in the state that I am primarily in and go ahead and create the formula for that state, but sadly, airtable limits the lenght of a formula that you have. I think I found the max to be around 350 IF() formulas branched together in one field.


I have not yet reached that in my table, but I know that it will eventually come, and I will have to find a different way to put the city and state. It will most likely be to enter the city and state manually in a single line text field. I really hate that airtable doesn’t offer something like this for the users that require city and state inputs in their table. I really hope that I find another way to auto-populate the city and state soon, as I am rapidly approaching the max in my table.


+1 for the feature request. This is a must have for automating a workflow.


Seems like there’s a few threads asking for the same thing. Is there a way to tag one of the threads to get an update from airtable directly on it?


The original question (9 months ago) could be solved by having a separate table with all the City + State values in 2 columns and a 3rd Formula concatenating them together (City, ST).

On the original table make a column for ‘link to another table’ instead of a multi-select and then as the city is typed and selected, you can make a lookup column that pulls in the State field from the the other table.


I was actually just logging into the forum to ask for this! Would love to know if there’s an update.


Same here. I logged in here to ask the same question.

Would be great to have this option intregrated.

I have one field (Field1) with “signle select”, and another field that should have a pre-defined dropdown menu, based on what has been selected in Field1


EDIT: seems that this is an easy solution. Thanks @Noel_Howell


Hey @Noel_Howell. How would a formula like that look? Currently building a base from scratch and I’m new to how the formulas work. Thanks!


Hey @Noel_Howell. How would a formula like that look? Currently building a base from scratch and I’m new to how the formulas work. Thanks!


I assume you are referring to the formula she mentions for “concatenating” the city and state…?


It would look like this, if you have a field called City, and a field called State:


{City} & ", " & {State}

You can use the & symbol to easily “concatenate” (combine together) data as “strings” (collections of letters, numbers, punctuation, and white spaces). So this formula will first put the city name (retrieved from the City field in that row) as a string, followed by a comma and a space, and then put the state name (retrieved from the State field in that row) as a string.


I assume you are referring to the formula she mentions for “concatenating” the city and state…?


It would look like this, if you have a field called City, and a field called State:


{City} & ", " & {State}

You can use the & symbol to easily “concatenate” (combine together) data as “strings” (collections of letters, numbers, punctuation, and white spaces). So this formula will first put the city name (retrieved from the City field in that row) as a string, followed by a comma and a space, and then put the state name (retrieved from the State field in that row) as a string.


Exactly - Thanks @Jeremy_Oglesby. (Also thanks for correctly identifying me as a she not a he. LOL)


Hope that answers your question @Emil_Lilja?


Exactly - Thanks @Jeremy_Oglesby. (Also thanks for correctly identifying me as a she not a he. LOL)


Hope that answers your question @Emil_Lilja?


I’m still not clear on this, I am trying to create a multiple select field that will populate a conditional set of options depending on what is in another column. So, in the example of the cities and states: If I create a second table with cities and states, what am I to put in the original table to call up the specific cities as multiple select options when a specific state is selected in its respective column? The formula offered above does not seem to answer this question. Thanks in advance for any guidance!


I’m still not clear on this, I am trying to create a multiple select field that will populate a conditional set of options depending on what is in another column. So, in the example of the cities and states: If I create a second table with cities and states, what am I to put in the original table to call up the specific cities as multiple select options when a specific state is selected in its respective column? The formula offered above does not seem to answer this question. Thanks in advance for any guidance!


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.


Let’s say you manage People and you want to add their City.



  1. Create a Cities table.

  2. Add a State field to that Table, and add the records for the Cities with their States

  3. In the People table, add a Linked Record field to Cities.

  4. Add a Lookup field for State, that gets the State from the previous City linked record field. The Formula field is optional to join both and get something like Los Angeles, CA.


The MultiSelect field type has nothing to all of this because by now it is not dynamic, it’s static with the values you enter in its configuration.


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.


Let’s say you manage People and you want to add their City.



  1. Create a Cities table.

  2. Add a State field to that Table, and add the records for the Cities with their States

  3. In the People table, add a Linked Record field to Cities.

  4. Add a Lookup field for State, that gets the State from the previous City linked record field. The Formula field is optional to join both and get something like Los Angeles, CA.


The MultiSelect field type has nothing to all of this because by now it is not dynamic, it’s static with the values you enter in its configuration.


That solves the problem when someone begins with a city, but that’s not what the original question from @Joshua_Todd (or the follow-up from @Anna_Perlmutter) is about. Joshua was asking about the reverse: the user begins by choosing the state, which then narrows down the available list of cities in an adjacent field to those only within the chosen state. That’s not something that Airtable can do yet (as far as I know).


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.


That solves the problem when someone begins with a city, but that’s not what the original question from @Joshua_Todd (or the follow-up from @Anna_Perlmutter) is about. Joshua was asking about the reverse: the user begins by choosing the state, which then narrows down the available list of cities in an adjacent field to those only within the chosen state. 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.



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.



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).


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.


Let’s say you manage People and you want to add their City.



  1. Create a Cities table.

  2. Add a State field to that Table, and add the records for the Cities with their States

  3. In the People table, add a Linked Record field to Cities.

  4. Add a Lookup field for State, that gets the State from the previous City linked record field. The Formula field is optional to join both and get something like Los Angeles, CA.


The MultiSelect field type has nothing to all of this because by now it is not dynamic, it’s static with the values you enter in its configuration.



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



Better?



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



Better?


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.


That solves the problem when someone begins with a city, but that’s not what the original question from @Joshua_Todd (or the follow-up from @Anna_Perlmutter) is about. Joshua was asking about the reverse: the user begins by choosing the state, which then narrows down the available list of cities in an adjacent field to those only within the chosen state. That’s not something that Airtable can do yet (as far as I know).


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


Reply