Table of Contents

Conditional Cell Read Only state

You can specify a column to be read only, but if you need the read only state of cells to be set individually based on the contents of the grid (or by hard coded values), you must configure Cell Read Only Rules. The Cell Read Only Rules use the formula syntax to address and evaluate the read only state of cells.

  • Name

The name of the rule. This property is used for management purposes only.

  • Disabled

Specifies whether the rule is enabled or disabled. Mainly used for temporarily disabling rules while debugging or configuring the grid.

  • Target

The address of the cells to mark as read only if the Statement fails (returns false). Cells are addressed using standard Eaze syntax.

  • Statement

The Eaze expression used for evaluating the read only state. The statement must return true if the cell should become read only, otherwise false.

Example

Set Qty to read only if Amount is greater than 100

Target: @Qty[]
Statement :@Amount[] > 100

Example

Set Qty cell to read only for all rows which have been saved to the database at least once.

Target: @Qty[]
Statement : @PBRowIdentity[] != -1