This is awesome and perfect for tracking stuff in my D&D campaign! Similar to @yngrco (I think) I would like to know how to keep base data on the TOC page. I imagine that instead of removing the grid we do something else but I don't know what. I would like to keep an image on the TOC and a title so I only want to replace and add to everything below that point. Is this possible with REMOVE_ROW or is there an easier way?
Ah yes... so when we call the .clearContent() method -- you just need to make sure you're doing it against the cell range you want. IIRC, the code in the demo did a getDataRange(). You can do .getRange("A5:A100") instead (or whatever your range is)
How about automating titles of the Sheets on the TOC? For example, each Sheet has a subject name in each Cell C5, how do I automate have the subject names in the TOC.
This is awesome and perfect for tracking stuff in my D&D campaign!
Similar to @yngrco (I think) I would like to know how to keep base data on the TOC page. I imagine that instead of removing the grid we do something else but I don't know what. I would like to keep an image on the TOC and a title so I only want to replace and add to everything below that point. Is this possible with REMOVE_ROW or is there an easier way?
Ah yes... so when we call the .clearContent() method -- you just need to make sure you're doing it against the cell range you want. IIRC, the code in the demo did a getDataRange(). You can do .getRange("A5:A100") instead (or whatever your range is)
@@BootstrappingTools Awesome I will give that a try. Thanks!
How about automating titles of the Sheets on the TOC? For example, each Sheet has a subject name in each Cell C5, how do I automate have the subject names in the TOC.
Good work
Thank you so much 😀