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.