Is there an easy way to just count all the records in an Airtable table, and send an email with this number? Trigger could be when a new record is created.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Userlevel 7
+14
- Certified Zapier Expert
- 26585 replies
-
23 February 2024
Hi
Yes.
Also, you can probably use Airtable Automations for this.
Airtable Automations has a Find Records step and an Email step (or can use Gmail/Outlook steps).
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
Hi
Yes.
Also, you can probably use Airtable Automations for this.
Airtable Automations has a Find Records step and an Email step (or can use Gmail/Outlook steps).
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
I have already an automation in Airtable that finds all the records, and return the total “Length of Records”. However, there is a limit of 100 records in Airtable.
Userlevel 7
+14
- Certified Zapier Expert
- 26585 replies
-
24 February 2024
Try this approach...
Another way is to use linked records in Airtable.
2 Tables
- Table: Dashboard
- Search for the 1 ”MAIN” record which will have the Count of all linked records from the Table XXX
- Table: XXX
- Link all the records in Table XXX to 1 record in the Dashboard Table
- Then you can add a Count field type in the Dashboard Table
- Help: https://support.airtable.com/docs/counting-the-number-of-records-in-linked-record-fields
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.