Data Linkage

1. Introduction

1.1 Overview

When the data of one field in a form changes, the data of another field in the same form changes accordingly. This is typically used to set default values for components.

1.2 Use Case

Let’s build a data linkage between grade and class. Class table

Grade	Class
Grade 1	Class 1
Grade 1	Class 2
Grade 1	Class 3
Grade 2	Class 1
Grade 2	Class 2

When enrolling a student, we want to assign them to the corresponding class. How can we achieve this?

2. Data Linkage Configuration Items

Associated table: Select the table to associate with.

Current app: Other forms that belong to the same app as the current form. A form cannot use itself as the source for its own data linkage.
Cross-app: You can select a cross-app dataset form that has been created. For details, see Retrieve form data across apps.

Linked field settings: When the value of the current form field “Product name” equals the value of the associated table field “Product name”, the value of the current form field “Quantity” displays the value of the associated table field “Stock quantity”.

Configure data linkage.

3. Component Types That Support Data Linkage

Note: Address and associated form components can only be used as condition rules. The associated form quotes the main information fields configured in it.

Source component type	Target component type
Select	Select, single-select dropdown, single-line text, numerical
Single-select dropdown	Select, single-select dropdown, single-line text, numerical
Multiselect	Multiselect, multi-select dropdown
Multi-select dropdown	Multiselect, multi-select dropdown
Single-line text	Select, single-select dropdown, single-line text, numerical
Multi-line text	Select, single-select dropdown, single-line text, multi-line text, numerical
Numerical	Numerical
Date	Date
User	User
Address	Address
Department	Department
Image upload	Image upload
Associated form	Associated form

Before: If the target data field contained special characters, the linkage failed and the business logic could not run.
Now: Target data containing special characters such as and / can be matched correctly.

Single-select dropdown configuration view.

Target data to be associated.

5. FAQ

5.1 The Source Table Contains Data, but the Linked Data Is Not Displayed.

The data linkage returns a limited number of results, and searching within the returned results is not currently supported. If the source table contains many records that meet the conditions—especially many duplicate values—the desired result may not appear in the linkage. You can enable deduplication to reduce duplicate records in the results, which allows more meaningful linked data to be displayed.

Final result.

5.2 How to Trigger Data Linkage Automatically

Note: This method only applies to scenarios where a change in a main form component triggers data linkage on the main form alone or on the sub-table alone.

/* Bind Update time with linkage */
export function didMount() {
  const instanceData = this.utils.getFormInstanceData();
  const { flowData = {} } = instanceData;
  const { editMode, viewMode } = flowData;
  if (viewMode === false && editMode === true) {
    this.$('textField_vq5mqtb').getProps().onChange();
    this.utils.toast({
      title: 'Updated',
      type: 'success'
    })
  }
}

Getting Started

Quick Start

Form Management

Workflow Design

Report Design

Aggregate Table Design

Portal Design

Custom Pages

Integration & Automation

Cool App

App Management

Platform Management

Internationalization

YiDA Dedicated

Developer Features

1. Introduction

1.1 Overview

1.2 Use Case

2. Data Linkage Configuration Items

3. Component Types That Support Data Linkage

5. FAQ

5.1 The Source Table Contains Data, but the Linked Data Is Not Displayed.

5.2 How to Trigger Data Linkage Automatically

​1. Introduction

​1.1 Overview

​1.2 Use Case

​2. Data Linkage Configuration Items

​3. Component Types That Support Data Linkage

​4. Special-Character Compatibility Enhancement for the Single-Select Dropdown Data Linkage Conditions

​5. FAQ

​5.1 The Source Table Contains Data, but the Linked Data Is Not Displayed.

​5.2 How to Trigger Data Linkage Automatically

1. Introduction

1.1 Overview

1.2 Use Case

2. Data Linkage Configuration Items

3. Component Types That Support Data Linkage

4. Special-Character Compatibility Enhancement for the Single-Select Dropdown Data Linkage Conditions

5. FAQ

5.1 The Source Table Contains Data, but the Linked Data Is Not Displayed.

5.2 How to Trigger Data Linkage Automatically