I recently came back to Coda and I’m trying to reconstruct an old project management doc of mine (from before the introduction of canvas controls) where I could generate a new project page and have it display a Gantt chart that was auto-filtered to only show tasks assigned to a project that matched the name of the project.
It seems like @piet_strydom’s “Advanced todo list without formulas” has much of the functionality I’m looking for (and I’ve been enjoying using it as a base to reconstruct my old doc) but I’m still stumped on how to add auto-filtering.
Any chance someone can point me in the right direction? Here’s a doc I’ve been using as a sandbox:
1 Like
Hello @lherring ,
You have to use a filter in the filter formula (to filter on whatever project is selected in the select control.
Your naming convention does not really help thoug, the formula looks like this, but that is not easy to see in the code editor.
This is the formula:
thisRow.Project=[Select View 6 of Todo List Projects 7]
But this is what you see:
I changed it in your doc - I hope that’s what you were looking for.
Greetings,
Joost
1 Like
Thank you for taking a look! Adding the formula thisRow.Project=[Select View 6 of Todo List Projects 7] would be what I do if I want to manually adjust the filter once I’ve created the page, right?
thisRow.Project=[thisPage].Hyperlink() is the formula I used in my original document, and if memory serves it wouldn’t require any manual inputs once I’d clicked the button to generate the page from the template.
1 Like
Select View 6 of Todo List Projects 7 is the name of the control - it will include the names of any new projects. I am not sure what you mean with manually adjusting the filter. The formula does not have to be altered, you just choose another project in the select control.
I don’t really understand the hyperlink() formula in your explanation.
1 Like