Creating IF statement for Make and models of cars in 2 columns

[shari_dorenkamp]

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

thanks shari

[ScottWorld]

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:

Conditional Logic-ish Linked Records Show and tell

TL;DR version: Airtable’s recently added capability to limit linked-record selection to a specific view allows users to incorporate, to a degree, conditional logic. The specifics: ‘Conditional logic’ can mean a lot of things: Any use of an IF() or SWITCH() statement is a form of conditional logic. Here, I’m using it in what’s become an increasingly common manner: to mean the limiting of available options based on an earlier choice. For example, take a look at the following diagram. [Condition…

You could probably also create this same functionality (without the one-person limitation) by creating a custom JavaScript for these purposes.

Hope this helps!

[shari_dorenkamp]

Thank You! I am not a computer person and this helps because now I can now stop looking for the answer:)

[ScottWorld]

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.

[shari_dorenkamp]

Question…can you link data in a separate base in the same workspace? If so could I great a new base that contains the cars make and model and then link the approproate columns back into my original table?

[ScottWorld]

Yes, you can use Airtable’s new syncing feature to pull in information from another base.