Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

change Related records filtering

Posted on by Microsoft Employee

hello all,

is there an option or pluging which will allow us to change the field realted records filtering if different field contain data.

id.

I like all client which has account type (A)   can  access a lookup filed with a different Default view then Client which has  Account type (B) and so on.

Many thanks,

PJ

*This post is locked for comments

  • Suggested answer
    PS Profile Picture
    PS 23,577 on at
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: change Related records filtering

    Hi Inogic,

    Thanks for the links above.  below is what I like to achieve.

    Have a optionset and a lookup filed on Entity called "new_main"

    optionset has 3 different value  ( 1,2,3)   filed name "new_option"

    lookup called  "new_lookup"  relationship with Entity name "new_info"

    "new_info" Entity has two fields,  

    Primary filed which is text and a optionset

    there are 150 records save on the "new_info" Entity  

    back on the first Entity call  "new_main Entity

    if optionset "new_option" value 1 is select

    like to only show record 1 to 50 on Lookup filed.

    if optionset value 2 is select

    like to only show  record  51 to 100 on the Lookup type

    if optionset value 3 is selected

    like to only show record   101 to 150 on the lookup type.

    Many thanks,

  • Inogic Profile Picture
    Inogic 24,094 on at
    RE: change Related records filtering

    Hi,

    We think that you want to filter the lookup field based on the another field value. If we are correct then you can achieved this by using script. Please refer the below links which may help you to filter the filed.

    http://www.inogic.com/blog/2015/08/apply-custom-filter-on-lookup-field-in-dynamic-crm-using-script/ 

    http://www.inogic.com/blog/2014/12/how-to-show-filtered-lookup-dialog-in-dynamics-crm-through-script/ 

    HTH!

    Thanks!
    Sam

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: change Related records filtering

    hello all,

    Is there an option or plugin which will allow us to change the field related records filter view if different field contain data.

    i.e.

    I like all client which has Account type (A)   Access a lookup filed with a different Default view then Client which has Account type (B) and so on.

    Many thanks,

    PJ

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans