Multi-Condition Data Linkage
Introduction
Feature(s)
When the linkage of the data needs to be controlled by multiple conditions, you need to add multiple linkage conditions and set the relationship of these conditions as all of, therefore only the data that meets all the conditions will be displayed.
Note:
You can add multiple linkage conditions. The logical relationship between multiple linkage conditions can be any of or all of.
Application Scenario(s)
- In the case of course registration, you can retrieve the course fee through data linkage with two filter conditions, the class time and the course name.
- In the case of score management, you can retrieve a student's score based on the grade, class, and name.
Preview
When registering students' scores, you can retrieve students' names through the data linkage with two filter conditions, the grade, and the class.
Setting Procedure
Designing Forms
Create a Student Information form, and add the following fields:
Field Name | Field Type | Field Properties |
Grade | Single Select | Set two options, Grade 1 and Grade 2. |
Class | Single Select | Set two options, Class A and Class B. |
Name | Single Line | / |
Gender | Single Select | Set two options, Male and Female. |
Go to Manage Data and enter the data.
Create a Student Scores form, and add the following fields:
Field Name | Field Type | Field Properties |
Grade | Single Select | Set two options, Grade 1 and Grade 2. |
Class | Single Select | Set two options, Class A and Class B. |
Name | Single Select | / |
Math | Number | / |
Biology | Number | / |
Geography | Number | / |
Total Scores | Number | Set Initial Value to Formula, and add the following formula: SUM(Math, Biology, Geography) |
Setting Multi-Condition Data Linkage
Select the Name field, go to Field Properties > Option. Set Option to Data Linkage, and click Data Linkage Settings.
- Make the following data linkage settings:
- Linked Form: Select Student Information from the drop-down list.
- Condition: Grade (Student Information, the linked form) equals Grade (Student Scores, the current form).
- Trigger the linkage: Name (Student Scores, the current form) shows as Name (Student Information, the linked form).
- After the settings, click OK.
Note(s)
Settings for Multi-Condition Data Linkage
For multi-condition data linkage, you need to add multiple linkage conditions and set the relationship of these conditions as all of, therefore only the data that meets all the conditions will be displayed. The data linkage result shown in each field is retrieved through the filter conditions, therefore, the result does not depend on the data linkage settings of the upper-level field.
Quickly Adding Conditions
If the system recognizes that the linkage conditions you are setting follow the same logic of a multi-level linkage you have set in another field, the system will send you a message to quickly add the remaining conditions.
In the following example, you first retrieve data in the Class field through the Grade field, then you retrieve the Name field through the Class field, the system will recommend you add another condition to link the Grade field.
Note:
This is only available when the setting method is the same as a multi-level data linkage condition you have already set.