Ask AI

Linked List

How to configure linked lists through a List Details block.

As an example let’s say you want to show a main list of e.g. projects, and upon clicking on a specific project, you want to display this project’s details, including this project’s associated tasks. Here’s how you can do it using Airtable data source as an example.

👉
Linked lists work with all supported Data Sources.

Setup

  1. Create a "Projects" table
    1. Projects table
      Projects table
  1. Create "Tasks" table to hold task-related data, including a field referencing the associated Project. It can be a Lookup field that looks up the Name field from the Projects table, but it can also be a regular field that contains the names of the projects, as in the example below.
    1. Table with tasks
      Table with tasks

Implementation

  1. On e.g. “Projects” page, add a List block linked to the Project Airtable table as shown below.
List block with projects
List block with projects
  1. On e.g. “Project details” page, add a List Details block, again linked to the Projects Airtable table.
  1. On this detail page, add also a List block, linked to the Tasks Airtable table
 
Task list added to the Project details page
Task list added to the Project details page

Configuration

As soon as you add the Tasks list to the project's details page, you'll see that the Projects table's fields will start appearing inside Conditional Filters of the Tasks list block.

Projects table inside Task List's conditional filters
Projects table inside Task List's conditional filters

Using this, we can now set a condition to filter the Tasks list to show only the tasks that are associated with the project that's currently opened in the page. The condition will be set as shown below.

Setting the filtering condition
Setting the filtering condition

So, only the tasks for which the value in the Project column corresponds to the current project's Name will be shown.

Result

Let's check how that works for the Ad Campaign project that includes two tasks (assigned to steven@softr.io and joanne@softr.io).

Testing the result
Testing the result

That's it. Now, each project details page will also show all the tasks associated to it.

Did this answer your question?
😞
😐
🤩

Last updated on July 25, 2024