- Getting Started
- Before You Begin
- How To
- Notifications
- Using VB Expressions
- Designing your App
- Events and Rules
- Rule: If-Then-Else
- Rule: Open a Page
- Rule: Open URL
- Rule: Close Pop-Over/Bottom Sheet
- Rule: Show Message
- Rule: Show/Hide Spinner
- Rule: Set Value
- Rule: Start Process
- Rule: Reset Values
- Rule: Upload File to Storage Bucket
- Rule: Download File From Storage Bucket
- Rule: Create Entity Record
- Rule: Update Entity Record
- Rule: Delete Entity Record
- Rule: Add to Queue
- Rule: Trigger workflow
- Leveraging RPA in your App
- Leveraging Entities in Your App
- Leveraging Queues in Your App
- Application Lifecycle Management (ALM)
- Basic Troubleshooting Guide
Apps User Guide
Table
Introduction
This app shows how to work with entities using the Table control.
Demo app - try it yourself
Demo app - instructions to use
- Tooltip - The text to be displayed when an app user hovers over the control. Use this to provide additional information on the control.
- Data Source - The source of data you want to display in the table. Valid data types are Data Table and Object Array. Once you fetch the data source, the table automatically detects the data columns.
-
Columns - The table columns you want to display in the table. Expanding each Column heading exposes the following column properties:
- Name - The display name of the column header. Gets populated automatically.
- Source - The source of the referenced column.
-
Add new column - Add new columns to your data by clicking the plus "+" icon.
- Hidden- If true, hides the control at runtime.
- Disabled - If true, disables the control at runtime.
-
Sortable - If selected, the table columns can be sorted.
-
Control Alignment - By default, it is set to Stretch. A different alignment can be set.
Note: The alignment is dependent on the layout selected for the parent (Vertical vs Horizontal). -
Background color - The background color for the Table header and Table body.
-
Border - The border for the control. Border Thickness, Color, and Radius can be configured.
-
Font - The font attributes for both the Column header and Column body text, such as font family, size, color, or style (Bold, Italic and Underline). By default, the control inherits the font family of the immediate parent container which is indicated by the keyword "Inherited".
-
Margin - The margin of the control. By default, a margin of 4px is set. Top/Bottom and Left/Right margin properties are combined. These properties can be detached using the Link button at the right side of the Margin section.
-
Size - The width and height of the control. By default, the Width is set to
auto
, and the Height is set to200px
. To set minimum or maximum values, click the three dot icon (...). If the size of the control is smaller than the options, a scroll bar is displayed.
Virtual scrolling enhances the performance by loading only the relevant items in the viewport at runtime. This only works when a height is configured and not set to auto.
If the Height property is set to auto, the size of the control at runtime and during design time may not match. This happens because the control height depends on the number of rows returned at runtime, while in design time the control is empty.
For any control with dynamic data, such as tables, dropdowns, or lists, we recommend configuring a fixed height for an improved performance.
For improved accessibility, you can use the following keyboard shortcuts in the columns list from the General tab in the configuration panel:
- Up and Down arrow keys to change the selected column
- Alt+Up arrow key to move the selected column up
- Alt+Down arrow key to move the selected column down
Make sure you already have a DataTable object in your app.
DataTables objects can be defined as input, output, or input/output arguments of a process. To use these DataTable objects, you need to reference the process where they are used as arguments.
DataTable only supports primitives in a column. Complex type arguments in a column do not function in DataTable.
Say you have a process named "Process_A", which has the DataTable objects as arguments:
Input arguments |
in_dt1 |
Output arguments |
out_dt1 |
Input/Output arguments |
inout_dt |
-
Navigate to the General tab of your Table control.
-
In the Data source field of the control, open the expression editor, and write the following expression:
Processes.<process_name>.<datatable_output_argument>.ToListSource
Processes.<process_name>.<datatable_output_argument>.ToListSourceFor example:
Processes.Process_A.out_dt1.ToListSource
Processes.Process_A.out_dt1.ToListSourceThe table columns should reflect the columns of the DataTable object.
VB property |
Data type |
Description |
---|---|---|
|
|
Currently selected item in the control. |
|
| Data source for the values inside the Table control. |
|
String | Information text which appears when the user hovers over the control. |
|
| The currently selected value of the control.
|
|
Boolean | If true, hides the control at runtime. |
|
Boolean | If true, disables the control at runtime. |