I have 2 tables that have records I want to update. One table is called Inventory, and the other is Content Info. ‘Inventory’ is our bible but the ‘Content Info’ have some records that we want to update in the Inventory, I have a field called “Housenumber” for both tables, but because in the ‘Inventory’ we tend to have multiple records entered by multiple people for “Titles” (with different spelling) but with same housenumbers, this makes the confusion (i know).
Now we need to find the “Housenumbers” in the Inventory with the same from Content Info, so we can update the fields we require by automation not manually. We’re doing this automation so we can update the field ‘Season ID’ and ‘Show ID’
I have references below:
Content Info Table
As you can see, “Jad Al Shoja” has records in both sides when I searched the “Housenumber”, but in the Inventory it’s 2 entries.
So I made an automation:
When a record is updated:
It did work totally fine for the other entries that doesnt have multiple ‘housenumbers’, but for the duplicated ones it ‘Failed’.
example of ‘Successful’ automation: (3 out of 14)
Is there an additional step that i should’ve included in the automation to cover this case?
Would be a great help to hear suggestions.