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

Question

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 Answer

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…

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded