La fonction de suggestion automatique permet d'affiner rapidement votre recherche en suggérant des correspondances possibles au fur et à mesure de la frappe.
I just did an import of contacts (John Doe John.Doe@xyzcompany.com). When doing this it successfully created the contact as well as looked at the domain and created the XYZCompany and relevant company data (Las Vegas, NV).
When I go back to Contacts for John Doe, I see that he is tied to the XYZCompany. However, I go to filter my contacts by City or State and none of that company data is tied to John Doe.
How do I set this up such that the contact info is tied to the company info created? Assume my contacts are all 1 to 1 / they don't have different locations.
Hi @RPAutomate, looks like this is something that can be solved using Workflows (see this forum post). It looks like, like me, you're a Free user. It might be possible to use a very cheap 3rd party tool like InSycle to handle this (see this article). You can set up a free account and run a test batch or contact their support team to see if it's feasible. If so, for a small subscription, the task could run on a schedule to update your data.
Failing that (and it's a more time-consuming solution), you could achieve the same by exporting all Contact details from HubSpot, including the Company ID field. Then, export Company details, including the ID field and location details. In Excel, import the Company stuff into the Contact workbook. In the Contact workbook, populate State and City using VLookup, then delete the Company sheet from the workbook and re-import back into HubSpot, ensuring you map the State and City fields to the relevant Contact fields.
A range of options, going from the most efficient (and most expensive) to the least efficient (and, coincidentally, least expensive!!).
Hope this helps!
Did my post help answer your query? Help the Community by marking it as a solution "The rest of my advice has no basis more reliable than my own meandering experience. I will dispense this experience... now!"
Hi @RPAutomate, looks like this is something that can be solved using Workflows (see this forum post). It looks like, like me, you're a Free user. It might be possible to use a very cheap 3rd party tool like InSycle to handle this (see this article). You can set up a free account and run a test batch or contact their support team to see if it's feasible. If so, for a small subscription, the task could run on a schedule to update your data.
Failing that (and it's a more time-consuming solution), you could achieve the same by exporting all Contact details from HubSpot, including the Company ID field. Then, export Company details, including the ID field and location details. In Excel, import the Company stuff into the Contact workbook. In the Contact workbook, populate State and City using VLookup, then delete the Company sheet from the workbook and re-import back into HubSpot, ensuring you map the State and City fields to the relevant Contact fields.
A range of options, going from the most efficient (and most expensive) to the least efficient (and, coincidentally, least expensive!!).
Hope this helps!
Did my post help answer your query? Help the Community by marking it as a solution "The rest of my advice has no basis more reliable than my own meandering experience. I will dispense this experience... now!"