2023.10.30 update-basic product power upgrade

Capability release

1. Add:The default value of the subform supports data linkage.
2. Add:You can set sub-table filter conditions and add data in batches.
3. NEW: The associated form data source supports sub-tables and sub-tables.
4. NEW: automatically update process data
5. NEW: upgrade the overall import/export function

1. Data import link optimization and Excel template update
2. Import components for more high-frequency scenarios
3. Supports multiple export data display methods and batch viewing of images and files.
4. Excel import data supports new/updated modes.

6. Optimization: some features equity adjustments

1. Added support for standard edition and VIP version
2. Lightweight edition and standard edition, the number of automated streams for single application integration increased from 5 to 10
3. The process parallel node supports free edition, Standard Edition, light edition, Professional Edition, and VIP version.
4. Custom components support Professional Edition.

The following is a detailed update description

---

1 The default value of the subform supports data linkage.

Supported versions: all versions YIDA

Typical use scenarios are as follows:

• ProductPurchasing and warehousingIn this scenario, you can use a subform to record the details of purchased products. When purchasing and warehousing, you can use data linkage to automatically link the product details of the corresponding subform after selecting the product name, enter "this public int count" to submit;
• In the sales delivery scenario, use a subform to record the sales order details, including the quantity shipped and the quantity not shipped. When the next order is shipped, the shipping details linkage will link out the current shipped quantity and unshipped quantity information of the order.

Function entry: Common form/flow table single page designer-subform component-default value-data linkage

Before

After

Not supported. The Target table needs to be linked to the sub-table of the associated table. You need to database synchronization update the sub-table to another intermediate table.

Subforms support data linkage as a whole, quickly set data linkage for the entire subform-default value, and set linkage display values for each subfield; When the linkage condition is met, you can automatically fill in multiple rows of subform data. Up to 5 subforms can be configured in a page to trigger overall data linkage at the same time. The range of component types supported by the overall data linkage of subforms is as follows: Filter conditions for data linkage: Main form components: single-line text, multi-line text, numeric value, single choice, check, date, member, drop-down single choice, drop-down check, department, address, and subform. (Qualified name field) detail field, serial number, Enterprise component (number, name), and associated form. Main information fields;Subform. (name field that meets the criteria) detail field is not supported. Value linkage: single-line text, multi-line text, numeric value, single choice, drop-down single choice, date, member, department, image upload, attachment Upload, score When the condition rule is met, subform fields cannot be selected as filter conditions in the condition.

Example scenario:[In the purchase and warehousing scenario, select a purchase order, and the product list details are linked by default]]

2You can set sub-table filter conditions and add data in batches.

Supported versions: all versions YIDA

Function entry: Common form/flow table single page designer-associate form components-data filling

Before

After

Mixed configuration of primary and sub-table filling rules with limited capability When subform fields are set to fill rules, the subtable data filtering conditions cannot be set synchronously. When the associated form is in the subform, multiple rows of data cannot be added to the subform in batches. When data is added to the associated form, the list display effect lacks general functions such as sorting and global search, and is not aligned with the Data Management page function. The operation mind is inconsistent.

[When multiple selection mode is not enabled] The primary table fill rule or sub-table fill rule (up to 10) can be set separately. The configuration is clearer and filter conditions can be set in the sub-form fill rule. [Associated form subtable fields] cannot be filled into [current form Main table fields]] If [set filter conditions], only sub-table data that meets the filter conditions is filled. If not set, all sub-table data is filled by default. When the data source of the associated form is a subtable,The primary table fill rule cannot be configured. The subtable fill rule is the current subform field-fill to-current form field (the primary table field + subform indicates a fine field) The associated form is in the subform and supports adding multiple pieces of data to the subform in batches (non-Multi-selection mode),Multiple entries are added in batches under the current operation row data. After submission, blank rows are filtered by default and row-level default data linkage, padding, formula and other calculations (the maximum number of batch executions is 10, only one-level dependencies are supported) Example scenario: In a purchase order, quickly add purchased products in batches and query product details together. When data is added to the associated form, the list display effect is unified as the data management page effect of the currently associated form. After the Association is established for the first time, users can process thousands of people and thousands of faces based on the list they see.

Example scenario:[Sales outbound-select sales orders, all outbound, batch product details of "outbound quantity> 15", quick outbound]]

3The associated form data source supports sub-tables and sub-tables.

Supported versions: all versions YIDA

