I am new to airtable and trying to complete a table that has a single select choice in column A for make of the car and I want to have a single select choice in Column B that is contingent on the choice made in Column A…i.e. If Ford is chosen in Column A, then the only choices that are present to you in Column B are Explorer, Escape, Expedition, Fusion, Mustang, Thunderbird. But if your choice in Column A is Mercedes then the choices you have to choose from in column B are C Class, E Class S Class, or SUV, etc
Welcome to the community, @shari_dorenkamp!
You’re looking for what is sometimes called a “conditional value list” or a “dynamic value list”.
Unfortunately, that isn’t a built-in feature of Airtable, although I would recommend adding it as a feature request in the #show-and-tell:product-suggestions category.
However, there is a workaround that you can use to create the behavior that you’re looking for — but it depends on only one person creating new records at a time:
Hope this helps!
Ha, you’re welcome! :slightly_smiling_face:
If you have a budget for your project and you need to hire a computer person to help you implement this solution, that’s what I do for people! I am expert Airtable developer. Feel free to send me a private message or contact me through my website at ScottWorld.com.