Filtering the selectable values in a linked field, depending on the value in another linked field

[Daniel_May]

Hi,

I’m wanting to create a table with functionality such that:

The “Name” of session Making Software is classified by “Topic” and “Subtopic”.

Now, “Topic” is a linked to a list of records in the Topic table:

This is pretty straightforward. And you can see that the Topic table links to a Subtopic table, with subtopics for each topic.

When creating Sessions, I’d like to:

• Create a new Session record and specify the name (e.g. Making Software)
• Then select one of the Topics for that record (e.g. Computers)
• And then when I go to Subtopic for the Session … only subtopics for the topic are displayed and selectable (i.e. Apple & Windows are displayed, not Dyson)

Is there some capability in AirTable that says: display the linked records for this table, but only those whose field matches that which is in this column?

I hope that’s sufficiently clear :slightly_smiling_face:

Thanks,
Daniel

[ScottWorld · Accepted solution]

Currently, there is only one known way to do this in Airtable, and it is outlined in this thread:

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…