(7)-b-1. DataTable

Common Property

ID

Component ID defined in SkyVisualEditor

Object Label

Relation Field Label

Shows label name of parent child object and lookup relation field.

Relation Field

Shows API name of parent-child object and lookup relation field.

var

Variable used within the Visualforce to show Table Data Collection

Layout

Adjust Page

Set the table wide to the page width. This property is active when Output Tag is set as DataTable.

Left(X)

Set horizontal position on the screen on the free layout.

Top(Y)

Set vertical position on the screen on the free layout.

Width[px]

Set the width of the DataTable in pixels.

“Adjust page” should be set to off to use this property.

Height Adjustment

Select to define a row height for the table.
When unchecked, the table will stretch to dynamically meet the necessary height of the contained values.

Height[px]

Set the height of the DataTable in pixels.

Height Adjustment for row

Select to define the height for header row and detail row. This property is active when checked.

Header height[px]

Table header row height in pixels.

Row height[px]

Table row height in pixels

Appearance

Columns

Set the number of columns in the table.

Selectable from 1 to 40.
(* Search screen template only displays in the range of 1 to 50) 

Max Record Count

Shows the maximum record number. （input range: 1～1000）

Defaulted at 500 rows.

Output Tag

Select table style from below.

・PageBlockTable

　Table width is equal to the page width and table height expands with the number of rows.
　Only selectable if the DataTable is placed in a page block.

・DataTable

Manually Set the Table Width and Height.

Fix Header Location

The table’s header location can be fixed when the check box is turned on.

Theme

Select the style of the DataTable.

・None＝No color

・Salesforce(blue)＝Salesforce’blue

・Green＝Green

・Gray＝Gray

・Orange＝Orange

・Custom

This is selectable only if Output Tag is set to DataTable.

Custom header color

Select the color of header from Color picker or enter 16 bit color code.

*Available when the Theme is set as custom.

Table Feature

Show RowCount

Set to show or hide a number of records in the table. 

Sort

Activate the sorting feature for tables.

Default setting: Checked on (Activated)

Paging

Allow the user to page through many results

We recommend you to use paging for DataTables with very large numbers of records.

Show Rows

When paging is active, select the number of records to show in one page from below.

5,10,25,50,100

This property is only available when paging is active.

Add Row button (True)

Enable or disable “Add Row” feature for Tables.

This feature is available when check is turned on, and Salesforce User is authorized to edit “LookUp Field Label name” in security setting
(which is, “LookUp” is check on and “LookUp Only” turned off.)

*Note: The “Add Row” button will appear if the permission level to "reference Item API reference name” property is edit
(Visible and Read-Only).

Edit Add Button Value

Overwrite the Add Button label

Add Button Value

The Add Button label. Default value is Add.

Set number of additional rows

Set the number of rows to add. Numbers can be selected from Combo Box one to five.

This feature is available when “Add Rows” is checked

This feature is available when check is turned on, and Salesforce User is authorized to edit “LookUp Field Label name” in security setting
(which is, “LookUp” is check on and “LookUp Only” turned off.)

When adding a new line, you can set whether to move to the new line automatically.

This option is available when "Paging" or "Height Adjustment" is enabled.

If enabled, the following behaviour will occur when adding a line.

　Automatic paging: automatically moves the paging to the last page of the line added.

　Scroll Auto Move: automatically scrolls to the end of the line being added.

※Please note that if the "Fix Header Location" option is enabled, the "Scroll Auto Move" option will not work.

Default additional lines

The number of new records to be added by default as blank rows.

*Note: this will not show if not related to “Relate to the main object” when placing the component

Specify the number of rows

Set the number of rows to be added at a time. Select between adding 1 to 5 rows. This is active when the Row Addable property is set.

Delete button

Button will show when the box is checked. 

This feature becomes unmodifiable when “add row” is checked on. You must click “save” button to fully erase the row
(clicking “erase row” button will not erase the data immediately)

Edit Delete Button Value

Overwrite the Delete Button label

Delete Button Value

The Delete Button label. Default value is "Delete".

Bulk Edit

Set Bulk Edit feature for Table

Button for Bulk Edit will show when checkbox is turned on.

Edit Bulk Edit Button Value

Overwrite the Bulk Edit Button label

Bulk Edit Button value

The Bulk Edit Button label. Default value is Bulk Edit.

Delete Selected Button Value

The Deleted Selected Button label. Default value is Delete Selected

Edit Select Delete Value Button

Select to edit “Select Delete Button Value”

Select Delete Button Value

Value for “Select Delete Button” can be edited when check box is turned on. Default setting is “Select Delete.””

Show row copy button

Copy record data within the table.

 “Row Copy” button will show when check is turned on and also when the
Salesforce user has the permission to edit “reference item for API reference name.”

[Items that can be cloned]

 -Items on the screen

 -items that are set in the “additionally retrieve object item” property.

Edit Clone Button Value

Overwrite the Clone Button label

Clone Button Value

The Clone Button label. Default value is Clone.

Edit value for “show in detail” button

Select availability to edit the value of “show in detail button”

Available when table is selected for “detail

 panel”

Detail button value

Button value for “Show in Detail” can be changed when “Edit the button value of Show in Detail” is checked on.

Default value is “Show in Detail “

Show check box column

Shows check box on the left side of each record.

Available when JavaScript or Extended Apex Class is in use.

Available when Bulk Edit/Erase is not active.

Table Message

Select to show/hide a table message

Table Message Setting

Set the content of the [Table Message]

For details see < (3) Table Message Setting >

Client-side Filter

Add search box to the table to search items for partial text match.
For details see < (5) Search box for Table >
This property is displayed only when the property "Search Result Maintenance Method" is "client side". 

Inline Edit Available

Show if inline editing is available.

*Available when “Inline Editing is Available” on Page property is checked on.

Advanced table feature

Remove Required

By making the required fields optional at input time you can copy multiple rows and
input data afterwards whereas if required fields are required at input time you must fill out an entire record before copying it.

Search Condition

Set the filter criteria for the records in the table.

For details see < (1) Table Condition Setting >

Read-only

Settings for Read-only data tables.

When placing a Reference Field within a table, you can fasten the time to display a screen This will minimize the view state usage size as well.

Conditions bellow will apply when checked on:

-When Inline Editing feature is set active, this component will not be available for do inline editing.

-The Input Field in a table will automatically change to View Field.

-Unable to set Input Field in a table.

Default setting:

-Checked on: Search Template (View), Custom Look-up Template, Dashboard Layout

-Checked off: Salesforce Layout, Free Layout, Search Template (New/Edit, Complex), Parent-Child Template, Wizard Template

Search Result Maintenance Method

In the search template, select where to store and process result data.

For details, refer to < (1)-b. Selecting the Search Results Maintenance Method >.

・Client side

・Server side

・Run query

Default value: Client side

※Displayed only on the table in the search template

Confirm Save

Show “confirm dialogue box” when paging, sorting, and search execution. However, the dialog is hidden at the first search.

 -User designated: Users can choose to show its availability by checking “Do not show this message again.”. Default is set on.
-Confirm dialogue [ON]: Always show
-Confirm dialogue [OFF] Do not show

*Available when “Run query” is selected in Search Result Preservation Method.

Re-rendering Range

If the choice for “Search Result Maintenance Method” is “server side”,
update the screen and display the specified data for searching, [aging and sorting out process.
Choose the range of the screen you update from below:

・Full page

・Data table

Default value: Full page

※Displayed only when the “Search Results Maintenance Method” is on the server side

Custom Lookup

Custom Lookup Page

Select a page made from the custom lookup template.

When this field is set, you will be shown the custom lookup dialog upon clicking the add button.
Please indicate in the template if the select should be single or multiple.

Target Lookup Field

Choose the field that ties the object of the custom lookup page to this page.
This field is displayed when the custom lookup page is set and there are multiple fields that relate between the target object and the page object.

This feature is available when user is authorized to edit “LookUp Field” in security setting
(which is, “LookUp” is turned on and “LookUp Only” is turned off.)

 A “GetMaster” Button will appear on the screen to indicate that this feature is active.

Edit Master Retrieval Button value

Overwrite the Master Retrieval button label

Master Retrieval Button value

The Master Retrieval Button value. The default is Master Retrieval.

Tab Index

Tab index

Select cursor move order when pressing tab key

Development

JavaScript

Call a Javascript function from the table.

For details, see < (2) Table Script Editor >

Additional Object Field

Display Settings

Style Class

Set Style Sheet. Click the  to show Style Class Editor.
Please refer to < (9)-c. Style Class > for more information.