Is there a way to count the number of rows in a table?

[Olivia_Ehrenrei]

I want to know (and then trigger an automation) when there are 10,000 records added to my table. How can I do this?

[kuovonne · Accepted solution]

The only way for a formula field to know when there are 10,000 records is to have all of the records linked to a single control record. I do not recommend doing this.

You could have an automation script run that periodically checks the number of records and then only takes additional action when there are 10,000+ records.