Hi
We have an Email Tracker table in our base with a lot of data rows, so I want to move that table to it's own base to avoid maxing out our limits too quickly.
The Email Tracker table is fairly independent, with the exception of 2 data columns:
- 1 linked records field (linking to the Campaigns table)
- 1 look up field that is pulling in the "campaign owner" from that same Campaigns table
I'm not sure how to best maintain the 22,000 rows of data already linking to the Campaigns table in our primary base.
The Email Tracker base will have a Campaigns table that is synced to the original one in our primary base. However, I'm not sure how to get the linked records fields that are currently looking to the primary Campaigns table to now look at the synced version of that campaigns table that I created in the new base, short of manually updating all 22,000 rows!
I did a test, pulling in all the information of the Email Tracker. The linked Campaigns field and Campaign Owner field retained their data, but put it all in regular text fields. The link to the linked record is broken. Hoping there's an automated way to maintain the linked connection!
Thanks