- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 08:15 PM
Hi Everyone!
I would just like some help or insight on the problem I'm having with an automation I'm currently trying to make.
The automation is supposed to send an email to the user after creating 10 new individuals (like networks) on a table. I'm stuck on how to do it and I cannot fully grasp the resources on airtable help-center so i'm here to ask for additional help or advice 🙂
any thing that can help me understand better would be much appreciated!
Thankyou!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 09:31 PM
Hey @k0k0netiji,
Welcome to Airtable community!
I suppose you have 1 table "users" where all individuals will be there, right? So my suggestion is this:
1. Create a self-link {Created by} field in this table, this will show who created this new user.
2. Create a another self-link field {Created} this will display the users created by he user on the records
3. Create an Automation that will be triggered every time a new record id created and will have the following actions:
3a. Find action to find the record with ID equal to {created by} record id -> find the in automation the creator
3b. Update the creator record from the previous step by adding the existed value in field {Created} and the triggered record with comma separated.
4. Create Count field based the {Created} field that will count how many users this user created. When this is 10 you can run your automation.
Please let me know if this works for you 🙂
Thanks,
Dimitris Goudis | 3Nuggets.io
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 11, 2025 09:38 PM
Hey @k0k0netiji
For your Airtable automation, the best way to set this up is to use a trigger-based approach. You’ll need to create an "Automation" in Airtable that watches for new records and counts them dynamically. Here’s the step-by-step plan Set the automation to trigger when a new record is added to your table.Use a conditional check to count how many records exist. You may need a summary field in another table to track the count.Once the count reaches 10, use the "Send Email" action in Airtable (or integrate with Gmail/Outlook) to notify the user automatically.
