Hello. I use @Scott_Collier-Weir method to keep archive of my table rows into csv text.
I have tried the formula and ran it and it work perfectly. However, when I do archive for 1 month (thousand row, with around 20 column). The system show error because of text length is too long.
I tried switching column from text column to canva column but still not working.
I want to know if there is other work around that I could archive this csv.
Cap of characters per text column is just over 40k characters.
You can try segmenting your data over the span of multiple rows if you’d like to keep it within Coda. And you can query the data in a way for you to recognize what data is in what archive row.
You can go pretty far with it. I created a somewhat similar method that so far is storing 4.7 million + rows, with around 17k archive rows and the doc still works like normal.
To make the experience seemless, it’s honestly quite the process. I will probably make a YouTube tutorial of it, but I’ll see if I can share a doc tomorrow.