Situation:
I have 2 databases. DB 1, where I have client info. DB 2, where all submitted actions from DB 1 go.
Example:
When I click “On Time” for a client in DB 1, it puts it into DB 2 as a record so that after so many records, I can click on their profile in DB 1 using the Tab feature in the layout and view all past records.
Issue:
I am re-linking and moving all records from DB 2 to DB 3. All relations break because they are different.
Goal: Quickly link 2000+ rows in DB 3 with an automation to DB 1.
Example: DB 1 may have Kobe Bryant listed, and in DB 3, there may be 40 rows containing the Name of Kobe Bryant. I want all 40 rows that are Kobe Bryant to be connected via relation to the 1 Kobe Bryant row in DB 1.
I have no idea where to start with this. Any and all help is extremely appreciated.
If DB2 still exists, I would copy records from there to DB3 using automation- you already have linking to DB1 so you can recreate it and, if needed, you know which record in DB1 to update with relations to DB3. That’s the most credit-consuming efficient and probably safest method possible.
If DB2 does not exist anymore- without knowing the database schema, I can only suggest a general approach: fetch all records, find key which will allow you to link them to DB1, deduplicate them (so instead of 40 Kobe Bryant records you will have one), search for it in DB1, and bulk update those 40 records with linking to DB1.
That’s actually why I made this post. To see how I can ran that automation to copy everything over and also create the links. There are no relation links anymore because everything was disconnected.
DB 1 became DB 3, and DB 2 became DB 4.
Reason why is because I rebuilt everything for clients. Rather than rebuilding the entire new system 10x for all clients, I would love to be able to transfer their previous data into the new system so they don’t lose anything.
Hopefully this makes sense. My brain is scrambled eggs trying to figure out how to do this lol.
With all my love for Notion, it is not a perfect tool stack for systems scalable across clients.
But that’s my subjective opinion.
If you do not have any links anymore- without the ability to analyze the database, it is hard to suggest any way to handle this efficiently. I’m afraid I won’t be able to help you here.
Agreed. It’s been amazing for the business model I have, but there are certain things (like this) that are horrible. Nightmare-ish even. Thanks for your help!