Dynamics Community Forum Thread Details

Updating Parent Record on delete of editable Sub-grid record

I have a parent record (budget) that I need to have a live update on the total of the child records (budget items). Each time the a Budget Item is updated/added/removed, I need to the parent records to update the total. This needs to be done on the parent (budget) form in real time with the budget items being in an editably sub-grid.

I tried the following code

var gridContext = formContext.getControl('EditableSubGridName');//Verify the subgrid is loaded, if not recursively call function againif (gridContext != null && gridContext != undefined) {    gridContext.addOnLoad(CalculateTotal);}

The above only gets called on a Save, it is not triggered on a deletion of a sub-grid record.

Hi Partner,

Sometimes sub-grid take more time to load onto the form than other controls, try adding the setTimeout() function to ensure that if your javascript code is executed before the control is available, we will wait and then try to attach the event to the control again.

Please refer to the following links for more details:

http://piyushnandanwar.blogspot.com/2017/12/call-javascript-function-on-sub-grid.html

https://community.dynamics.com/blogs/post/?postid=30889e72-e49a-4899-80e5-1cfcce2fee35

https://microsoft-business-applications.hcltech.com/development/subgrid-refresh-events/

Make sure that add the CalculateTotal function that you used in addonLoad() to the subgrid OnLoad event.

https://learn.microsoft.com/en-us/power-apps/developer/model-driven-apps/clientapi/reference/grids/gridcontrol/addonload

I hope you can verify my answer if it helps you! If you have any questions, please feel free to contact me.
Regards,
Leah

Quick Links

Subscribe to this forum!