Data Table Component
Overview
The Data Table component acts as a spreadsheet for referencing data, like an Unqork Data Collection. In a Data Table component, you can manually enter or import submission data Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections. to store in columns and rows that are hidden from the end-user End-users, also known as Express Users, are the individuals accessing an application through Express View. In most cases, end-users are the customers using the product. in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View..
Depending on your needs, you might incorporate Data Table components with other components. Common components include the ViewGrid and Data Grid components, which display table data to the end-user as a dashboard. You can also execute formulas by combining the Data Table component with the Data Workflow or Calculator component. You can also create a binded table that uses the Data Table component's dynamic values to add or change data using a Data Workflow component.
For more information on binded tables, see our Input Operator Use Case: Binded Tables article.
You'll find the Data Table component in the Display & Event Processing group to the left of the Module Builder.
Display Settings
Field Text
|
Setting |
Description |
|---|---|
|
Canvas Label Text |
A component’s Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the Module Builder. User-friendly labels make your module more accessible. Keep labels short and descriptive (a word or two) using title case. For longer entries, use sentence case. |
Data Settings
Data Storage
|
Setting |
Description |
|---|---|
|
Store Data in Database |
The Store Data in Database setting affects how data persists through your application. When set to (ON), Unqork stores values entered into the field to the database (server-side submission). This occurs in three scenarios:
By default, workflows persist data from all fields in the client-side submission when navigating between screens. However, only values from fields with Store Data in Database enabled store in the server-side submission. Set the toggle to (OFF) when you don’t want to store the values from this field in the database. When using a Plug-In to remote execute a module, ensure data moving between modules is persistent. You can optionally enable Store Data in Database for components in the source module. But any components in the API module whose values are included in an API response must have Store Data in Database enabled. When a component’s data is not persistent, the data isn't included in an API call's response. So, Plug-Ins or external services requesting data from the API module can't receive non-persistent data in the response. To learn more about Store Data in Database in the context of API modules, see the panelResponse Panel section of the API Specification Snippet article in our In-Product Help. Store Data in Database also affects what data is tracked using Unqork’s built-in tracker. When the Enable Tracker and Track Value toggles are set to (ON) in Module Settings, only values from fields with Store Data in Database enabled are tracked. By default, Store Data in Database is set to (OFF). |
Inputs
The Inputs data table stores data as an array. Each item in the list represents a row in the table. The table displays a collection of columns and rows. Row 1 in the Data Table defines the title header for each column. For example, if you have a column containing a list of vehicle types, then your first row header could be vehicles.
Right click on a cell to see the following options:
|
Setting |
Description |
|---|---|
|
Insert Row Above |
Adds a empty row above the selected cell. |
|
Insert Row Below |
Adds an empty row below the selected cell. |
|
Remove Row |
Removes the row containing the selected cell. You can select multiple rows to remove at the same time. |
|
Cut |
Cuts the cell's data and stores it in your local machine's clipboard data. You can cut multiple cells or rows of data at the same time. |
|
Copy |
Copies the cell's data and stores it in your local machine's clipboard data. You can copy multiple cells or rows of data at the same time. |
|
New Row |
Adds a new row to the bottom of the Data Table. |
Actions Settings
Set Execution
|
Setting |
Description |
|---|---|
|
Disable Execution |
The component is active in the Module Builder. While active, other components and processes can reference your component. Setting the toggle to (ON) makes your component inactive. Other components and processes cannot reference your component while it's inactive. By default, the Active toggle is set to (OFF). |
Adding a Data Table Component
Configure a Multi-Select Dropdown component to reference a Data Table component. Then, set up the Multi-Select Dropdown component to ask your end-user which vehicles they own.
Configure the Data Table Component
This Data Table component supplies the vehicle labels and values for your end-user to select from a drop-down menu in Express View.
These instructions assume that you have an open module saved with a title.
| 1. | In the Module Builder, drag and drop a  Data Table component onto your canvas. |
| 3. | Navigate to the component's Data settings. |
| 4. | In the Inputs table, enter the following: |
| A | B | |
|---|---|---|
|
1 |
label |
value |
|
2 |
Sedan |
sedan |
|
3 |
Coupe |
coupe |
|
4 |
SUV |
suv |
|
5 |
Truck |
truck |
|
6 |
Motorcycle |
motorcycle |
|
7 |
Tractor |
tractor |
|
8 |
Horse and Buggy |
horseAndBuggy |
As a best practice, enter column titles in lowercase, with no breaks or special characters.
| 5. | Click Save Component. |
Configure the Multi-Select Dropdown Component
Then, configure a Multi-Select Dropdown component to reference your Data Table component data so your end-user can select one or more options.
| 1. | Drag and drop a  Multi-Select Dropdown component onto your canvas, placing it below the dtVehicles Data Table component. |
| 2. | In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. field, enter vehicles. |
| 3. | In the Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. field, enter Vehicles. |
| 4. | Navigate to the component's Data settings. |
| 5. | From the Data Source Type options, select Data Reference Key. |
| 6. | In the Data Reference Key field, enter dtVehicles. This reference key refers to the Property ID of your dtVehicles Data Table component. |
| 7. | Click Save Component. |
| 8. | Save your module. |
Click Preview to explore the Multi-Select Dropdown component's functionality in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View.:
Structure of a Data Table Component's Data
The Data Table component's data stores in submission data Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections. as an array of objects. In the example below, the dtVehicles Data Table component displays the content of each Data Table row in an object. Opening an object in the array displays a set of key/value pairs, where the key is the header name (first row) of the column, and the value is the data stored in the row of the column.
Here's how a Data Table looks in the component configuration view:
Here's how the same data table looks in the DevTools Console The DevTools Console helps you securely store, build, test, and deploy your software.:
Overview
The Data Table component acts as a spreadsheet for referencing data, like an Unqork Data Collection. In a Data Table component, you can manually enter or import submission data Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections. to store in columns and rows that are hidden from the end-user End-users, also known as Express Users, are the individuals accessing an application through Express View. In most cases, end-users are the customers using the product. in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View..
Depending on your needs, you might incorporate Data Table components with other components. Common components include the ViewGrid and Data Grid components, which display table data to the end-user as a dashboard. You can also execute formulas by combining the Data Table component with the Data Workflow or Calculator component. You can also create a binded table that uses the Data Table component's dynamic values to add or change data using a Data Workflow component.
For more information on binded tables, see our Input Operator Use Case: Binded Tables article.
You'll find the Data Table component in the Display & Event Processing group to the left of the Module Builder.
Display Panel
Field Text
|
Setting |
Description |
|---|---|
|
Canvas Label Text |
A component’s Canvas Label Text indicates the purpose of the corresponding field or component. For non-input components, the Canvas Label Text isn't end-user facing, and only appears in the Module Builder. User-friendly labels make your module more accessible. Keep labels short and descriptive (a word or two) using title case. For longer entries, use sentence case. |
Data Panel
Data Table
The data table stores data as an array. Each item in the list represents a row in the table. The table displays a collection of columns and rows. Row 1 in the Data Table component defines the title header for each column. For example, if you have a column containing a list of vehicle types, then your first row header could be vehicles.
After saving the Data Table component, empty columns and rows are removed from the table.
Settings in the Data Table include:
|
Setting |
Description |
|---|---|
|
··· (Column options) |
For existing Data Tables, hovering over the rightmost column displays the ··· (column options) button. Clicking the button displays the following options:
There must be at least one column in a Data Table to successfully save it. |
|
+ New |
Adds a new row to the bottom of the Data Table. |
Data Storage
|
Setting |
Description |
|---|---|
|
Store Data in Database |
The Store Data in Database setting affects how data persists through your application. When set to (ON), Unqork stores values entered into the field to the database (server-side submission). This occurs in three scenarios:
By default, workflows persist data from all fields in the client-side submission when navigating between screens. However, only values from fields with Store Data in Database enabled store in the server-side submission. Set the toggle to (OFF) when you don’t want to store the values from this field in the database. When using a Plug-In to remote execute a module, ensure data moving between modules is persistent. You can optionally enable Store Data in Database for components in the source module. But any components in the API module whose values are included in an API response must have Store Data in Database enabled. When a component’s data is not persistent, the data isn't included in an API call's response. So, Plug-Ins or external services requesting data from the API module can't receive non-persistent data in the response. To learn more about Store Data in Database in the context of API modules, see the panelResponse Panel section of the API Specification Snippet article in our In-Product Help. Store Data in Database also affects what data is tracked using Unqork’s built-in tracker. When the Enable Tracker and Track Value toggles are set to (ON) in Module Settings, only values from fields with Store Data in Database enabled are tracked. By default, Store Data in Database is set to (OFF). |
Actions Panel
Set Execution
|
Setting |
Description |
|---|---|
|
Disable Execution |
The component is active in the Module Builder. While active, other components and processes can reference your component. Setting the toggle to (ON) makes your component inactive. Other components and processes cannot reference your component while it's inactive. By default, the Active toggle is set to (OFF). |
Adding a Data Table Component
Let's configure a Multi-Select Dropdown component to reference a Data Table component. Set up the Multi-Select Dropdown component to ask your end-user which vehicles they own.
Configure the Data Table Component
This Data Table component supplies the vehicle labels and values for your end-user to select from a drop-down menu in Express View.
These instructions assume that you have an open module saved with a title.
| 1. | In the Module Builder, drag and drop a Data Table component onto your canvas. |
| 3. | In the data table, enter the following: |
| A | B | |
|---|---|---|
|
1 |
label |
value |
|
2 |
Sedan |
sedan |
|
3 |
Coupe |
coupe |
|
4 |
SUV |
suv |
|
5 |
Truck |
truck |
|
6 |
Motorcycle |
motorcycle |
|
7 |
Tractor |
tractor |
|
8 |
Horse and Buggy |
horseAndBuggy |
As a best practice, enter column titles in lowercase, with no breaks or special characters.
| 4. | Click Save & Close. |
Configure the Multi-Select Dropdown Component
Then, configure a Multi-Select Dropdown component to reference your Data Table component data so your end-user can select one or more options.
| 1. | Drag and drop a Multi-Select Dropdown component onto your canvas, placing it below the dtVehicles Data Table component. |
| 2. | In the Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. field, enter vehicles. |
| 3. | In the Label Text Label Text conveys what the input component is and what information it displays. Enter the purpose of the corresponding component or field. field, enter Vehicles. |
| 4. | From the Data Source Type options, select Data Reference Key. |
| 5. | In the Data Reference Key field, enter dtVehicles. This refers to the Property ID of your dtVehicles Data Table component. |
| 6. | Click Save & Close. |
| 7. | Save your module. |
Click Preview to explore the Multi-Select Dropdown component's functionality in Express View Express View is how your end-user views your application. Express View also lets you preview your applications to test your configuration and view the styling. This is also the view your end-users will see when interacting with your application. After configuring a module, click Preview in the Module Builder to interact with the module in Express View.:
Structure of a Data Table Component's Data
The Data Table component's data stores in submission data Also known as Record Data. Submission data consists of information saved by Unqork components. View submission data by using the angular command, or in Record Collections. as an array of objects. In the example below, the dtVehicle Data Table component displays the content of each Data Table row in an object. Opening an object in the array displays a set of key /value pairs, where the key is the header name (first row) of the column, and the value is the data stored in the row of the column.
Here's how a Data Table looks in the component configuration view:
Here's how the same data table looks in the DevTools Console The DevTools Console helps you securely store, build, test, and deploy your software.:
Resources
