Subform Assignment Rules

To update or add records in the target form, you should follow subform assignment rules when using subfields from the data source to assign values to target fields/subfields.

In this article, we will introduce the subform assignment rules. Form 1 acts as the triggering form (the data source), and Form 2 acts as the target form.

When Adding Records to Target Form

Cannot Assign Values to Fields/SubFields in One SubForm Using SubFields From Several SubForms

When you use subfields from the data source to assign values to target form's fields, if the data source form includes more than one subform, you can use subfields in one of them for the assignment.

When you use subfields from the data source to assign values to target form's subfields, if the data source form includes more than one subform, a target subform accepts values from the same source subform.

Cannot Assign Values to Fields and SubFields Simultaneously Using SubFields

When the target form includes both fields and subfields, if one of the target fields is set to accept the value of a source subfield, the data source's subfields cannot be used in value assignment for all the target subfields.

Similarly, if one of the target subfields is set to accept the value of a source subfield, the data source's subfields cannot be used in value assignment for all the target fields

When Updating Records in Target Form

Support Limited to Updating Fields in the Same Subform

When the target form contains multiple subforms, a record updating node supports updating record in at most one subform. Otherwise, when adding fields for the second subform, the previous settings for the subform values will be cleared, as shown in the figure below:

Configuration Conflict between Fields and SubFields

When updating both the fields and subfields of the target form at the same time, a conflict may occur in the following scenario between the fields and subfields.

Fields and subfields cannot use Subform Fields from the Data Source for assignment at the same time:

Assigning values to the Target Form Fields via Subform Fields from the Data Source will subsequently prevent updating to any subfields:

When updating the fields of multiple records and using Fields from a Multivalue Data Source for assignment, you cannot upgrade any subfields.

Assigning by Multivalue Fields

Assignment Rules

When using Update Record and multi-valued fields for assignment, make sure that all multi-valued fields used in the updating assignment settings for all fields or the same subform fields of multiple pieces of data share the same data source.

Similarly, when using Update or Add Records, make sure that the assignment of added/updated records to all fields or the same subform fields of multiple data, as well as all multivalue fields used in the matching relationship/upgrading condition settings have the same source.

Explicit Explanation

This section explains the assignment rules using Update or Add Records as an example. The details are as follows:

Upgrading Fields in Multivalue Data Sources

For example, after upgrading and assigning a value to a field via Subform Field of a Single-valued Data Source, if you want to upgrade/add a value and fields in Conditions, you can only use subform field of a single-valued data source or other single-valued fields to make the assignments.

Same way, after upgrding and assigning a value to a field via Field of Multivalued Data Source, you can only use the field of the same multivalued data source to make assignments.

Upgrading SubFields in Single-Valued Data Sources

For example, after upgrading and assigning a value to a field via Fields of a Multivalued Data Source, if you want to upgrade/add a value and subfields of subforms in Conditions, you can only use fields of a multivalued data source or other single-valued fields to make assignments.

Same way, after upgrding and assigning a value to a field via SubForm Field of a Single-Valued Data Source, you can only use the subform field of the same single-valued data source to make assignments.

Error Report

Error Report Content	Description
This setting will conflict with some of the fields already set up	When setting Update Record or Add Record, if a multi-valued field from different sources is used, which conflicts with the assignment rules, then a tooltip will report an error. For example, after upgrading and adding a value to Field a via SubForm a.SubField a, then assigning a value to Field b via SubForm b.SubField a will cause a conflict.
Conflicts between upgraded and added assignments	When setting up the Update/Add Record and Conditions, if the multi-valued fields from the same source are used, changing to multi-valued fields from other sources to update the assignment, which violates the assignment rules, will trigger a tooltip to report error. For example, after assining/matching/updating value to Field a via Query Records 1-Field 1, then updating assignment to Field a via Fields in Query Records 2.