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 :
Microsoft Dynamics CRM (Archived)

How can I modify the industry drop down list in CRM?

(0) ShareShare
ReportReport
Posted on by 305

*This post is locked for comments

I have the same question (0)
  • CRMInnovation.com Profile Picture
    on at
    Re: How can I modify the industry drop down list in CRM?

    Keith

    If I understand your question what you need to do is to go to Customizations, open up the the Account Entity and go to Fields and then find the field that you want to change the option set values for, edit it and then save and publish the customizations.

    Jerry
    CRM Innovation
    Need a solution for CRM to help you manage Events or Email Marketing?
    Follow me on Twitter

    See below from the help file

    Create or edit entity fields
    Any time you change user interface elements or implement form scripts for an entity, you must publish changes to apply them. Any customizations that change the data schema of Microsoft Dynamics CRM such as custom entities, relationships, or fields are applied immediately.

    After you create new fields (A property of an entity with a specific data type. Fields are analogous to columns in a database table. When they are added to an entity form, they are displayed as fields that correspond to their data type.), be sure to include them on the forms (Pages that display detailed information that users have entered into Microsoft Dynamics CRM about specific records, such as all information about a contact. Information that users enter in a form is stored in Microsoft Dynamics CRM as a record.) and views (Filters applied to a list of records. Users can choose different views that contain all the records or activities of a particular type or that are a subset of that type.) for the entity (A structure used to manage data. A synonym is "record type". Microsoft Dynamics CRM entities include Account, Case, and Activity.) so that they are available from the Microsoft Dynamics CRM user interface. You can also add the new fields to relevant reports.

    1.In the Navigation Pane, click Settings.
    2.Under Customization, click Customizations.
    3.In the Customization area, click Customize the System.
    4.Under Components, expand Entities, and then expand the entity you want.
    5.Click Fields.
    6.To add a new field, on the Actions toolbar, click the New button.
    Enter a Display Name. A Name will be generated based on the Display Name.

    - OR -

    To edit an field, select it in the list, and then on the Actions toolbar, click the Edit button.

    7.In Requirement Level, select one of the following:
    •No Constraint (The field will not require data in order to save a record.)
    •Business Recommended (A requirement level used for fields that should be filled in, but don't have to be, in order to save the record. Recommended fields are marked with plus symbols.)
    •Business Required (A requirement level used for fields that must be filled in before a record can be saved. Required fields are marked with an asterisk.)
    8.In Searchable, select whether to include this in the list of fields shown in Advanced Find for this entity and also in the list of fields available when customizing the find columns in the quick find view (The view used to display results of searches done using the Search box.) and the lookup view (The view used when a user clicks a lookup field.).
    9.For Field Security, enable or disable the feature for this field. More information: Add or remove security for a field
    10.For Auditing, enable or disable the feature for this field. More information: Auditing data in Microsoft Dynamics CRM (Auditing data in Microsoft Dynamics CRM, ./Help/ug_audit_about.htm)
    Important

    If you enable auditing, be aware that auditing tracks value changes to the field, but does not track enabling or disabling Field Security for the field.

    11.For new fields, select the Type, and then enter required information for the specified type. For existing fields, you cannot modify the type, but you can modify the settings for the type.
    See a list of possible data types for a field.


    Data Type
     Notes
     
    Single Line of Text
     The following formats are available:
    E-mail. This opens a new e-mail message in the default e-mail software when clicked.Text. This creates a text box.Text area. This creates a scrolling text box.URL. This opens the URL in the user's default browser when clicked.Ticker Symbol. This create a stock ticker symbol in all capital letters. Click the symbol to open information about the stock in the user's default browser. By default, the MSN Web site opens.Version Number. This creates a text box with this information.
    Option Set
     Select an existing option set, or define a new one.
     
    Two Options
     After creating this field, configure it in the form to which it was added. In the form, select whether the field is displayed as option buttons (also known as radio buttons), a check box, or a list.
     
    Whole Number
     The following formats are available for this field:
    None. The defaults are integer values between -2,147,483,648 and 2,147,483,648, although you can set different minimum and maximum values.Duration. This creates a drop-down list box with values in minutes, hours, and days.Time Zone. This creates a drop-down list box with options for every available time zone.Language. This creates a drop-down list box with options for every language that your organization has made available for users.
    Floating Point Number
     Select up to 5 precision points. You can set the minimum and maximum values.
     
    Decimal Number
     Select up to 10 decimal points. You can set the minimum and maximum values.
     
    Currency
     When you add a currency field to an entity, a corresponding (Base) (A corresponding money attribute for each money attribute in an entity. The (Base) attribute stores the value of the corresponding money attribute in the base currency.) field is created also. The (Base) field also has a currency data type.
    If the entity does not already have a field with a currency data type, two additional fields are created:
    Currency (A lookup field that allows money fields in a record to be associated with a currency.). A lookup data type whose value must be set before you can set the value of a field with a currency data type.Exchange Rate (An attribute included with any entity that contains a money attribute. The Exchange Rate attribute may be added to an entity form to display the exchange rate between the selected currency for the record and the base currency for your organization. When it is viewed in the form, this field is read-only.). This has a decimal number data type.
    Multiple Lines of Text
     This is a scrolling text box. You can set the maximum number of characters for this field.
     
    Date and Time
     There are two formats: date only, or date and time.
     
    Lookup
     You can create a lookup field using an entity relationship (A metadata configuration that allows for a related record to have a lookup field, which lets users link the related record to another record. Any related records can appear in a list that is visible from the record that they have been related to.) that has already been created, but not yet used with another lookup field. If you create a lookup field in an entity form, the relationship is automatically generated. A lookup field is created as a relationship field (A field that exists in a related entity when a hierarchical relationship exists. When added to the form of the related entity, a lookup control is displayed to allow the record to be related to another record as defined in the relationship.).
     


    12.Set Status Reason options
    Many entities (Structures used to manage data. Microsoft Dynamics CRM entities include Account, Case, and Activity.) have the status reason (The description of the status of a record or activity. For example, if a case has a status of Active, the status reason could be Researching or Waiting for Details. The options available are based on what type of record is open and the status of the record. When the status of a record changes, if more than one status reason is possible, a dialog box is displayed to enable the user to select the appropriate status reason.) business field (A standard Microsoft Dynamics CRM field that can be customized or added to a solution. When part of a solution, a business field might be further customizable, depending on the restrictions placed on it when created.), which can be customized. The status reason field is displayed like an option set (picklist) field except that it also contains a reference to the status (The state of the record. Most records can be Active or Inactive. Some record types have more possible states. For example, the Case entity uses Active, Resolved, and Canceled. You cannot modify the status values for an entity.) field.
    Valid values for status reason are dependant on the status field. You must first select the appropriate status before you can set the status reason options.

    13.Select the IME mode for this attribute.
    An Input Method Editor (IME) lets you to enter and edit Chinese, Japanese, and Korean characters. These writing systems have more characters than can be typed on a standard Western (QWERTY) keyboard. The IMEs for these languages use sequences of base characters that describe an individual character or group of characters to enter a larger set of characters. Base characters can be component letters from Korean Hangul syllables, phonetic components for Japanese kanji characters, or various combinations for Chinese characters. You can use the IME mode option to quickly enter these characters and symbols into text boxes, avoiding the manual switch to IME mode that would otherwise be required.
    Input Method Editors have two principle states, inactive and active. The inactive mode behaves like a Western keyboard and uses a limited set of characters. Depending on the settings in your operating system, the active mode accepts Chinese, Japanese, or Korean characters.
    The following IME modes are available:
    auto (default) The IME mode is not affected with this choice.
    active All characters are entered in the IME mode, but you can still deactivate it. For name-related fields and addresses, the default is active for detailed forms.
    inactive All characters are entered without using the IME mode, but you can still activate it. For date and time (datetime) type fields, the default is inactive for detailed forms.
    disabledThe IME mode is disabled, and you cannot activate it. For number type fields (floating point number [float], decimal number [decimal], currency [money]), the default is inactive for detailed forms.


    14.Click Save and Close to close the form editor.
    15.To publish view customizations for just one entity, in the Navigation Pane, click Entities. Then, on the Actions toolbar, click the Publish button.
    16.To publish all customizations you have made to any entities or components, on the Actions toolbar, click the Publish All Customizations button.
    Tip

    To change the name prefix for all new entities and fields, in the Navigation Pane, click Settings, click Administration, click System Settings, click the Customization tab, and then enter the prefix in the Prefix field.Each new entity or field created in Microsoft Dynamics CRM uses a prefix on the name to identify that the entity or field is not a system entity (A system entity, while a part of Microsoft Dynamics CRM by default, cannot be customized or added to a solution. System entities do not display in the Customization area.)or a system attribute (A system field, while part of Microsoft Dynamics CRM by default, cannot be customized or added to a solution. System fields do not display in the Customization area.). The default value is "New_". Using different prefix values provides a method to group customizations by the publisher.

  • Laura Bryant Profile Picture
    330 on at
    Re: How can I modify the industry drop down list in CRM?

    Hi,

    I have a query following on from the intial questions in this thread.

    Is there way to Add/Delete the industries and for it to apply accross both Accounts and Leads. I added them into leads and an employee now needs to change some industries in accounts however the ones I added didnt show.

    Also is there a way to bulk upload industries.

    Thanks

  • GL-23071537-0 Profile Picture
    on at
    Re: How can I modify the industry drop down list in CRM?

    Hi Laura,

    The Industry picklists on the Lead and Account are two separate picklists and they are mapped in the entity mappings.  It is very important that you maintain the two lists so that that they are identical and that the values associated with the descriptions match in both areas.  

    Below is a BAD example of how these can get out of sync.  The picklist item #3 is different on the Lead and Account.  So the user selects industry C on the Lead and when it converts to an Account, Industry D is displayed.  Very Confusing!!

    Picklist on Lead

    1 - Industry A

    2 - Industry B

    3 - Insdustry C

    Picklist on Account

    1 - Industry A

    2 - Industry B

    3 - Industry D

    So, definitely make sure they match exactly.  These mapped picklists are out-of-the-box picklists, and they were created in early versions of CRM.  In CRM 2011 Global Option Sets were introduced, and so now it would be best practices to use a global option set rather than mapping the picklists.

  • Laura Bryant Profile Picture
    330 on at
    Re: How can I modify the industry drop down list in CRM?

    Hi,

    Thanks for the quick response.

    I thought I would ask in hope that there was a way you could edit it globally, but thanks for making me aware of the issues I could come across when converting to an account.

    I started to create a new field on both forms, then creating an option set containing all the industries and linking it to that field. Do you think this would be my best option? Would this transfer over when converting from a lead to an account?

    Thanks

  • GL-23071537-0 Profile Picture
    on at
    Re: How can I modify the industry drop down list in CRM?

    Hi Laura,

    If I were just implementing industry for the first time, I would not use the out-of-the-box industry fields.  I would either create a Global Option Set and use this on both the Lead and Account, or I would create an Entity (lookup)  for Industry.  An entity would allow me to give rights to people to add industries to the list where as a Global Option Set must be updated by someone who can customize the system.

    Hope this helps!

  • Laura Bryant Profile Picture
    330 on at
    Re: How can I modify the industry drop down list in CRM?

    Hi,

    I have looked into setting up an entity.

    It is asking me what Target record type, this list contains words like account, article, goal fax email, lead etc.

    What should I choose?

    Thanks

  • GL-23071537-0 Profile Picture
    on at
    Re: How can I modify the industry drop down list in CRM?

    H2063.Industry-Relationship.jpg"/resized-image.ashx/__size/550x0/__key/CommunityServer-Discussions-Components-Files/117/5355.Industry-Entity.jpg" border="0" />

    Once you create the industy entity, then you can create the relationships to the Lead and Account.

    Then you add the lookups to the Lead and Account record and modify the mapping between between the Lead and Account.

  • Laura Bryant Profile Picture
    330 on at
    Re: How can I modify the industry drop down list in CRM?

    Hi,

    I have decided to go with the option set, so I can manage what gets added in the system.

    I have an excel spread sheet of industries, is there a way to easily import these into my created option set?

    Thanks

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans