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.
|
Enable Sort |
Shows or hides sorting arrows for the fields in a table. Default value is False.
|
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.