I am trying to sync bases with similar columns but different primary fields. How would you solve this?
I’m thinking of either
Change all the bases and agreeing on a universal primary field with everyone involved
Trying to map each base into an intermediate base, so that every intermediate base has the same primary field and then syncing them with the centralized base. (If this is the correct answer, how would you do this mapping?)
How would you solve this problem?
Thank you very much in advance