Hello,
I’m having some trouble linking my database together and ensuring all the data in my database is up to date across the fields of the relevant data types.
This is my current data type set up:
- Workspace
Fields:
- ‘workspace name’
- ‘workspace projects’
- ‘workspace boards’
- Projects
Fields:
- ‘project title’
- ‘project’s workspace’
- ‘project’s boards’
- Boards
Fields:
- ‘board title’
- ‘board’s project’
- ‘board’s workspace’
- ‘board’s tasks’
- Tasks
Fields:
- ‘task title’
- ‘task’s boards’
- ‘task’s workspace’
What I want:
When a user creates a new Workspace, Project, Board or Task, that it adds connects them all in the data types’ respective fields.
ie: So looking at a Task, board, project you can see what board, project and/or workspace it belongs to.
Full disclosure - I’m not sure if this is the most efficient way of the databases’ design, and I’ve only designed it this to to make sure I don’t neglect connecting any information.
In saying this, so far I have a workflow in place that takes the newly created Project and adds it to the Project database but also adds it to the Workspace data type. Unfortunately I can’t figure out a way to add the Project to the Workspace data type without the workflow creating a whole new entry in Workspaces.
I hope this is clear, but if anyone has any recommendations on how to better structure my database, or on how to add data to more than one data type’s field that would be very appreciated. Thanks!
