Subtable Views / Filtering Subtables

[Marvin_Schuch]

Hi,

I’m in the process of building a project management system for a small content agency. I tried Notion first but there were to many restrictions regarding databases, formulas and automations. However I am struggling to implement one thing in coda, that could be done in Notion very easily.

I got two Databases:

• Projects
• Tasks

Tasks are related to Projects and I need to be able to open a Project and see, edit and filter all related Tasks, ideally in multiple views.

What I tried so far

1. Canvas Collums
   I already tried to implement this with task views in an Canvas Collum of the Projects DB. However, I can’t find a way to stop Editors from being able to mess up the canvas Layout. (Access management in canvas collums doesn’t seem to be possible)

2. Subtables
   The use of subtables for the related tasks would be ideal, however I can’t find a way to filter the subtables. It should, for example, be possible, to hide the completed tasks.
   

   

My Questions

1. Is there a way to filter the tasks that are shown in subtable views (without actually unlinking them from the related Project)?
2. Is there a way to have more control over what editors can change in canvas collums?

Apparently, the canvas collum problem has already been discussed in since 2022: Locking settings not (yet) implemented on canvas columns

I love coda so far but if this isnt’t possible, it is one major drawback to notion.

[Jannis]

Hi @Marvin_Schuch and welcome to the Coda Community!

I am pleased to welcome you as another German user to the community.

I totally understand your issue – this is a common challenge when moving from Notion to Coda, especially when working with linked data like Projects and Tasks.

@Marvin_Schuch

Is there a way to have more control over what editors can change in canvas collums?

You’re right – at the moment, there’s no way to lock canvas content from being edited by editors. This limitation has been discussed in the community for a while, but it’s not implemented yet.

Possible workarounds:

• Instead of using canvas columns, consider using a detail view layout for your Projects. You can embed filtered task views there as well, and it provides more layout stability.
• You can also give your team view-only or interact-only access to the section and use buttons or forms for them to interact with tasks without modifying the layout directly.

@Marvin_Schuch

Is there a way to filter the tasks that are shown in subtable views (without actually unlinking them from the related Project)?

You can simply add a linked relation column, so the projects and tasks are always in sync. You can also work with control values and filter the rows that way, it depends on how you want your system to work like.

Best regards from Hessen
Jannis