Capture the editable cell value during onRequesting()

Hi all,

Has anyone come up with a method to capture the editable cell value in a datagrid, during the onRequesting() event?

Our work around at the moment is to read the value of the cell during onRequested() or onRequestCompleted(), however if the value the user has input isn't what we require, we have to run another API to reverse the value, then run an F5 call to refresh the screen.

It would be a lot simpler to be able to capture the edited cell value during onRequesting(), so that if the value fails validation we could just cancel the server call (args.cancel = true).

It might be that the answer lies in adjusting what's available in IActiveGrid to allow access to some of the slickgrid functions.

Cheers,

Iain

Find more posts tagged with

Accepted answers

All comments

Legacy Contributor

Hi @ihiggins

For your requirement there is a sample given by Infor in the samples section in the H5 SDK, can you please refer the "H5SampleSelectionChanged" JS file.

antonio-caria

https://smartofficeblog.com/h5-scripting/

ihiggins

Thanks Sudhakaran, although I'm not sure this is the answer I'm looking for.

I'm looking to capture the contents of an editable cell, which is blank initially, then the user enters a value and presses ENTER. At that point, I'm wanting to capture that value the user has just entered, specifically during the onRequesting event. The example you gave me looks to only be able to capture values that are already populated in the grid, and it does that during the onSelectionChanged event rather than onRequesting.

depm-636-Secure Relational Reporting_2.mp4

ihiggins

Hi Antonio,

I've read through the blog and I'm not sure there's anything helpful there. I'm looking to capture the contents of an editable cell, which is blank initially, then the user enters a value and presses ENTER. At that point, I'm wanting to capture that value the user has just entered, specifically during the onRequesting event. I should also note this is H5.

It might be that I have to somehow capture it via the DOM?

Thanks for trying.

0712050809193544.doc

ihiggins

The thing that worked in the end was passing the slickgrid row / column id. Once you have determined the row and column being edited, you can get the value before the server call (i.e. onRequesting()) by using ScriptUtil.GetFieldValue("RxCy") where x is the row and y is the column.

e.g. ScriptUtil.GetFieldValue("R2C4")

Copyright © 2025 Infor. All rights reserved.