Forums

Hi,

I have a Datatable with 3 editable columns A, B, and C (A + B). When the value of column A or B is changed, C should be updated with the corresponding A+ B value. I tried using the onEventEditCell but the event is not triggered when I edit a cell. Can anyone help me with this please?

Thanks in advance!

Thank You for the response Satyam. It helped.

I have one more question....I am trying to implement the Save functionality to Save the changes made to cells to backend database. I want to put a Save & Cancel buttons in a separate column for each row so that the whole row can be saved at a time to the backend instead of each cell. I want to Save all the column values in a particular selected row to the backend when Save button is clicked. And I want to revert back the editted column values to old values when Cancel button is clicked. How can I achieve this functionality?

Thanks in advance.

Hi Satyam,

Thanks for your response.....

{ key: "Actions", width: 200, resizeable: true, formatter: function (cell, rec, col, data) { cell.innerHTML = '<button class="MowButton MowBtnSize18-80" id="buttonSave" name="buttonSave" type="submit" value="Save" > Save </button> <button class="MowButton MowBtnSize18-80" id="buttonCancel" name="buttonCancel" type="button" value="Cancel"> Cancel </button>'; } }

I have added a column with 2 buttons Save and Cancel in the datatable as above. In CellClickEvent, I am able to find out which column is clicked, but how do I find out which button has been clicked?

Thanks.

Hi Satyam,

{ key: "Amount", label: "Credit Amount", editor: new YAHOO.widget.TextboxCellEditor({ disableBtns: true}), sortable: true, width: 200, resizeable: true, formatter: "currency" },
{ key: "AmountDup", width: 200, resizeable: true, formatter: function (cell, rec, col, data) { var amt = rec.getData("Amount"); cell.innerHTML = amt; }

I have 2 columns Amount and AmountDup in a datatable. The AMount & AmountDup column values are populating correctly on the Datatable on UI.But in CellClickEvent, when I am trying to get the data of AmountDup column....its returning Undefined. Why so? How can I get the data in AmountDup column?

myDataTable.subscribe("cellClickEvent", function (oArgs) {
var elRow = oArgs.target;
var oRecord = this.getRecord(elRow);
var amnt = oRecord.getData("Amount");
var amntDup= oRecord.getData("AmountDup");

Here the column Amount value is returned correctly but AmountDup column value is returned as "Undefined". Can you please help me with this?

Thanks.

Hi Satyam,

I want my yui Datatable cell editor to accept only integer numbers (no decimal numbers). How do I do that? Could you please help me with this?

Thanks in advance.