Hi everyone! I’ve created a base with two tables:
- Projects
- 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