Validating Cell Values

You can use JavaScript methods to validate any cell when the structure browser is displayed in Edit mode and the Editable setting is true.

Typically, validation is initiated using the OnChange Handler setting defined for a column. The emxUIFreezePane.js file contains these methods that can be used for validation:


  • emxEditableTable.getCellValueByRowId: Returns an object that holds the actual/display values for both the modified and old values of the cell by referencing the rowID and column name.
  • emxEditableTable.getCellValuebyObjectRelId: Sets the displayed field value and actual field value by referencing a relId, objectId, and column name.
  • emxEditableTable.setCellValueByRowID: Sets the actual/display value of the cell identified using the rowId and column name.
  • emxEditableTable.setCellValueByObjectRelId: Sets the actual/display value of the cell identified using the relId, objectId, and column name
  • emxEditableTable.setCellEditableByRowId: Enables or disables edit mode for a cell identified using the RowId and column name.
  • emxEditableTable.setCellEditableByObjectRelId: Enables or disables edit mode for a cell identified using the RelId, ObjectId, and column name.
  • emxEditableTable.getCurrentCell: Returns details about the current cell.
  • emxEditableTable.getParentRowId: Returns the RowId of the parent row for the current cell.
  • emxEditableTable.getChildrenRowIds: Returns the RowIDs of the first-level children for the current cell.
  • emxEditableTable.reloadCell: If the column has the Reload Program and Reload Function settings defined, calls that method to reload the cell value.

See Appendix: JavaScript APIs for details on these functions.