Hi Tina, if you’re okay with creating the new consolidated record in another table, this can be done pretty easily with automations
You can find it set up here
The idea is to have an automation that triggers when a new record gets created. It’ll then find records that are not linked to a consolidation record.
If it finds less than 10 records, it won’t do anything. If it finds 10 records, it’ll create a new record in Table 2 and link the 10 records it found to the consolidation record
Let me know if you have any questions!