Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

How to get the name of a subgrid record and assign it to field

Posted on by 390

Hi All,

I am trying to display or assign a field the name of the topmost subgrid record. Example, say my account Entity has a subgrid of a custom entity, how can i display the name of the latest subgrid record on field in account entity. I thought quick view would do the trick, but i was wrong. Please someone with better experience help??

Thank you

*This post is locked for comments

  • Victor Onyebuchi Profile Picture
    Victor Onyebuchi 390 on at
    RE: How to get the name of a subgrid record and assign it to field

    @kokulan @charles, thanks it worked.

  • Verified answer
    Kokulan Profile Picture
    Kokulan 18,048 on at
    RE: How to get the name of a subgrid record and assign it to field

    Hi

    As Charles suggested, you can create background/real-time workflow to triger OnCreate (if you latest means last created) or trigger the workflow on ModifiedOn field change (if you latest means last modified custom entity record) and copy the value from this to account entity field.

    One thing to note, when workflow copies, if you adding record from Account from subgrid, the Account form will not refresh when the workflow triggers on a child record. You will have to manually force a refresh of the form to  get the value refreshed.

  • Verified answer
    Charles Abi Khirs Profile Picture
    Charles Abi Khirs 3,569 on at
    RE: How to get the name of a subgrid record and assign it to field

    Hello,

    Create a workflow that triggers on create of the entity used in the subgrid.

    In the workflow add a step that update the parent account (lookup field) field to the needed value based on the custom entity name.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans