Data Table Component

Overview
The Data Table component acts as a spreadsheet for referencing data, like an Unqork Data Collection. The Data Table component lets you manually enter or import submission data to store in columns and rows that are hidden from the end-user 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.
About the Configuration Window
To learn more about general component settings, view our General Component Settings article.
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.
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. |
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 ![]() |
2. | In the Property ID and Canvas Label Text fields, enter dtVehicles. |
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 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 ![]() ![]() |
2. | In the Property ID field, enter vehicles. |
3. | In the Label Text 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 ![]() |
7. | Click Save Component. |
8. | Save your module. |
Click Preview to explore the Multi-Select Dropdown component's functionality in Express View:
Structure of a Data Table Component's Data
The Data Table component's data stores in submission data 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 the same data table looks in the DevTools Console:
Resources