Importing New Activities to Contacts
I have a batch of new activities that I need to import to existing contacts in my database. The issue I'm running into is that when I import these new activities they are created without a connection...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWhat is the key field for your parent contacts table?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Hi Mark - it's the Record ID Number.
------------------------------
Cecilia Mullan
------------------------------
------------------------------
Cecilia Mullan
------------------------------
- MarkShnier__YouThe usual way for these "one time" imports is to export the contacts table name and Record ID# to Excel and then use a VLOOKUP (using the , false option) to match up the name in the Activities table to the Record ID#, and then import and map the Record ID# into Related Parent Contact.
If this was to be an ongoing process, then there could be other solutions.
Another approach if the Contacts Table is only used a a Parent to Activities, is to temporarily change the key field of Contacts to be the name field (you may need to make a text field equal to [First & Last Name] by formula and then change that field to a text field, and then import your activities which which I presume has the name field too. When you import, you would map the name into the Related Parent Name field. and then once the children are attached to the parents, then change the Key field of the Parent Contacts back to Record ID#.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Just to clarify - I do have the related Contact Record ID already matched with activities. The problem is that when I try to import, the system does not give me the option to import the Contact Record ID alongside the activities. I think this is because the Contact field in my Activities form is a lookup field (picture attached). Since these are "new" activities, they haven't been assigned Activities Record ID numbers (key field) by the system yet so this lookup field doesn't work. Do I need change the Record Key to something else for my Activities table (like, Contact)?
The Contacts table is also a parent to another table (engagements).
------------------------------
Cecilia Mullan
------------------------------- It seems like the only solution is to do your second suggestion - change the Key Record to be Contact Name and then once I've linked all the activities to the parent, switch the Key Field back to Record ID#. Do I have to undergo the same process for the Engagements table (the other child table of the parent) or will they re-link once I turn the Key Field back the Record ID#? Thanks!
------------------------------
Cecilia Mullan
------------------------------
