I have a table called Today’s Schedule. It uses a nightly automation to lookup the current day’s schedule from my Time Blocker, so that when I wake up in the morning my daily plan is waiting for me. It also includes columns for completing each task (checkbox), indicating progress made (progress bar), and providing notes on my progress (text). It works great; I love it.
Thing is: it refreshes nightly, which means that it’s sort of like GroundHog Day: every day I wake up to a fresh Schedule, and everything that happened the day before is poof gone. Not optimal, obviously.
So what I’d like to do is add a step to the automation, so that just before it refreshes, it copies the contents of Today’s Schedule into another table (let’s call it Schedule Archive). Specifically, I want to take the entire contents of Today’s Schedule and add it as a subtable to Schedule Archive, so that each day is held within a single row in the Archive.
I didn’t think this would be difficult, but I’m having a much harder time than I expected getting this to work.
- I can, of course, use a Relation to copy the whole table over - but then the tables would be linked, and when Today’s Schedule refreshes, I’ll lose my Archive entry too.
- So what I really need to do is Duplicate the table, so that only the values copy over, unlinked. But I’m not sure that there’s an automation or formula that can do this.
I can make this happen via an Automation if I AddRow from Today’s Schedule to Archive row by row by row by row by row. But this seems pretty inconvenient. So I’m hoping someone has a better solution?