2022.01.18 version update-new upgrade of formula experience

版本范围: all versions

This YIDA provides a new experience upgrade for formula scenarios, covering five formula scenarios and improving the efficiency of formula creation and editing for high-frequency community feedback.

In the low-code platform, formulas can easily process data in a lightweight manner.

Optimize and cover 5 common scenarios:

Scenario 1: Formula selection is more efficient

• Formula focus optimization: insert formula cursor to automatically Center and form fields to achieve overall editing

Scenario 2: Formula retrieval is smarter

Supports quick retrieval of field names, Formula names, and formula graph information.

• The name, description, and scenario description of the formula can be intelligently identified.

More user-friendly retrieval

You can search for semantic descriptions and automatically filter out all related functions.

• For example:

• Search for Chinese characters "addition" and automatically retrieve 【SUM]]
• Search for Chinese characters "today" and automatically retrieve 【TODAY] function
• Search for Chinese characters "initial letter" and automatically retrieve 【PINYINHEADCHAR] function
• Search for the Chinese character "so-and-so" and automatically guess the formula you want....👍🏻

ps: welcome to leave a message in the document [what you want公式联想词], we will choose the appropriate suggestion to enter recommend content

4 Business scenarios are fully compatible

• The search function is supported for formulas that cover scenarios such as form field formulas, form business associations, and connector formulas.

Scenario	After the search function is supported
1. Form Designer: component formula editing panel
2. Form settings: Page formula verification and Business Association rule verification
3. Process: node rule formula setting	Common process-node submission rule settings Advanced process-node submission rule formula settings
4,Integration & Automation: process settings-node submission rule settings

Scenario 3: Formula recognition errors are more timely

Formula function name: click to give instant feedback on usage instructions

Immediate feedback for syntax detection: function name, function parameter, nested function return value, and syntax parsing

Scenario 4: Add 5 functions:

For developers with certain IT experience, five new advanced functions are provided to cover complex scenarios of multi-department and multi-supervisor personnel address books:

• Three constructor functions (DeptBuilder, UserBuilder, DirectorBuilder)
• Two application functions (GetArrayItem, GetObjectField)

Complex scenarios:

Three scenarios may occur when multiple departments and supervisors are involved.

• Scenario 1: member components can select multiple people by selecting people (1 to many)
• Scenario 2: Each person may belong to multiple departments at the same time (1-to-many)
• Scenario 3: each department may correspond to one supervisor (1 to 1)

In order to better solve [Scenario 1, scenario 2, scenario 3], we provide the following functions. By cooperating with the selection of form components, we can basically solve various departments, multi-supervisor business scenarios.

Three constructor functions

Function introduction	Function parameter description	Function return value description	Function usage
UserBuilder As a member constructor, it is used to generate a list of specified userids or a list of personnel objects corresponding to a specified Member component.	Member component or specified employee ID	A member set	Instructions UserBuilder(Member component) orUserBuilder(["userId_1","userId_2"]) Example: UserBuilder(Member component) generate the personnel model object selected by the specified Member component'
DirectorBuilderAsThe supervisor constructor, which is used to generate the n-level supervisor of the current login or a specified person, level>= 1, and return the corresponding supervisor's personnel model set (Supports Multi-supervisor scenarios)	Parameter 1: an empty string represents the current logon person. Parameter 2: The level of the supervisor	A member set	Instructions DirectorBuilder("" , 1) obtain the level 1 direct supervisor collection of the current login person,DirectorBuilder("userId_123", 2) obtain the level 2 direct supervisor set of the specified userId person Example: DirectorBuilder(GetObjectField( GetArrayItem (member component, 1) , "userId_123"), 2) obtain the job numberuserId_123List of personnel objects of level 2 supervisors of employees
DeptBuilder It is used to generate a collection of departments where a specified person is located (multi-department scenarios are supported). The specified type can beThe current logon person, the person with the specified userId, or the member component in the radio mode..	You can obtain the current login Department without passing any parameters. Specified person information	A collection of departments	Instructions DeptBuilder() obtain the collection of departments of the current login person, DeptBuilder('userId') obtain the Department collection of the specified userId person,DeptBuilder(GetArrayItem (member component, serial number Index)Gets the Department collection of the specified person in the Member component,Serial number Index starts from 1 Example:DeptBuilder(GetArrayItem (member components, 1)Gets the collection of departments of the selected personnel of the specified Member component. If there are multiple departments, all departments are returned.

Two application functions

Function introduction	Function parameter description	Function return value description	Function usage
GetObjectFieldUsed to obtain the value attribute value corresponding to the specified key from the specified standard json object	(Standard Json object type, attribute ID)	Text	Example: GetObjectField(GetArrayItem (member component, 1), "label")
GetArrayItem(Standard JsonArray type, n) GetArrayItem is used to obtain the nth data unit in a specified standard JsonArray,n>= 1 , n<= array length, n = 1 interval scale the first data unit	(Standard JsonArray array type, n) n represents the number. n is a positive integer greater than 1, n = 1 generation table item 1	Json	Example: GetArrayItem(Department component, 1) obtain the first data unit in the specified array. For Department components, the corresponding Department ID is returned. Example: GetArrayItem(Member Component Array, 1) obtain the first data unit in the specified member array

Scenario 5: Department components support function defaults

With the DeptBuilder formula, you can quickly initialize the default value of the form Department component.

• DeptBuilderThree scenarios are supported:

• No parameter, representing the direct Department of the current login person.
• Or userid, which specifies the direct Department of the member id.
• Or a single member component. The member component corresponds to the direct Department where the member belongs.

Fixed known issues:

1. Improve the reliability of formula execution:

Background description:

A formula is a set of regular expressions, which are divided into writing expressions and executing expressions and obtaining calculation results.

Trigger condition:

Because some formula logic needs to use cloud computing through network transmission, in a specific weak network scenario, if some formula calculation results are not completed, submit the form, the database data may be inconsistent with business expectations.

Solution:

This time, through the upgrade of the front and back of the YIDA formula, through the introduction公式【执行锁】The ability to improve the reliability guarantee of formula settlement in extreme cases.

2. Solve the problem that the default reference of formula fields cannot be modified.

Trigger condition:

Form design State: Form component A sets the default value through the formula, if Component B references component A through the formula.

Form running state: the form of A cannot be modified twice.

Solution:

Currently, form component A can be freely modified when the running state is supported. Component A should be matched in the form.所有支持公式默认值The component.