Data Table Component

Estimated Reading Time:  9 minutes

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 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.

TIP  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

A static image displaying the Data Table configuration window.Configuration tabs include Display, Data, and Actions.

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 Notes icon

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 Icon Display

Select this tab to manage your component's display settings.

Data Icon Data

Select this tab to manage your component's data settings.

Actions Icon Actions

Select this tab to manage your component's actions settings.

Permissions Icon 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. (role-based access control) settings of the component.

Field Tag Icon 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 Panels. 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 Icon Shortcuts

Select this tab to open the list of supported keyboard shortcuts you can use in the component settings modal. Keyboard shortcuts include:

  • Cmd + S (Mac) / Ctrl + S (PC): Save and close the component settings modal.

  • Cmd + G (Mac) / Ctrl + G (PC): Opens a search window to find specific fields and settings in the component settings modal.

  • Tab: Tab to the next field or setting in the component settings modal. This keyboard shortcut tabs left to right and top to bottom.

  • Shift + Tab: Tab to the previous field or setting in the component settings modal. The keyboard shortcut tabs from right to left and bottom to top.

  • Enter (Return): When tabbing to a Tooltip Icon (tooltip), press Enter (Return) to display the field or setting tooltip. Press Enter (Return) again to hide the tooltip.

Additional keyboard shortcuts:

  • Drop-down menus: When you Tab to a settings drop-down, use the keyboard's Up-Arrow Icon (up)/ Down-Arrow icon (down) arrows to make a selection. Then, press Enter (Return) to confirm the selection.

Documentation IconDocumentation

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

A static image displaying the Data Table component's Display setting.
(click image to expand)

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

A static image dispalying the Data Table component's Data Settings
(click image to expand text)

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:

  • Add Column: Adds an additional empty column to the Data Table.

  • Remove Column: Removes the column from the Data Table. Data in removed columns is not lost unless the component is saved.

NOTE  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 Toggle On Icon (ON), Unqork stores values entered into the field to the database (server-side submission). This occurs in three scenarios:

  • Navigating between Panels in a Navigation component. On navigation between pages (Panels), the component’s value saves to the database.

  • Triggering a module save event using a Button component with an Action Type of Save.

  • Navigating between screens of a workflow. On navigation between screens, the component’s value saves to the database.

NOTE  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 Toggle Off icon (OFF) when you don’t want to store the values from this field in the database.

NOTE  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.

TIP  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 Toggle On Icon (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 Toggle Off icon (OFF).

Actions Panel

A static image displaying the Data Table component's Actions settings.
(click image to expand)

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 Toggle On Icon (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 Toggle Off icon (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:

Configure the Data Table Component

First, configure your Data Table component. This Data Table supplies the vehicle labels and values for your Multi-Select Dropdown. Then, configure the Multi-Select Dropdown to pull 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 Dropdown Component Icon Data Table component onto your canvas.
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 dtVehicles.
3. In the Canvas Label Text field, enter dtVehicles.
4. 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

NOTE  As a best practice, enter column titles in lowercase, with no breaks or special characters.

A static image displaying the Data Table component's configuration window. The data table list displays several types of vehicles.

5. Click Save & Close.

Configure the Multi-Select Dropdown Component

Next, add a Multi-Select Dropdown component. Configure this component to reference the Data Table you just added.

1. Drag and drop a Text Field Component Icon Multi-Select Dropdown component onto your canvas, placing it below the dtVehicles Dropdown Component Icon 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 Dropdown Component Icon Data Table component.

A static image displaying the Multi-Select Dropdown component's Data configuration settings. The Data Source Type is set to Data Reference Key and the Data Reference Key dropdown is set to dtVehicles.

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. After configuring a module, click Preview in the Module Editor 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 Dropdown Component Icon 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:

A static image displaying a Data Table componant with three columns and six rows of data.
(click image to expand)

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.:

A static image displaying a Data Table in the DevTools Console view.
(click image to expand)

Resources