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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Copy custom field from Lead to Opportunity when Qualifiying?

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    CRMInnovation.com Profile Picture
    on at

    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

  • Suggested answer
    GL-23071537-0 Profile Picture
    on at

    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.

  • vandana a Profile Picture
    875 on at

    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
    Community Member Profile Picture
    on at

    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

  • sitchey Profile Picture
    1,695 on at

    thanks Jerry Weinstock!

    Worked perfectly for me :)

  • sitchey Profile Picture
    1,695 on at

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

    I learned that through experience!

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans