Skip to main content

Notifications

Announcements

No record found.

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

Editable grid autosave is not enabled. And it gets worst !

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I implemented editable grid. Found out that autosave is not enabled in the editable grid.

I have autosave turned ON for the entire system. If I edit both the form data and the editable grid WITHOUT saving either data, when the form autosave kicked it, the form data is saved but NOT the editable grid new data. The editable grid data reverted back to previous data.

I turned OFF autosave for entire system. I then edit both the form data and the editable grid data. When I click on the save button for the entire form, the form data got saved but the editable grid data revered back to previous data!

Does anyone have any trick to autosave the editable grid? or can make it so that when the form autosave kicked in, it saves both the form data and the editable grid data?

Thanks,

C.

*This post is locked for comments

  • djamr Profile Picture
    djamr 5 on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    Did you ever see a solution to autosave changes to the editable grid?  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    Is there any way to force save the editable subgrid with javascript? For an end user it is extremely frustrating to lose data they just entered. If you could force save it with JS then you could add it to the onsave event on the main form.

  • Verified answer
    ashlega Profile Picture
    ashlega 34,475 on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    Hi Charles,

     

      personally, I tend to agree with you, but, it seems, it's actually a "feature" rather than a "bug":

    https://msdn.microsoft.com/en-us/library/mt788311.aspx#BKMK_OnSave

    Some important points to consider for the OnSave event:

    • If a user edits multiple columns of the same record in sequence, the OnSave event will only be fired once to ensure optimal performance and form behavior compatibility.

    • Editable grid and the parent form have separate save buttons. Clicking the save button in one will not save changes in the other.

    • Editable grid does not save pending changes when navigation operations are performed outside of its context. If the control has unsaved data, that data may be lost. Consequently, the OnSave event may not fire. For example, this could happen when navigating to a different record using a form lookup field or through the ribbon.

    • Pressing the refresh button in the editable grid causes it to discard any pending changes, and the OnSave event won't be fired.

    • Editable grid control does not implement an auto-save timer.

    • Editable grid suppresses duplicate detection rules.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    Gopalan,

    When Auto Save Disabled (System wide):

      If I modified the form and try to get move away from the form without saving, CRM would warn "Your changes have not been saved. To stay on the page so that you can save the change, click Cancel". So I know I need to save before move on. If I modify the editable grid and without saving, move away from the form, NO warning, and the modification of the grid is gone. Same action, modification, but two different outcome. I would call that a bug.

     Also, if I modify a cell in one editable grid and then click on another cell on a DIFFERENCE editable grid, the previous edit does not get saved at all. I moved away from the form, no warning, all the edit are gone! A bug to me.

    When Auto Save Enabled ( System wide)

    As you stated, "We cannot edit both form fields and Editable Subgrid cell at the same time It may not save the modified cell ..." it's like saying you cannot edit two separate sections in a form at the same time, It might not save one of the section .... I would call that a bug also. You can't expect the user to modify one section and remember to save it before modifying another section on the same form! It's a bug in my book.

    Yes, I can train the user that every single edit, you need to click the save button, but that is a pain in the rear for the users. And if the user forgot to save and move away from the form the modification is gone without warning. I absolutely would call that a bug.

  • Suggested answer
    Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,401 on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    Hi

    When Auto Save Disabled (System wide):

    1. When a cell is modified, and select another cell in the same row, it will not save automatically.
    2. When a cell is modified, and select another cell in a different row, it would save the row immediately.
    3. When a cell is modified, and click the form save button will not save the edited row, but save the form values (date and time, single line of Text, numbers, lookup etc.) excluding the Editable grid rows.
    4. At any time, clicking the Save button at the top right corner of the Editable Subgrid would save all the modifications made in the cells.

    When Auto Save Enabled (System wide):

    1. We cannot edit both form fields and Editable Subgrid cells at the same time. It may not save the modified cell values, if form auto save happens before SubGrid save.

    2. Edit the form fields separately and save it using form save button.

    3. Edit the Editable Subgrid cells separately and save is using the SubGrid save button.

    4. If you want to disable Auto Save for a specific form,  we can do so using a 4 lines (standard) lines of JavaScript code.

    I hope I have not missed anything.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Editable grid autosave is not enabled. And it gets worst !

    77 viewed and no taker?  I take it that I stumbled on a CRM "feature"? ;)

    I would call it a bug because while I am editing the grid, the form autosave kick started and wipe out all of my current grid editing. That's absolutely a bug.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,514 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans