Project/task relational data - how best to organize information

Hi everyone! I’ve created a base with two tables:

  1. Projects
  2. Tasks

There is a link between both tables so that tasks can be related to projects.

What I’m trying to achieve is something like this:

image

The goal is to visualize all projects to see what tasks are coming up next, and if there are no tasks allocated to a project, that should prompt me to think about what needs to be done. So I’d like to see:

  • A list of all projects regardless of whether there are tasks linked or not
  • The related tasks “nested” under each project
  • Only the open tasks should be shown (anything with the “Complete” field checked should be filtered out)

Does anyone have any suggestions on how best to achieve this? Here’s a link to the base: Airtable - Client Projects

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.