Filtering dropdown field values

[A_Whalen]

Here’s a hypothetical scenario that describes what I’m trying to do. Let’s say I have a table that has two fields: author name and genre. I have a second table that tracks books and their genres. I would like to create a dropdown field to select an author name but I only want to see the author names that are in the genre specified in that specific row. Is it possible to use a field in one table to match up and limit the view of the dropdown values from another table?

Sorry if this is confusing.

[ScottWorld]

Hi @A_Whalen,

What you’re requesting is known as a “conditional value list”.

Unfortunately, this is not natively possible in Airtable, but there is one known workaround that one of our community leaders came up with.

You can read more about how to implement his workaround here:

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…

[Justin_Barrett]

Another option would be to use a script in the Scripting block. It would first ask you to pick a genre. Then it would collect a list of all authors matching that genre and let you pick from that list, storing your selection wherever you like. If you’d like help with something like this, just ask.