Cell validation and cell data rollback after a change

[bsolTeamBglr]

Hi Param Query Team,
             We are using 3.4.0 version of Param query grid. I have few questions below,

1) I have 30 columns all are manual input values and 50 rows i want to update it daily. If i make mistake for a single cell is there a way to revert the original value as before for only that cell. otherwise by 30 minutes of work is waste for one mistake.

2) And i need to provide a data validation by showing a dialog with two option save and cancel for each cell to confirm entered value is correct or not. If i click save it should do cell save if i say cancel it has to give my original values.

I would like to have a dialog like attached in screen shot when i am doing each cell edit.

Kindly provide your input. Relevant answer also much appreciated.

Thanks
BsolTeam

[paramvir]

1. Undo feature can be used to revert back to original values. It can be invoked by shortcut key ctrl/cmd - Z or call history undo() method upon click of a button in toolbar.

2. Cells have their own inline editors which work similar to Excel. Enter saves the value in the cell and escape reverts back to original value. Data validation can be used with validation API in columns

Code: [Select]

                    validations: [
                        { type: 'minLen', value: 1, msg: "Required" },
                        { type: 'maxLen', value: 40, msg: "length should be <= 40" }
                    ]

Example: https://paramquery.com/pro/demos33/editing_batch

[bsolTeamBglr]

Thanks for your input. Your solution resolves my 1st query.

Coming to 2nd query
Validation i mean pop up as similar as attached. User needs to make sure entered data is correct or not by having confirmation dialog with two option for each cell having option save and cancel. Kindly assist.

[paramvir]

This kind of popup GUI as per your attachment is not supported inside the grid.

Grid has its own way of editing the cells by inline editors ( as mentioned in previous post ) and validations via validation API and validation popup.

[bsolTeamBglr]

ok Thanks. I understood Param query doesn't have this feature. Atleast is there a way to provide simple pop up with two buttons save and cancel. Save to do cell save and cancel to reject current cell changes.


Thanks