Difference between revisions of "Grid Column Attributes"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
Line 53: | Line 53: | ||
|valign="top"|[[Data Mapping|Set data mapping]]||Custom data mapping when writing data. Specify this as an expression. | |valign="top"|[[Data Mapping|Set data mapping]]||Custom data mapping when writing data. Specify this as an expression. | ||
|- | |- | ||
− | |valign="top"|Cell dynamic background||The expression or function that provides dynamic cell color formatting.<br>e.g. iif({}<0, | + | |valign="top"|Cell dynamic background||The expression or function that provides dynamic cell color formatting.<br>e.g. iif({}<0,"red","")<br>Note the use of {}, substituted with the current cell value. |
|- | |- | ||
− | |valign="top"|Cell dynamic foreground||The expression or function that provides dynamic cell color formatting.<br>e.g. iif({}<0, | + | |valign="top"|Cell dynamic foreground||The expression or function that provides dynamic cell color formatting.<br>e.g. iif({}<0,"red","")<br>Note the use of {}, substituted with the current cell value. |
|- | |- | ||
|valign="top"|[[Section Search Panels|Search panel field]]||Include this column in an auto created Section search panel (True | False) | |valign="top"|[[Section Search Panels|Search panel field]]||Include this column in an auto created Section search panel (True | False) |
Revision as of 09:08, 6 April 2016
Under construction
Details
Attribute | Description |
---|---|
Heading | The column heading |
Meta types | A comma separated list of metatype names |
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) |
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 |
Custom control | The name of a procedure/function that will create a custom container/control to be rendered in the cell. Desktop only. |
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({}) |
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. |
Display orientation | Display depending on mobile device orientation for Tablets and Phones. (Always | Portrait | Landscape) |