Function entry: Common form/flow table single page designer-associate form component-associate attribute-associate form data source

Before	After
Not supported. If you want to associate the sub-indication details of the target, you need to synchronize the sub-table data to another intermediate table by associating the primary table.	The data source of the associated form can directly select a subform under a main form and configure the fill rule according to the current subtable data source. (Select a subtable data source for the associated form) (Subtable fill rule) After the associated form is a subtable data source and multiple selections are enabled in the subform, multiple rows of data in the subform are not supported. Special instructions: When multiple primary tables are associated with the same data source in the canvas, such as sales orders 」, select the source of information to be associated with the query from the filter criteria select Get data range of the primary table drop-down list. If there are no associated fields of the primary table in the canvas and only Associated fields of the subform, please confirm "select Get data range of the primary table" first 」 Quick View sub-display details. By default, the details page of the primary table instance where the current sub-table is located is displayed.

Example scenario:【Sales outbound (Associated order details outbound on demand), select a sales order, and the salesperson can select specific product details for outbound]]

4Automatically update process data

Before	After
Not supported. The running process needs to be updated.	Direct update supports selecting and processing flow chart of data. Obtaining process data allows you to obtain process data in different states.

Note:

1. When an automated update occurs, the process node is in the edit state, and the content of the automated update is overwritten, resulting in an update failure.
2. When the process is located on a branch node, automatic updates occur simultaneously. In this case, the branch judgment maintains the data before the update.

5 Data Management page import link optimization and Excel template update

Supported versions: all versions YIDA

Function Points	Before	After
[Before import] import dynamic line optimization	Importing Excel is divided into five steps: complicated steps and low operation efficiency Select Excel table Data preview Import Settings Submitter settings Import data	Import Excel in 5 Steps to 3 steps: Upload an Excel table Download import templates to display on demand in form or list order Examples of optimized import templates Determine the import settings (data preview, import component configuration, and submitter settings) View imported data results (error reports are supported)
[Before import] excel template optimization	"Field import Format Specification", vertical display, not convenient for users to fill in There is no option for importing content with option values in the template.	Description and examples of rich import templates Import template "single choice, drop-down radio" option value with options
[After Import] quickly view error reports and correct data for secondary import	After an error occurs in the import, the details of the error data cannot be clearly viewed.	Before the import task is executed, if a system exception fails, check the cause of the error directly in the status bar, such as system exception. After the import task is completed, the cause of the row-level error appears. Click view the cause of the failure. You can also download the error report and download the local Excel to clearly display the current data and cause of the error, after adjusting as needed, you can quickly import the file for the second time.

6 import components adapted to more high-frequency scenarios

Supported versions: all versions YIDA

Function entry: Data management page List Import

Component Type	Before	After
[Add] address	Import not supported	The "add" address component supports importing relevant data at the level of "detailed address of provincial and urban streets" in five different types as shown in the following figure. Import verification based on different page designer configurations
[Optimization] score	Import not supported The export effect is not available. For example, if the default export field name is numeric, the display value is invalid.	Export this fieldBy default, the name of the scoring component or the name of the custom component field is displayed.Export supports displaying specific scores by list display effect. At the same timeYou can import half-points or half-points. When you import a score value (half-points is enabled), you can import half-points of half-points. If half-points are not enabled, you cannot import half-points of data.
[Optimization] member selection/multiple selection	You can import only in the userid format, but not names. For example: Xiao Wang (yida888) Xiao Wang [manager888]	[Import] enter the member name or userId or employee ID that exists in the system address book (the employee ID needs to be queried in the OA background). If the same name exists, enter the data with the name [userId]. If multiple selection is enabled, separate members in English. The following four import formats are supported: (1) Name [userId] or name [userId], name [userId], name [userId], name [userId], name [userId] (2) name or name, name (3) [userId] or [userId],[userId],[userId],[userId] (4) name (work number) or name (work number), name (work number), name (work number) Export] When the selected member has job number information in the OA background, the job number is displayed first.That is, the export format is: name (work number) When the OA background does not maintain the employee ID of the member, the employee ID information provided by the system is displayed by default., that is, the export format is: name [userId]
[Optimization] Department selection/multiple selection	Only full-path import of departments is supported, such: Nanjing Branch-R & D center-front-end department, Shanghai Branch-product experience-Product Department	Enter the department name that exists in the system address book. If the same name exists, complete the full path information of the department.. If multiple selection mode is enabled,Different departments need to be separated by English (half angle) For example:Product Department orProduct Department, sales department, Personnel Department
[Optimization] serial number	Import not supported	The serial number component can be imported. Enter the serial number information (including text, uppercase and lowercase letters, date, etc.). For more information, see text format. If the serial number is unique in the current form design scenario, enter Excel correctly. Note: If the Excel serial number field value is empty, after the import is performed, the platform will automatically generate the serial number of the document according to the current form serial number rule. If the serial number is imported into the Excel table, the custom content will prevail.
[Optimization] picture	Import is only supported by Image public address	1. Import supports two methods: Enter the public access address link of the image In the Excel cell, select insert-image to embed the image source file for import. Note: The office suite can embed images and perform import operations. wps does not support After embedding the image, be sure to adjust the width and height of the current cell and place the image in the cell. The import operation is not supported after multiple images are embedded in a cell.

