I’ve got a database which is presenting the same data but in different localisations. Everything is going well except for one aspect. The single select columns won’t transfer data in the same was a the multi-select (or any other data type I use).
You can see in this picture, where I have got multi-select data transfer to work fine despite the selection IDs being different
However, when trying to do something similar with single select, it will always add a new item. I have no idea how to sort this, and it’s really annoying (I have 24,000 cells to maintain, so I need this process to be automated)
The picture below is an example (I only told it to use one cell so I didn’t have to clean up 16 columns)
Does anyone have any ideas how I can sort this? Thank you!