Cannot Archive into a cell because text is too long? Any other solution

1

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.

Thanks

2

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.

3

Can you show me how to do it? I need to get some idea so i could modify my formula

4

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.

1 Like
5

thanks very much. I’m looking forward to this

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.