Skip to main content
Solved

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

  • January 28, 2022
  • 1 reply
  • 23 views

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

Best answer by kuovonne

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.

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • January 28, 2022

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.