I’m trying to manage a project where I’m making videos. The main table lists the videos our team has to make, along with the statuses. I want to use Coda to also maintain the scripts for the videos, but I don’t see any way to add rich text to the row. As a result, I think I have to make a separate page for each entry.
I’ve set up automation to create a new page with the same name as the task when a “create script” checkbox in the row is modified (although it seems sometimes the automation makes two copies for some reason), but then I want to link to the new page in the original row to maintain the relationship between the two separate pieces. I’ve tried with no luck to make this work in a number of ways, and need some advice.
I tried adding a button to the table and then also to each row to just find the task name, and reverse engineer the URL with Hyperlink() and Concatenate() using “https://coda.io/d/link_to_document/” and the name of the task, but the resulting link is showing as “broken” even though it redirects correctly in the browser. There’s got to be a better way to create this kind of relationship, right? I feel like I’m overthinking this.
Ideally, I could just expand the row in the main table and have a rich text document that my team can collaborate on, but if I have to use a separate page that’s fine. I just want it to work so my team doesn’t have to manually add new entries, then manually create a separate page, then manually link them together.
Thanks for any suggestions!