Building a CRM in Coda (limit contacts)

Hey guys,
I am building a CRM but a lot of my clients have over 10.000 contacts. I know there is a certain limit within Coda. Is this something we can use Coda for? Or is it advised against?

Hi Steven,

The “10,000” limit on Coda rows is not a hard limit like the number of rows in Excel. It is more a rule of thumb that says around ten thousand lines in a single table will start causing some performance issues. (Also depending on the kind of columns used in the table.)

But there are many mitigating strategies that one can follow: Separate tables, separate docs, etc. The design woud be extremely important.

Regards
Piet

1 Like

Hey Piet,
Thanks for the info. What types of columns are best avoided?

Hi Steven,

My comment would have been more accurate if I had said “Also depending on the formulas used in the columns in the table.”

There is basically no limit to the calculations that you can do in a formula in a column, so that can dramatically influence performance.

I also do hope that some of the other members of the forum with experience in this area will comment after the weekend.

For example - I do not know what the impact of canvas columns would be on the doc. But they are a complex column type. It might have a major impact, or Coda might have found a way of isolating the performance of a table from what is happening in the canvas column. I just don’t have enough technical knowledge to comment.

Regards
Piet

1 Like

Hi Steven,

Nice to e-meet you! I am part of Coda’s Success team - we are here to make sure that Coda Makers have all the tools they need to succeed.

I am happy to talk live through some tips and tricks for doc schema and set up if it would be helpful. You can access my calendar here!

2 Likes