How can I handle inline edit validation in jqxTreeGrid when parent totals must e

[vitorioParticipant]

Hi everyone, I am working on an internal admin dashboard with TreeGrid.

I am currently trying to solve this: How can I handle inline edit validation in jqxTreeGrid when parent totals must equal sum of child values?

So far, I verified this is not a CSS-only issue, but state gets out of sync after user interactions.

What would be the cleanest way to implement this?

[adminKeymaster]

Hi vitorio,

The cleanest approach is to validate at the data layer rather than relying only on the editor. In jqxGrid, you can use the cellvaluechanging or cellendedit events to intercept edits, recalculate the affected parent’s total, and compare it against the sum of its child rows. If the validation fails, either reject the edit by returning the old value (when using cellvaluechanging) or immediately revert the cell value with setcellvalue after displaying a validation message. Keeping all aggregate calculations in a single validation function helps avoid duplicated logic and ensures the grid state remains consistent after sorting, filtering, or other user interactions. If parent totals are derived values, it’s often even cleaner to calculate them automatically from the children instead of allowing users to edit them directly.

Regards,
Peter

[Author]

Posts