Create Your First Table

​

Creating Tables

---

​

Adding Table Fields

To add fields to a Table, follow this step-by-step guide:

---

​

Table Field Types

The following field types are supported:

• Text
• Long Text with rich-text
• Number
• Single-select
• Multi-select
• Checkbox
• Date & Time
• User
• Risk management
• Button
• Reference
• Lists
• File
• Vendor

​

Table Field Types with Unique Values

This feature ensures that no duplicate values are allowed in a particular column within the table. The Text, Numbers, Users, and Time field types only offer the option to enable unique values option within a column.

​

Enforcing Unique Values in a Table Field

The Unique Values feature ensures that each entry in a specific column is distinct, preventing duplicate values. This can be enabled for the following field types:

• Text
• Numbers
• Users
• Time

When adding a table field, you have the option to activate the unique values feature by choosing the advanced option and checking the box next to unique values option. After that, simply click on create field.

---

​

Table Field Settings

Field settings let you manage individual columns in a table, including editing field details, pinning columns, copying SQL column names, and deleting fields. To access these settings, hover over the relevant field (column) and click the menu.

• Edit: Modify the field’s settings, such as its display name or other configurable properties.
• Pin: Pin the column to keep it visible while navigating horizontally across the table.
• Copy SQL Column Name: Copy the field’s SQL column name for use in queries or configurations that reference the field by its SQL name.
• Delete: Remove the field (column) from the table.

---

​

Table and Fields - Display Name vs. SQL Name

Tables and fields in Blink have two names: a Display Name and an SQL Name (internal name). The Display Name is the human-readable label shown in the UI, while the SQL Name is the identifier used by workflows, API requests, and SQL queries. What Happens When You Rename a Table or Column? Renaming the display name changes only the label shown in the UI. The SQL name remains unchanged to preserve existing references and prevent workflows and API calls from breaki By default, renaming a table or field changes only its Display Name. Its SQL Name remains unchanged to preserve existing references and prevent workflows and API calls from breaking. For example, when the table field Response was renamed to Action, its names became:

• Display Name: Actions
• SQL Name: response

The UI displays Actions, while API requests and other system operations that use the SQL name continue to reference response.

​

Changing the SQL Name

To change a field’s SQL Name, click the three-dot menu next to the field, select Edit, then select Change SQL name and enter the new SQL Name.

​

Retrieving Table ID or Field ID

---

​

Table Settings

Managing tables and their records helps you keep your data accurate and organized. You can edit individual records, delete records you no longer need, and manage table settings to update table information, copy table details, or remove data. Hover over the relevant name of the table, click on the icon to access the settings Edit: Edit the table name or description. Copy Table Schema: Copy the table’s schema, including its column definitions and structure. Copy Table ID: Copy the table’s unique identifier for use in configurations or other areas of the platform. Clear All Rows: Remove all records from the table while keeping the table and its schema intact. Delete Rows: Remove rows from the table according to the available deletion options

​

Adding Additional Tables

To add and create additional tables

1. Click the downward-facing arrow next to the existing tables.
2. Select Add Table.
3. Enter the necessary details and click Create Table.

The new table will be added to the Tables list in the left-hand pane.

---

​

Table Record Settings

To add more records to a Table, click the New Record button located at the top-right corner. Fill in the required data for the new record and click the “Add” button To edit or delete any values in a column, simply double-click on the value in the column you want to modify or delete. Make the necessary changes and then click outside the cell to automatically save your changes

---

​

Interactive Guide - Tables

You can also refer to the following tutorial guides for a more in-depth understanding of how to create a table, add a new table record and add table fields.

​

Related Articles