Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Global Optionset
Microsoft Dynamics CRM (Archived)

Global Optionset

(0) ShareShare
ReportReport
Posted on by New Crm learner

Example: I have a requierement to create Car, Bike, Home, Mobile fields which datatype is a Option set. All this fields have same option set values as Interested, Not interested, Blank. So, should I create a global option set values and use it for all 4 fields. If I create this Global picklist and use it for all 4 fields I am not sure how this is going to save in the database for each  field. Any help in understanding how this stores in Database is highly appreciated.

Thanks

*This post is locked for comments

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
    RE: Global Optionset

    There's nothing wrong in doing what you have posted. its no where written that you cant use a global option set multiple times in the same entity. There should be any db related complications.

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: Global Optionset

    Hi Sam,

    I think it is better to create 4 different option sets for all the 4 fields instead of creating a global option set. Global option set is used in scenarios where the same option set is to be used in multiple entities.

    Please refer the following link.

    http://eimagine.com/dynamics-crm-local-vs-global-optionsets-picklists/

    www.powerobjects.com/.../when-to-use-a-global-option-set-vs-a-custom-entity

  • Suggested answer
    Rutul Chauhan Profile Picture
    Rutul Chauhan 2 on at
    RE: Global Optionset

    You can create 4 global option set for all 4 fields and set values under each. Benefit of that is, you can use that option set in multiple entities. However you have also to create fields in each entity.

    If you create single global option set, then you have to incorporate all values under single field which is not suitable way

    For more info about global option set please refer: technet.microsoft.com/.../dn531201.aspx

    Regards,

    Rutul

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans