Editable subgrid data update on save

(0) Share

Report

Posted on by sathish1109

110

I have an custom timesheet entity where I have a field "actual hours" which is updated by setting the difference in start and end time.I also have a decimal field "total " where it is calculated from actual hours.I also have another test entity where the data of timesheet enity are stored in an editable subgrid. I have done a script to calculate actual hours in the editable subgrid on change of start time and end time on the grid. Actual hours is getting calculated in the grid record and the timesheet record .But "total " field is getting updated only on save of the form . So on update of data from editable subgrid, though the actual hours is getting updated in the form, total is not getting updated. Any suggestions for updating total on change of actual hours from the grid.

*This post is locked for comments

All responses (3)

Answers (2)

Verified answer

sathish1109 110 on at

Like (0)

Report

RE: Editable subgrid data update on save

Hi,

I ve achieved my requirement using a business rule with scope as "Entity".

Thanks and regards,

Sathish kumar S
sathish1109 110 on at

Like (0)

Report

RE: Editable subgrid data update on save

Hi Neil Parkhurst,

Your idea of adding total field to editable grid will help me solve the problem. But based on my requirement the view should not contain total field in the subgrid. Is there a chance that i can add the field to the grid and hide it from the view.?
Verified answer

Neil Parkhurst 10,725 User Group Leader on at

Like (0)

Report

RE: Editable subgrid data update on save

When you say script, I assume you mean JavaScript that is being triggered by the editable grid.

Have you included the total field in the editable grid? I suspect it might need to be included.

If this doesn't solve you issue could you post a copy of your script. It might be that seeing your script will help provide an answer to your issue.