I created an automation that triggers when any record is added to table A it automatically creates the same record in table B (within the same base). I’d like it to copy all the records already in that table so that the number of records in table A is always equal to the number of records in table B. It only copies NEW records though.
Yea, I’ve done that but as I update table A it doesn’t update table B and that’s kind of a hassle when I have multiple tabs that should be updated to mirror records from the main table.
A partial solution I’ve found is to use linked records so when I want to add something to the main base I do so through a secondary base through a linked record. The problem is that doesn’t create the same records on other linked bases.