Workspace + Projects Data structure

Need help Database
1

Hi!
I am relatively new to bubble and can’t figure out this issue:
I am trying to create a project management tool that goes from workspaces > projects > tasks.
This is what my database looks like:

Workspace:
Title
Members
Projects

Projects
Name
Description
Tasks

Tasks:
Name
Description etc.

So a workspace can have multiple projects and each project has one workspace. What would be the best way to structure this? When I create a repeating group to display all of the projects can’t figure out how to filter it by workspaces…
Cheers!

2

You can restructure your DB to have columns for the parent instead of this way. See below removals and additions. You can keep the links to the children as well (Projects in Workspace and Tasks in Projects) but this will make the maintenance of these links harder.

Workspace:
Title
Members
Projects

Projects
Name
Description
Tasks
Workspace

Tasks:
Name
Description etc.
Project

1 Like
3

Thanks a lot! That worked!