Difference between revisions of "Grid Column Attributes"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→Appearance) |
||
| Line 24: | Line 24: | ||
|- | |- | ||
|valign="top"|[[Grid Appearance#Column width|Column width]]||Specify the fixed width of this column (0 is autosized) | |valign="top"|[[Grid Appearance#Column width|Column width]]||Specify the fixed width of this column (0 is autosized) | ||
| + | |- | ||
| + | |valign="top"|[[Grid Appearance#Custom cell padding|Custom cell padding]]||Specify the padding for custom display and editor cells | ||
|- | |- | ||
|} | |} | ||
Revision as of 04:29, 13 August 2019
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) |
