If your trigger runs at a scheduled time (end of each day) then you can use a Find Records step to get a count of records in a view, assuming that number is less than or equal to 100. Otherwise you can use a simple Run a Script action to get a full count of records in a view.

That Automation could then use a Create Record step to fill in a “Reports” table with the day and record count so you can have a running log.

Out of curiosity, could you think of a way I could take advantage of the new Interfaces to display this as a graph with weekly values over time? Exporting this count externally is simple enough as it doesn’t need to worry about remembering previous weeks but I would love to keep the report in Airtable if possible.

A sum of how many records are in a view, bucketed by week could give a trend but you’d need to keep that data constantly recorded for the interface to see previous weeks data?

I am trying to trigger at a time to find all records in a view, then create a new record in my reports table that adds the date and the list of records from the previous search, but I am getting issues not being able to create a record due to permissions