ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: mikep on May 14, 2020, 12:31:23 am

Title: onchange event for cell
Post by: mikep on May 14, 2020, 12:31:23 am

How can I trigger an event when a user edits a cell value. For Example, when the user change the revenue cell, I want to set the profits column. I tried render, but that gets triggered too often.

https://jsfiddle.net/xhk6yzwd/

Title: Re: onchange event for cell
Post by: paramvir on May 14, 2020, 09:25:04 am

It seems you are trying to setup column dependencies, for which javascript formulas are the right fit.

https://paramquery.com/pro/demos/grid_formula

https://paramquery.com/pro/api#option-formulas

Title: Re: onchange event for cell
Post by: mikep on September 20, 2021, 04:05:37 pm

I need to update a column, whenever another column in the row changes value. However, the initial value of the column has its own dataIndx. Could this still be accomplished via formula?

Title: Re: onchange event for cell
Post by: paramvir on September 20, 2021, 08:55:08 pm

In that case change event can be used.

https://paramquery.com/pro/api#event-change