Grid Appearance

See Also

Attachments Section Attributes, Colors, CSS, Data Attributes, Gradients, Grid Column Attributes, Grid Section Attributes, Section Appearance, Shading and Transparency, Split Grid Sections

Grid Section

Alternating row colors

Display alternating row colors (True | False)

• See Colors.

Automatic pagination

Grid is rendered using pagination if the number of records exceeds below amount (True | False)

Automatic pagination size

Grid is rendered using pagination if Automatic pagination is true and the number of records exceeds this amount

Autoresize columns

Autoresize grid columns to fit data (True | False)

Background color

Section background color.

• See Colors.

CSS style

CSS style (separate attributes with ; or use app:/filename.css).

• See CSS.

Desktop grid row height

Height of the grid rows on desktop

Enable inline cell editing

Enable inline cell editing in web/mobile (True | False). If False (default), cell contents are edited in the pull-left dialog panel. From v5.0.

• See this forum post

Edit memo/varchar editors

List of editors to be used in split grid form edit for memo/varchar fields. This is a comma separated list, e.g. html,text. From v6.0.

• See Split Grid Sections

Edit memo/varchar list

List of memo/varchar fields to be included in split grid form edit. This is a comma separated list, e.g. notes:caption1,notes2:caption2. From v6.0.

• See Split Grid Sections

Foreground color

Section background color.

• See Colors.

Gradient colors

Render the background color as a gradient (True | False).

• See Gradients.

Gradient end color

Gradient end color.

• See Gradients.

Gradient start color

Gradient start color.

• See Gradients.

Gradient type

Specify the gradient type.

• See Gradients.

Grid background color

Grid background color.

• See Colors.

Grid foreground color

Grid foreground color.

• See Colors.

Grid header background color

Grid header background color. Header custom color must be set to true.

• See Colors.

Grid header foreground color

Grid header foreground color. Header custom color must be set to true.

• See Colors.

Header custom color

Render the section header with custom colors (True | False). The custom colors are set in Grid header background color and Grid header foreground color.

Highlight selected rows

Highlight selected rows (True | False). Default is True. Can be set to False if grid is being used for display purposes only. From v6.3.

Infinitely scrollable

Grid is always rendered using infinite scroll for large data sets (mousewheel on desktop/web, flick up and down on mobile) (True | False).

Inline effect

The display effect for inline images and memos (None | Dropshadow | Raisedshadow).

Inline height

The display size height for inline images and memos.

Inline width

The display size width for inline images and memos.

Map Return to Down Arrow

Maps the Return key to the Down key when cell editing in web/mobile (True | False). From v5.0.

• See this forum post

Map Return to Tab

Maps the Return key to a Tab when cell editing in web/mobile (True | False). From v5.0.

• See this forum post

MultiSelect rows

Enable multi selection of grid rows. The SelectionChanged delegate is called as rows are selected or deselected (True | False)

MultiSelect rows expression

The expression to evaluate when a multi select row operation is performed. These are passed as a comma separated list to the SelectionChanged delegate.

Pagination

Grid is always rendered using pagination (for large data sets) (True | False)

Phone grid row height

Height of the grid rows on phone

Record mark expression

The record mark. Can include {} macros. From v5.2.

The Show record mark attribute must be True for the expression to be displayed.

The record mark column is displayed in place when the Grid Section is scrolled horizontally.

Record mark tooltip

The record mark tooltip. Can include {} macros. From v5.2.

The Show record mark attribute must be True for the tooltip to be displayed.

See screenshot above.

Return auto add row

If the Return key is pressed on the last grid row, a new row is automatically added (True | False). From v6.3.

Row dynamic background

The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'red',)

Row dynamic foreground

The expression or function that provides dynamic row color formatting. e.g. iif(amount<0,'white',)

Scrollbar

Section displays the grid vertical scrollbar (True | False).

Search bar min

The minimum number of characters that must be typed in the Instant Search search bar before searching. From v6.3.

Search bar visible

Show the Instant Search search bar (True | False). From v6.3.

• Type text and press Return and the search is carried out across all fields in the Grid's table.

Note: The search can be for multiple words using:

word+word2

where both words should exist in the record.

And:

word,word2

or:

word word2

where one word or another should exist. These can also be combined:

word+word2,word3+word4

Show actionbar

Show the actionbar (True | False)

Show grid lines

Show grid lines (True | False)

Show images inline

Show image columns as inline images (True | False).

Show logicals as CheckBoxes

