Hi Alix, if I were you I’d:
- In the synced table in Base B, create a linked field to Base B Table 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