Data Table Component
Overview
The Data Table component acts as a spreadsheet for referencing data, like using Unqork's Data Collections. In a Data Table component, you can manually enter or import data to store in cells arranged in columns and rows. The Data Table component stores data in the 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., which doesn't display to 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..
Depending on your use case, you might incorporate Data Tables with other components. Common components include the ViewGrid and Data Grid components, which display table data. To execute formulas, use the Data Table component with the Data Workflow or Calculator components.
You can also create a binded table that uses the Data Table's dynamic values. A binded table lets you add or change data using a Data Workflow.
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.
What You'll Learn
After completing this article, you’ll know when to use a Data Table component, how to configure its settings, understand its data structure, and how to use it in an Unqork application.
About the Configuration Window
General
Setting |
Description |
---|---|
Property ID |
A Property ID is the unique field ID used by Unqork to track and link components in your module. The Property ID is how the software identifies your component. Using Property IDs lets you link components, creating logic-based configurations and API APIs (application programming interfaces) are a set of protocols and definitions developers use to build and integrate application software. APIs act as the connective tissue between products and services. calls. Property IDs must use camel case A naming convention for computer programming. Use camelCase for Property IDs, for example: newUser, lastName, & rdoButton. (stylized as camelCase) without spaces or punctuation. |
Notes |
Select this tab to display the component's Notes area. You can use notes to keep your teammates informed. The Notes editor offers a semi-WYSIWYG (What You See is What You Get) content editor. Built to look like a word processor, this editor lets you create, edit, and format your notes. Notes save when saving the component. |
Display |
Select this tab to manage your component's display settings. |
Data |
Select this tab to manage your component's data settings. |
Actions |
Select this tab to manage your component's actions settings. |
Permissions |
Select this tab to see the RBAC RBAC (Role-Based Access Control) is a method to control system access for authorized users. The role in RBAC refers to the levels of access employees have to a network. settings of the component. |
Field Tags |
Assign components one-word labels to help organize, identify, and group the components in your application. Consider an example from the API Specification Snippet: Field Tags are applied to Hidden components in the panelRequest and panelResponse Panel components. The Field Tags identify the data type of parameters included in the API APIs (application programming interfaces) are a set of protocols and definitions developers use to build and integrate application software. APIs act as the connective tissue between products and services. request and response. The API Docs Dashboard tool populates with information about each parameter’s data type, identified by the Field Tag. Field Tags act as a type of Property ID A Property ID is the unique field ID used by Unqork to track and link components in your module. group and let you group components for configuration purposes. Field Tags let you target two or more components using a simple logic component. For example, add the Field Tag tagForDecision to multiple components in your module. Open the Inputs table of a Decisions component and reference the tagForDecision Field Tag as the input of the Decisions component. The output of the Decisions component then affects all components with the tagForDecision Field Tag. Save your Field Tags by pressing Enter (Return) or adding a comma after each entry. |
Shortcuts |
Select this tab to open the list of supported keyboard shortcuts you can use in the component settings modal. Keyboard shortcuts include:
Additional keyboard shortcuts:
|
Documentation |
Select this tab to access the component documentation in Unqork's In-Product Help. |
Cancel |
Click this button to undo any unsaved configuration changes and return to the canvas. |
Save & Close |
Click this button to save all settings as configured and return to the canvas. |
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 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 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.
What You Need
For this configuration, you need:
-
1 Data Table component
-
1 Multi-Select Dropdown component
Configure the Data Table Component
First, configure your Data Table component. This Data Table component supplies the vehicle labels and values for your Multi-Select Dropdown component. Then, configure the Multi-Select Dropdown component to retrieve that data and display it.
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
Next, configure a Multi-Select Dropdown component to reference your Data Table component.
1. | Drag and drop a Multi-Select Dropdown component onto your canvas, placing it below the dtVehicles Data Table. |
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. |
Once implemented, here's how the Data Table component referenced in a Mutli-Select Dropdown component displays in Express View Express View is how your end-user views you 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 the same data table looks in the DevTools Console The DevTools Console helps you securely store, build, test, and deploy your software.:
Resources