web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Populate new field in ...
Microsoft Dynamics CRM (Archived)

Populate new field in CONTACT from existing field in ACCOUNT

(0) ShareShare
ReportReport
Posted on by chronos 10

Hello,

We need to populate already existing information from an existing field in the ACCOUNT view to a new field that we created in the CONTACT view. 

I tried adding the same field in the Contacts / Views (using the form builder) but the new CONTACT field is empty and does not port information that sits in the same field in the ACCOUNT view.

Have over 17,000+ accounts and 40,000+ contacts associated with those accounts, and so cannot map all of them manually.

Is there any way to automate this task please?

thank you!

*This post is locked for comments

I have the same question (0)
  • Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at
    RE: Populate new field in CONTACT from existing field in ACCOUNT

    Do you actually need to modify the value in the Contact form, or only display it? If only display, then you can create a Quick View for Account and display it in the Contact form. If you need to edit it in the contact form, then one of the solutions above should work.

  • chronos Profile Picture
    chronos 10 on at
    RE: Populate new field in CONTACT from existing field in ACCOUNT

    Hello Adrian,

    Thank you for your reply.

    Yes, we need to populate the value of the Contact field using an existing value in its parent Account record. Need these fields to be constantly in sync.

  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at
    RE: Populate new field in CONTACT from existing field in ACCOUNT

    Hi Chronos,

    There are a couple of scenarios here.

    Do you need to populate all the existing contacts that are associated with the existing accounts? If that is the case, I would probably use an SSIS package with Kingswaysoft for that to update all the contact records.

    The second step is that you would want to keep this in sync. You can use a workflow or plugin to achieve this. When this particular field on the account record is updated, update all the related contacts. If you are not comfortable with plugins you can use Ultimate Workflow Toolkit: butenko.pro/.../ultimate-workflow-toolkit-v1-5-0-0 or Dynamics 365 Workflow Tools: github.com/.../Dynamics-365-Workflow-Tools (previous versions available for both to support CRM 2013).

    Hope this helps.

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,027 Moderator on at
    RE: Populate new field in CONTACT from existing field in ACCOUNT

    Hi chronos,

    Do you want to populate the value of the contact field based on the value of the field on the contact's parent account record? Also, is this a one off task or do you need the fields to constantly remain in sync?

    This forum topic explains some approaches to solving this problem.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans