Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Copy custom field from Lead to Opportunity when Qualifiying?

Posted on by 225

 I have a custom field on my Lead form, and a custom field with the same name on my Opportunity form. Both fields are drop down boxes with the same options defined as possible answers.

 I would like the value in the custom field in the lead to be automatically copied to the field of the same name in the opportunity, when the Lead is converted into an Opportunity.
 But I’d also like Opportunities that don’t arise from leads to be able to have this value set independently.
 Can anybody tell me how I can go about this?
 Thanks,
 JMT
CRM Online 2011

*This post is locked for comments

  • sitchey Profile Picture
    sitchey 1,695 on at
    RE: Copy custom field from Lead to Opportunity when Qualifiying?

    Agree with Gretchen Opferkew that its best to have global set options rather than seperate pick lists.

    I learned that through experience!

  • sitchey Profile Picture
    sitchey 1,695 on at
    RE: Copy custom field from Lead to Opportunity when Qualifiying?

    thanks Jerry Weinstock!

    Worked perfectly for me :)

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Copy custom field from Lead to Opportunity when Qualifiying?

    Hi vandana a,

    You can only achieve your requirement by implementing the mapping in onload method of the form of the new entity data. You can load the lookup name by the reference which is set on the form and then insert this value in your textfield.

    Best regards,

    Andreas

  • vandana a Profile Picture
    vandana a 875 on at
    Re: Copy custom field from Lead to Opportunity when Qualifiying?

    hi ,

    I too had same problem but if i wana copy lookup value(datetype) to single line of text(datatpe)  what is the procedure

  • Suggested answer
    Re: Copy custom field from Lead to Opportunity when Qualifiying?

    Hi there!

    If you haven't gone down the road too far, I would highly recommend using a global option set rather than two separate picklists.

  • Suggested answer
    CRMInnovation.com Profile Picture
    CRMInnovation.com 12,282 on at
    Re: Copy custom field from Lead to Opportunity when Qualifiying?

    In the Navigation Pane, click Settings.

    Under Customization, click Customizations.

    In the Customization area, click Customize the System.

    Under Components, expand Entities, and then expand the entity you want.

    Click either 1:N Relationships or N:1 Relationships.

    In the main pane, in the Type list, select Mappable.

    Select a mappable relationship. Then on the Actions toolbar, click Actions, and then click Edit.

    Under Related, click Mappings.

    For each new mapping, on the Actions toolbar, click New.

    In the Create Field Mapping dialog box, select the source field from Source Entity Fields. Select the target field from Target Entity Fields.

    When you select fields, consider the mapping requirements.

    Both fields must be of the same type and the same format.

    The length of the target field must be equal to or greater than the length of the source field.

    The target field cannot be mapped to another field already.

    The source field must be visible on the form.

    The target field must be a field into which a user can enter data.

    If the fields are option set (picklists), the integer values for each option should be identical.

    Address ID values cannot be mapped.

    Click OK.

    Click Save and Close to close the Relationship form.

    When your customizations are complete, publish them:

    To publish customizations for only the component that you are currently editing, on the Home tab, in the Save group, click Publish.

    To publish customizations for all unpublished components at one time, click Publish All Customizations

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans