Business Association rules

Q: How to sort and execute business association rules and integration automation?

Currently, business association rules and integration automation are independent execution logic, andThey are executed in their own execution order, that is, the execution order is uncontrollable..

If mixed use, the same target form may be executed by the two task scheduling systems in the expected order, resulting in abnormal update results of business results, especially for complex business processing such as purchase, sale and deposit, etc.

Priority recommend be given to using YIDA integration automation for inter-business synchronization.

Q: How to sort and execute multiple Business Association rules on an integrated automation node?

Business Association rules currently support writing multiple rules, but due to product restrictions,The execution order cannot be selected between rules..

To solve the problem of sorting execution, you can use data nodes such as adding, updating, and deleting integrated automation instead. These nodes support scheduling order, you can also view execution records in run logs.

For more information, see the following screenshot:

业务关联规则常见问题

Q: What is the limit on the amount of data processed by the business association rule formula?

Currently, YIDA business rule functions support the following usage:

Core function	Function	Usage limit
INSERT	The formula is mainly used to insert data from the current input table into the target table.	You can use batch import to trigger business association rules to insert the target table into the primary table. There is no limit on the number of fields (we recommend that you import no more than 1,000 pieces of data, and the import of more than data is slow), batch import has a file size limit (20MB) Insert a subform into the main table Experience Edition: up to 50 Standard edition and VIP version: Up to 500
UPDATE	The formula is used to update qualified data in the target table.	The target table is the primary table Field. You can only update up to 100 items at a time. If the value exceeds the value, an error will be reported, resulting in submission failure. The target table is subform data. Experience Edition: up to 50 details can be updated Standard edition and VIP version: Up to 500 updates are supported (the default value is 50. You need to set the number of subforms to 500 on the form editing page)
UPSERT	Formulas are used to insert or update data into the target form.	The target table is the main form data, and you can only update up to 100 pieces at a time. If it exceeds the target table, an error will be reported, resulting in submission failure. The target table is subform data. Experience Edition: insert up to 50 pieces of form data in a single update, Standard edition and VIP version: a maximum of 500 entries can be inserted in a single update (the default is 50 entries, and the maximum number of entries needs to be set on the form editing page is 500 entries). If the number exceeds the value, an error message "submission failed" will also be reported 」
DELETE	The formula is used to delete data from the target table.	The target table is the main form data, and a maximum of 100 entries can be deleted at a time. The target table is subform data. Standard edition and VIP version: you can delete up to 500 items at a time.

常见问题

Q: How can subforms be updated?

Scenario: data synchronization between subforms in the main table and subforms in another main table

Example:

Main condition:

EQ (target Table. Primary table field, current table. Primary table Field), locate a piece of data of the sub-table data to be updated in the target table

Sub-conditions:EQ (target Table. Subtable. Subtable field, current table. Subtable. Subtable field), then you need to locate the subdata to be updated in the subtable of the target table

业务关联规则常用场景