Selectable Table General Properties

The Selectable Table element enables form users to select a row of data from the table and then use it to populate other fields within the form.

In addition, you can apply Rules to a selectable table when a row is selected.

Back to Form Elements

Related topic: Element Properties

Name

Description

Name

The table ID in the form.

Rules

Click to view, add, or edit Rule(s) which will be run when a row is selected from the table. See Rules for more information.

Column Span

The number of columns the table will span. Default value is 1.

Show Header

True (default): Show the column header.

False: Hide the column header.

Row Count

Lets you specify the number of rows while paginating content. Works only when Paginate content is set to true. Default value is 10.

Row Number Field

Select a field to use as the row number for the table.

Enable Search

Shows or hides a search box for searching or filtering information in a table. Default value is False.

  • True: Shows a Search box for the form user to enter search/filter criteria.

  • False: Hides the Search box.

Enable Sort

Shows or hides sorting arrows for the fields in a table. Default value is False.

  • True: Shows sorting arrows for the fields in a table to enable users to quickly sort data.

  • False: Hides sorting arrows.

Paginate Content

Set to False, content in the table will be displayed in a single page. Set to True, content will be paginated according to the Row Count setting. Default value is False.

Row Details

Provides on-demand access to table content. The content will be hidden until the Show Details context menu option is selected, at which time a dialog will appear with all the content of the “Row Details” property.

This property contains all the labels and fields that will be displayed (read only) at run-time with the Show Details menu option. This can be useful for providing secondary information, reducing the amount of table data when the form loads, and improving the overall layout and performance of the form.

Save Content

Set to True, this setting preserves the content in the form when the form is saved.

Propagate Changes to all Views

When you change style or properties for common labels in a form with multiple views, you will be prompted by a dialog box asking if you want to apply the changes to all views. You can propagate such changes automatically by setting the Element Property Propagate Changes to All Views to True. This automatically propagates style or property changes to all applicable views without prompting.

Group Styles

Border Width

The width of the border around the group. Possible values are None, Thin, Thick, Thicker, and Thickest. Default value is None.

Border Style

The style of the border. Possible values are None, Solid, Dashed, Dotted, Double, Groove, Ridge, Inset and Outset. Default value is None.

Border Color

The color of the border.

Table Width

The width (in pixels) for the table. The default value (0) enables to the table to dynamically resize with the browser (responsive design).

Advanced Settings

Key Column for Merging:

This drop-down will contain a list of all fields contained in the Selectable Table. Setting this 'key' will cause the form to perform a merge each time the table data gets updated, but only fields that are actually changed by the user are updated.

The value of the key should be the name of one of the table columns . Each row must have a unique key value. The key value indicates which column contains the key (for example, my:partnumber).

Tip for querying a SQL data source: Case matters.

If you are querying a SQL data source and then want to insert results into a selectable or repeating table, make sure that your query text matches the case of the SQL columns.

For example, if a column in the SQL database is COLUMN_1, then the Query will not work if it is querying column_1.