Select all the rows in the table that have not been archived
Get the first 400 of them, we can’t do more than that because Coda automations can only handle 400 rows
Cache the row content so that we can detect changes to the data
Archive each row. Either that will mean adding a new row if the Row Id isn’t already in the table, or it will mean updating the row if it’s not archived. The Archived? column checks that the saved row is identical to its match in the Archive table. If it’s not identical, the Row Contents will be updated.
Press the Archive button with an automation. You can choose whatever frequency for the updates you like.
If I’m updating a big doc, I’ll normally start by pressing the button every hour (so that I can catch up with all the data in the source doc) but then I’ll switch it to a weekly frequency once I’ve caught up (it’s rare I add more than 400 new rows to any doc per week).
Make sure that the sync frequency on your tables (both the
) is faster (more frequent) than the rate at which your automation presses the archive button. Nothing will break, but your archive button will just be archiving data you’ve already archived, so won’t be doing much.