Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Editable grids update ...
Microsoft Dynamics CRM (Archived)

Editable grids update field not on view

(0) ShareShare
ReportReport
Posted on by Maarten Hamburg

Hi dear Dynamics community,

I'm quite new to the editable grids and I'm consulting you all hoping to receive an valuable answer.

Situation:

We have a view on (for example the) opportunities with column A,B,C,D.

We have a onchangehandler on column A which will change the value of column F (not in the grid) based on values in column C and E (not in the grid)

It there a way to handle this. For instance we do not have control on personal views, and we do not want to add all fields to the view in order to keep it clean.

With the function row.getData().getEntity().attributes; I'm only retrieving values who are in the view.

Any ideas?

Thank you for taking time!

*This post is locked for comments

  • Maarten Hamburg Profile Picture
    Maarten Hamburg on at
    RE: Editable grids update field not on view

    Thanks you for your reply. This was indeed what i was considering. Creating an webAPI request or plugin :-)

  • Suggested answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Editable grids update field not on view

    Hi Maarten,

     why don't you just create a workflow (or a plugin)? Or, maybe, an entity-scoped business rule..

  • Suggested answer
    Aric Levin Profile Picture
    Aric Levin 30,188 on at
    RE: Editable grids update field not on view

    If the attributes that you are looking to update are not on the view, you will need to add logic to update the entity.

    You can do that on the Change event of a particular attribute, but that is a little risky, cause the user might change the mind, and decide not to save the record, or refresh before saving.

    You can also do it on the Save event, by getting the values from the grid and updating the entity record using either webapi (with JavaScript), or a plugin message on Update.

    Either of these should work.

    Easiest solution though would be to show the columns on the grid. You can't hide them, but you can disable them if you would like.

    Hope this helps.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans