How to create only 1 new record via automation when 2 with same name enter a view

[Alix]

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!

[TheTimeSavingCo · Accepted solution]

Hi Alix, if I were you I’d:

1. In the synced table in Base B, create a linked field to Base B Table 2
2. In Base B, create an automation that triggers whenever a new record appears in the view in the synced table in Base B. Its action will be to paste the name of the new record into the linked field to Base B Table 2

That should do exactly what you need I believe. When X and X are created in Base A, only one record called X will be created in Base B Table 2.

To get “2”, “3”, etc, I’d create a Count field in Base B Table 2, as the automation would have linked both records called X from the synced table to that one record called X in Base B Table 2