Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

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

Topic Labels: Formulas
Solved
Jump to Solution
1220 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Olivia_Ehrenrei
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎Jan 28, 2022 10:50 AM

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

0 Kudos
Reply
1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto
Solved See Solution in Thread

‎Jan 28, 2022 11:33 AM

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.

See Solution in Thread

Reply
1 Reply 1
kuovonne
18 - Pluto
18 - Pluto
Solved See Solution in Thread

‎Jan 28, 2022 11:33 AM

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.

Reply
Copyright © 2024 Khoros, LLC