Need Help with an Automation (Please)

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

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.