Add Rows in Table by Import

Feature Description

Open the record import page, users can import data into the system by uploading Excel files, and the imported data will be added to the tables of Table View, form's Related List, Child Object, and Lookup List fields

Parameter Settings

Configuration Item	Description
Data Table	The data table type of the record
Import Fields	Set the fields allowed to be selected during import
Field Default Value	If a default value is set and the field in the imported data has no value, the default value will be used as the final imported data value

Example

This execution action can only be performed on the creation page of table-type fields (child objects, related lists, lookup lists)

In the table-type field of the creation page, if we need to import data into the table, we can implement it by adding an import button with an execution action of Add Rows in Table by Import. For example, in the work task module shown in the figure below, we want to click the import button in the subtasks when creating a new record, and import data into the subtasks by uploading a file.

To configure the above button, you need to add a button in the creation page toolbar of the table-type field. The execution action is Add Rows in Table by Import. Select the data table where the field is located for the Data Table of the configuration item, which is "Work Task" in this case.

In the Import Fields of the configuration item, you can set the fields that support import when importing data. In this case, task name, start time, completion time, task leader, and task description are selected. The Field Default Value of the configuration item can set the default value for the imported data. The default value of the field will overwrite the imported data. In this case, the default value of the task status is set to "Pending" (wait), as shown in the figure below.