Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Project/task relational data - how best to organize information

Topic Labels: Base design
299 0
Showing results for 
Search instead for 
Did you mean: 

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:


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

0 Replies 0