So I have 2 bases, let’s say A and B.
Table 1 in Base A is synced to Base B.
When 2 records with the same name lets say X are created in base A table 1, they enter a view on the synced table on B.
When they enter this view an automation runs to create two new records in base B table 2 with the same name (dynamic field value).
However when X and X are created in base A, I only want one new record to be created in base B’s table (when the name is exactly the same).
What would be the easiest way to have the automation only create 1 new record named X?
And it would be a bonus if I could have the new record in base b’s version field number to fill out as 2 when there are 2, 3 when there are 3 records with same name in base A and so on.
Thanks!