Updating Parent Record on delete of editable Sub-grid record

(0) Share

Report

Posted on by Roddas77

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.

I have the same question (0)

All responses (1)

Answers (0)

Leah Ju Microsoft Employee on at

Like (0)

Report

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

Was this reply helpful? Yes No