- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 01, 2017 09:07 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 26, 2018 07:07 AM
+1 for the feature request. This is a must have for automating a workflow.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 26, 2018 07:10 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 27, 2018 02:04 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 03, 2018 08:53 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2018 05:11 AM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2018 09:37 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sep 12, 2018 11:03 AM
Exactly - Thanks @Jeremy_Oglesby. (Also thanks for correctly identifying me as a she not a he. LOL)
Hope that answers your question @Emil_Lilja?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 19, 2019 09:09 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 21, 2019 01:52 AM
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.
- Create a Cities table.
- Add a State field to that Table, and add the records for the Cities with their States
- In the People table, add a Linked Record field to Cities.
- 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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 21, 2019 08:19 AM
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).