Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

How to add a new column to a grid while retaining the existing grid functionality

Posted on by

Hi There, I am new to Dynamics 365 development and have run into a lot of obstacles trying to make a particular customization, I keep thinking that there must be a simpler solution that I'm missing but everything I've tried so far comes up blank. Can someone please help me understand the best approach to my customization requirement in Dynamics 365 v9.

 

The requirement should be fairly simple, I would like to include an additional column in the "Product Line Items" grid on the Opportunity form.

 

By default this grid is linked to a managed view that is not customizable, so I have opened the view and used "Saved as" to create a copy. I then reference this view from the Opportunity form and at this point no changes have been made to the view.

 

With the above change the "Product Line Items" grid no longer functions as it used to, instead:
1) The up and down arrows allow you to change the order of product lines, however the order is never saved when leaving the form. There is no save button on the grid and the save button for the form does not trigger a save in the grid.

2) When creating a new record, instead of the quick create form opening it now redirects the page to the normal create form.

3) Inline editing functionality is lost.

 

For 2) and 3) I could probably convince our users to accept this if the alternative is to recreate the internal java script logic from scratch. But 1) is important.

 

So my underlying questions are:

a) Have I approached this customization correctly?

b) Is it possible to get some or all of the original grid functionality back without writing all of the client side java script from scratch? Surely it cannot require this much effort to add 1 additional column to a view especially since the internal java script appears to be completely off limits and obfuscated, so I cant even see what the current logic is doing as a starting point.

 

Thanks,
Dale

Categories:
  • RE: How to add a new column to a grid while retaining the existing grid functionality

    Thanks for your replies. I guess I'm out of luck on this one and the only option for this simple requirement is to rewrite a lot of code from scratch. Fairly frustrating when the Microsoft sales people punt this as a highly customizable system and make developers look like idiots when we cant add new field to an existing grid without a ridiculous amount of time and effort.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to add a new column to a grid while retaining the existing grid functionality

    I think you are talking about the subgrid in a form. I usually create a new view (including all columns I want) instead of editing the existing view. I find out that Editing is not working well even for any view.

  • Verified answer
    Ben Thompson Profile Picture
    Ben Thompson 6,350 on at
    RE: How to add a new column to a grid while retaining the existing grid functionality

    Sadly, the out of the box editable grids cannot be customised.  This may change in a future release but given the amount of custom code attached to the editable grids I doubt it will be in the near future...

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

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