I am trying to create an automation where when every 10 new records is created in the airtable base it automatically create one new record with the data from all those records (thus, create one record with 10 record data inside), and then it will move that record to a new view.
I will then create a zapier automation where when a new record is added in view, to add to an rss feed.
My goal essentially is to have the following:
every time someone fills out an airtable record, it only creates a new record if 10 were created total. I do this so that I can create a digest email via an rss feed welcoming new members.