Skip to main content

Record ID (rowid)


What is the record ID?

Record ID: It is a string of 36 bits of text, such as b920bfa7-c3ca-4400-82a4-703cb482810a. It is an absolutely unique field value in the worksheet and is not repeated. Generally, it is not useful to the user, so it is not displayed in the record. Record ID is automatically generated after the record is created and saved, and will not be changed, even if the record is deleted. The ID will not be occupied by the new record added later, so this field value is absolutely unique, often used for filtering in workflow, API and importing data from Excel.

1. How to display row ID in the worksheet?

In the [Display Columns] of the grid view, enable [Row ID].

The record ID cannot be enabled in other views.

2. Filtering in Workflow

For example, if a customer is associated with more than one order record, you can query which orders are associated with the customer in the Order worksheet through the customer's record ID.

The query condition is that the customer (associated field) in the Order worksheet equals to the customer's record ID.

3. Link to landing page for record details

Each record can be opened through a link to the landing page. This link can be assembled and spliced through the workflow, and then sent to other groups in DingTalk or a WeChat. If someone clicks on the link, it will verify the login status and operating permissions, which has the same effect as if it was opened through a worksheet.

Get Link Template

The fields displayed and permissions may be different for records opened in different views, so you need to enter the target view first, open a record in a new page, and then copy the link in the address bar.

The link is formatted as follows:

The link consists of the Application ID, Worksheet ID, View ID, and Record ID. The content after row/ is the Record ID, so all you need to do is to keep all other contents unchanged and replace the record ID to generate a new link to the landing page for another record.

Example: Take the node [Send Station Notice] as an example. Paste row/ and the preceding contents into the text box, and then select the record ID field.

Effect:


Have questions about this article? Send us feedback