I’d like to have a workflow in Coda that allows for a periodic (i.e. weekly) archiving of information from one table to another. My team has weekly “status updates” and are required to update these every week.
The ideal workflow in Coda would be as follows. I’m sure this is a combination of buttons and automations.
Every Sunday at 7pm EST an “Archiving” automation starts
Table X with the column “Last Week’s Update” has information from last week’s update. The value in this column is then moved to a separate table called “Table Archive” with a timestamp
The values in “Last Week’s Update” in Table X are then removed
Value in “This Week’s Update” is moved to “Last Week’s Update”
Here is a skeleton of the tables. Thoughts?
Thank you in advance