Hello Airtable community! I need your precious help as I’ve been spending the last 2 days trying to figure this out and can’t seem to do what I want done here…
In one table I have a field name “Country” and another field right next it that’s named “States”.
I am trying to show a selected number of options in the “States” field based on what has been selected in the “Country” field.
e.g: I choose “USA” between all other countries available in the (single-select!) field “Country” and I want the field “States” to return ONLY the results corresponding to States with the USA.
So, depending on what’s selected in field “Country”, it needs to show only a few selected options in the field right next to it.
If I choose “USA”, I want the column next it to give me the 50 states (Choosing between California, Nevada, etc)
If I choose “CANADA”, I want the column next it to give me the canadian states only! etc…
I have tried creating a different table with all information included, per country and use the linking record and even tried the formulas but somehow I cannot seem to find a way to make it simple and keep going around, which becomes very frustrating…
What you’re looking for is called a “conditional value list” or a “dynamic value list” or a “dynamic dropdown menu”.
Unfortunately, this isn’t a feature that is built into Airtable, although I wish it was! This has been one of the top feature requests from Airtable customers since Airtable's inception.
If you’d like to do this in Airtable, there is one known hack to make this happen, but it has lots of limitations and it can only be used in an Airtable system where ONE PERSON will be doing data entry at a time. It's really not a feasible solution.
However, the good news is that as of November 2023, there are now 2 external apps that offer this functionality: Fillout and Noloco:
1. Fillout is the most advanced form software for Airtable. It natively communicates with Airtable in real time, and it gives tons of advanced features that are all Airtable-specific. I gave a brief demo of Fillout on this episode of the BuiltOnAir Podcast.
However, if someone REALLY needs a database system that has this feature natively built into it, I would highly recommend turning to FileMaker. I used to be a FileMaker Developer for almost 30 years before becoming an Airtable consultant. Feel free to reach out to me through my website if you'd like me to turn you onto some excellent FileMaker developers (or if you just need some advanced Airtable consulting).