7 support multiple export data display methods and batch view images and files

Supported versions: all versions YIDA

Function entry: Data management page List export and batch download files

Before

After

The exported data cannot be exported on demand in the default order in which the form or list is displayed. The exported Image/Attachment information can only be displayed at the link address in Excel. Open the webpage separately to view it, which is inefficient and unfriendly. Download files in batches. Named field file names are not supported.

Click "export" Excel data in the list. You can select the default display method of exported data, which is "subject to the field order on the current data management page" or "subject to the form field order 」 If the field to be exported currently has an image or attachment component, you can choose whether to export the image/Attachment field as a file to facilitate users to quickly view data and file information in batches. If you select,When exporting, the image/Attachment will be downloaded as a file. You need to decompress it before you can directly click the Attachment/Image from excel. Otherwise, it cannot be opened.(Note: If the number of exported attachments exceeds 20g, the export speed may be slow or the export resources may be incomplete. In this case, we recommend that you export in batches after narrowing the export data range) If it is not checked, the image/Attachment will be exported as a link address, which can be directly accessed and opened through the link. Effect: export Image/Attachment fields as files 」 Download files in batches. You can set the naming method for exporting images/attachments.

8 Excel import data supports new/updated modes

Supported versions: all versions of YIDA. Common form import supports synchronous addition or update. Flow chart does not support

Function entry: Data management page List Import

Before

After

When you click import in the list, you can only import data and do not update data. When some data in an Excel file needs to be directly updated (modified in batches), some data needs to be quickly added (imported in batches) and cannot be completed at one time.

The procedure is as follows: Import the Excel file and confirm the data to be added or changed according to the rules. Note: In Excel, pleaseBe sureIncomingComplete Excel column data(You can export the list data and modify the data that needs to be changed in Excel. Please keep the data that does not need to be modified.) you can add/update some data according to the following rules. The system willExcel performs full overwrite updates. The ID of the primary table instance.: This column is a system Field, optional. To update existing data during import, enter the corresponding form instance data ID in the current column (you can select this field to obtain it during export). When this field is empty, only new data is added. When this field enters the correct value, only overwrite updates are performed (some data currently updated in batches do not trigger rules or logical operations) The ID of the child table instance.: This column is a system Field, optional. Sub-table data cannot be added separately through import. If you want to update separately, you can go to the page to perform operations. Or fill in the correct sub-table data instance IDs to be updated and the associated primary table data instance IDs. After the file is imported, you can refresh the list and click a piece of data to view the details-change record and confirm the change information.

9 equity optimization

1. The process recycling operation supports a lightweight version and a professional version.

https://docs.aliwork.com/docs/yida_support/wtwabe/oihk8g/qgaxvq/ef8e88/pvi85yxaehw7u1b3

2. The number of automated streams for single application integration in the light edition increased from 5 to 10

集成&自动化 | 钉钉宜搭·帮助中心

对逻辑编排功能进行了整体升级，同时接入了钉钉连接器，钉钉官方应用、钉钉生态内应用、企业自有系统可轻量化的接入宜搭，使得宜搭应用天然具有互联互通的能力。

https://docs.aliwork.com/docs/yida_support/wtwabe/zevvr1

3. The process parallel node supports free edition, light edition, and Professional Edition.

https://docs.aliwork.com/docs/yida_support/wtwabe/oihk8g/qgaxvq/trbqg6/row1axsz4s0ix2vl#U3Urh

4. Custom components support Professional Edition.

https://docs.aliwork.com/docs/yida_support/wtwabe/oupunp/gdi5p8/sg47d6