Grid Column Attributes

From Lianjapedia
Jump to: navigation, search

Details

Attribute Description
Heading The column heading
Meta types A comma separated list of metatype names. Not currently implemented.

Appearance

Attribute Description
Background color The background color of the column
Foreground color The foreground color of the column
Alternating row colors Should this column have alternating row colors if the grid does (True | False)
Fixed column width Should this column be a fixed width
Column width Specify the fixed width of this column (0 is autosized)
Custom cell padding Specify the padding for custom display and editor cells

Data

Attribute Description
Data source The table and column that this grid column is bound to
Default Default value as an expression, e.g. date(), 0.0, space(10)
Input mask type The inputmask type (Custom | Currency | Date | Email Address | Number | Text | Time | Alphabetic | Upper Case | Upper Case Alphabetic)
Input mask The inputmask for the field, e.g. @c2, @c4, @!, @^, 999,999.99 or ?regularexpression
Choices Restrict data input to a list of choices, e.g.
Static list of choices:
Apples,Oranges,Bananas
Dynamic list of choices from a table:
@tablename,expression
Dynamic list of choices from a table (SQL SELECT):
select expression from tablename
Validation Data input validation expression.
Note the use of {}, which is substituted with the current data entered, e.g.
Contained in a list:
inlist("{}","Apples","Oranges","Bananas")
Lookup the value entered in a table:
rlookup("{}",customers,"custnames")
Validation error message The error message to display if data input validation fails
Readonly Column is readonly (True|False)
Get data mapping Custom data mapping when reading data. Specify this as an expression.
Set data mapping Custom data mapping when writing data. Specify this as an expression.
Cell dynamic background The expression or function that provides dynamic cell color formatting.
e.g. iif({}<0,"red","")
Note the use of {}, substituted with the current cell value.
Cell dynamic foreground The expression or function that provides dynamic cell color formatting.
e.g. iif({}<0,"red","")
Note the use of {}, substituted with the current cell value.
Search panel field Include this column in an auto created Section search panel (True | False)
Recalculate Recalculate readonly and calculated fields when data is changed interactively (True | False)
Hyperlink Display as a hyperlink (True | False)
Button Display as a button (True | False)
Button caption The (optional) button caption
Text alignment Text alignment (Auto | Left | Center | Right)
Total this column Include this column in the summary totals (True | False)
Total expression Specify an expression to calculate the column total, e.g. calc_column("{}").
Note that {} will be substituted with the data controlsource.
Total format Specify an expression to format the column total, e.g. currency({})

Delegates

Attribute Description
Custom cell editor The name of a procedure/function that will return a custom editor for the cell. This may be a container with multiple controls.
Custom cell display The name of a procedure/function that will return the display text for the cell.

UI Presentation Rules

Attribute Description
Desktop Include this column in a Desktop client (True | False).
Web Include this column in a Web client (True | False).
Tablet Include this column in a Tablet client (True | False).
Phone Include this column in a Phone client (True | False).
UI States UI states that affect this column. Specify multiple states as a comma separated list.
Readonly when Column is readonly at runtime if specified expression evaluates to true.
Visible when Column is visible at runtime if specified expression evaluates to true.
Hidden at runtime Hide this column at runtime (True | False).
Display orientation Display depending on mobile device orientation for Tablets and Phones. (Always | Portrait | Landscape)