How do I add new field in Microsoft CRM

Posted on 2009-02-23
Last Modified: 2012-05-06
Hello all,
I am trying to add a new field in the Lead form. My boss would like to see information in a Query from the leads table called Publication, I work in the printing bussiness. Anyway I tried to add a field and it only lets me add predefined fields, so I believe I need to change one of those presets to the Publication fiels. But I dont know where to do that.

There is a field called Exchange Rate that I would like to change to Publication.

I am very new with this program.

Question by:troy93955
    LVL 10

    Accepted Solution

    You can add new fields fairly easily - it's just not totally obvious how to do it (and you certainly do not want to change the Exchange Rate field).  Here's the process for adding a new field (assuming you are using CRM 4):
    (1) Open CRM (the web version)
    (2) Go to Settings (the second-to-last group on the left-nav menu)
    (3) Go to Customizations (on the left-nav menu)
    (4) Then click on Customize Entities (in CRM, an Entity is the same as a Table - mostly)
    (5) Now scroll down to Lead and double-click on it
    (6) Click on Attributes on the left-nav menu (in CRM, an Attribute is the same as a Field)
    (7) Click the New button
    (8) Fill in the form to create your new attribute
      - Display Name: The name that will be displayed on the form (you'll probably name yours Publication)
      - Name: This is the "computerese" name - you can usually leave this alone
      - Requirement Level: decide if the user should be requried to enter the field or not
      - Searchable: leave this as Yes
      - Type: Enter the type of field.  You'll probably want a nvarchar field (this is a plain data entry field) or a picklist (lets the user pick one value from a list).  If you want more help on the field types, click the help button in CRM
    (9) Save and Close to save the attribute that you created
    (10) Now you'll add your attribute (field) to the form, click Forms and Views in the left-nav bar
    (11) Find the form and double-click on it (in the name column, you'll see Form).
    (12) Click the tab you want the field to be on, and then the section
    (13) Click Add Fields (on the right-hand side of the form)
    (14) Select the new field you want to add and check the box next to it
    (15) Use the 4-way arrows to move the field around on the form.  If you put it on the wrong tab or section, then double- click on the field and you can choose a new tab and section to move it to.
    (16) Once you're satisfied, Save and Close
    (17) Save and Close again to return to the list of entities
    (18) With Lead still highlighted on the list, click the Publish button
    Your new field should be available.
    LVL 2

    Expert Comment

    If I understand you correctly, you want to create a relationship between the Lead entity and the custom entity Publication. You must first create the relationship between the two, then add it as a field to the Lead form. MSCRM will then automatically create a lookup field towards publications where you can select which publication to want to connect the Lead to.

    To create the relationship you have to consider what type of relationship it is. MSCRM supports one-to-many and many-to-many relationships. This is like standard database modelling. If your company is gathering leads for selling publications, I guess a one-to-many relationship between Lead and Publication will suffice. In that case, go to Settings -> Customizations -> Customize entities -> Lead -> N:1 relations and click New. Choose your Publication entity as Primary Entity.

    If the relation you want is the other way around, you create a new 1:N instead. And if you want a N:M relationship you can create one of that type.

    When you have saved the relation shiip, add the resulting field to the form and save it, then publish the Lead and Publications entities from the customize entities screen.

    Good luck! let me know if you have other questions.

    Author Closing Comment

    Thank you very much, that worked great.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This is a walkthrough guide I wrote whilst upgrading my on-premise MS Dynamics CRM 3.0 deployment to 4.0. This covers the actual installation of the product to a working level for my system, I ran into a lot of issues that the steps below fixed so h…
    On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now