Display logical/Boolean values as CheckBoxes (True | False)

Show memo/object panel

Show memo/object panel in splitbar mode (True | False)

Show memo/varchar inline

Show memo/varchar columns as inline text (True | False).

Show record mark

Show the record mark (True | False). From v5.2.

If True, the Record mark expression and Record mark tooltip will be displayed if specified. If no Record mark expression is specified, the record number will be displayed.

See screenshot above.

Show split edit

Display grid in split/form edit mode when displayed (True | False)

• See Split Grid Sections

Split grid

Split the grid into a grid and a form (True | False)

• See Split Grid Sections

Split grid component list

List of components to be included in split grid form edit. This is a comma separated list, e.g. component:/mylib.mycomp1(‘prop=value;...’);caption1,component:/mylib.mycomp2(‘prop=value;...’);caption2. From v6.0.

• See Split Grid Sections

Stretch last column

Stretch last grid column (True | False)

Tablet grid row height

Height of the grid rows on tablet

Transparency

Specify a transparency percentage from 0 to 100.

• See Shading and Transparency.

View Image list

List of image fields to be included in split grid form edit. This is a comma separated list, e.g. photo1:caption1,photo2:caption2. From v6.0.

• See Split Grid Sections

Web grid row height

Height of the grid rows on web

Web pagination size

Grid Web pagination size, default 50. From v6.3.

Grid Column

Alternating row colors

Whether this column should have alternating row colors if the grid does (True | False).

Background color

The background color of the column

• See Colors

Button

Display as a button (True | False).

Button caption

The (optional) button caption.

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.

Column width

Specify the fixed width in pixels of this column (0 is autosized).

Custom cell display

The name of a procedure/function that will return the display text for the cell.

• See Custom Renderers and Custom Editors and the 'Example smart grid' App (example_smartgrid) included in the distribution.

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.

• See Custom Renderers and Custom Editors and the 'Example smart grid' App (example_smartgrid) included in the distribution.

Custom cell padding

The padding (pixel) for custom display and editor cells.

• See Custom Renderers and Custom Editors and the 'Example smart grid' App (example_smartgrid) included in the distribution.

Dynamic badge color

Specify an expression to format the column as a colored badge, e.g. icase('{}'='available','lightgreen','{}'='occupied',pink,).

• From v6.3.1.
• See the 'Example Grid Badges' App (example_gridbadges) included in the distribution.

Dynamic Sparkline color

Specify an expression to define the dynamic background color of the Sparkline, e.g. icase({}>100,"red:white",{}<50,"pink","lightgreen").

• From v6.3.1.
• See also Spark line expression
• See the 'Example Grid Badges' App (example_gridbadges) included in the distribution.

Fixed column width

Should this column be a fixed width (True | False).

Only visible when editing

Only show this column when editing. Hidden otherwise at runtime (True | False). From v6.0.

Rating max value

Specify the maximum rating value. If the column is bound to a numeric source and the 'Rating max value' is greater than 0, the data is displayed as a rating.

• From v6.3.2.
• See the 'Example Grid Badges' App (example_gridbadges) included in the distribution.

Spark line expression

Specify an expression to determine the maximum spark line value, e.g. limit.

• From v6.3.1.
• See also Dynamic Sparkline color
• See the 'Example Grid Badges' App (example_gridbadges) included in the distribution.

From v6.3.2, Sparkline Charts are also supported.

Sparkline Charts are rendered if the Spark line expression is a comma separated list of values, so you can call a function to generate these and use {macros}.

Summary column

Include this column in the summary panel (True | False). Prior to v6.0 this was named Total this column. Minimum, Maximum and Average column values can now also be displayed along with the column Total.

• See Section Summary

Summary format

Specify an expression to format the Section Summary values, e.g. currency({}). Prior to v6.0 this was named Total format. Minimum, Maximum and Average column values can now also be displayed and formatted along with the column Total.

• See Section Summary

Text Alignment

Text alignment (Auto | Left | Center | Right).

Total expression

Specify an expression to calculate the column total, e.g. calc_column("{}"). Note that {} will be substituted with the data controlsource.

• See Section Summary

Total format

Specify an expression to format the column total, e.g. currency({}). From v6.0 this is renamed Summary format as Minimum, Maximum and Average column values can now also be displayed and formatted along with the column Total.

• See Section Summary

Total this column

Include this column in the summary totals (True | False). From v6.0 this is renamed Summary column as Minimum, Maximum and Average column values can now also be displayed along with the column Total.

• See Section Summary