I organize a Run group that uses Airtable to login runners each week, via a form entry from a "Check-Ins" table. This form pulls data (names) from a larger "Runner List" that keeps track of all registered runners that have ever logged in. The "Check-Ins" table tracks the weekly login for each run and then syncs back to the "Runner List" master sheet that tallies their cumulative runs they've attended. I'm looking to create a new table that tells us how many new runners show up each week.
Logic would be that the new table looks to the "Runner List" Table and searches any values that have the "Total Runs" column (which is a formula that sums all of their weekly run logins) equal to "1" and also where the check-in is the current date.
I think if I were you I'd create a "Created time" field in the "Runner List" table and use that instead, where any record created this week would be a new runner
I'd then create an automation that would run once a week, and its action would be to find all records created this week, and create a record in that new table you mentioned with the date the automation ran and the number of found records