Complex table filling is divided into cell filling, table filling and dataset filling. This topic describes how to create and manage table filling.
Configuration Effect
As shown in the following figure, fields such as area, inspection photo, problem feedback, and severity are filled in. 
Fill in the form
The filling table is a table that can be extended horizontally. You can quickly set filling controls for all cells in a column. The following uses the filling form in the workshop inspection report as an example.
Create a form
Procedure
Entry 1: Select the cells that you want to insert into a table, click Fill in Data in the upper-right corner of the toolbar, and then select Fill in Table. In the dialog box that appears on the right side, set the parameters.
Entry 2: Select the cells that you want to insert into a form, click Insert in the upper-left corner of the menu bar, and then select Fill in Report. In the dialog box that appears on the right side, set the parameters.
After the creation, automatically open the filling form configuration panel.
Global configuration of a fill-in table
Fill in fields
Click Add Field to add a field to the right of the filling table.
Change the control type. The control type displayed under Table Form is added to the cell control. For example, Function is added.
Click
icon to go to the Field Configuration page of the field. Click 
icon to delete the field. 
Table style
The toolbar displays Always Show and Hover Show. You can click Add Row, Reset, Delete Row, and Check Value in the toolbar.
Configuration side entry
Preview
- Note
You can add lines and delete lines only after you create a submission area for a form. You can add rows when the write mode is Add. You can delete rows when the write mode is Delete. For more information, see Create a form and submit a report.
If you select Show Wireframe for Input Box, a wireframe is displayed in the cell in the Filling state.
After you select Preview Table Wireframe, you can customize the Color and Line Type of the table wireframe.
Fill in form field configuration
In the Global Settings panel, click Edit
icon for a specific field. You can also switch between Global and Field tabs to go to the Field Settings panel. 
In the left-side navigation pane, click Add, Delete, or Drag.
Modify Field Name and Control Type as required.
Configure parameters for fields. For the same widget, the configurations in the filling table are basically the same as those in the cell. For more information, see Fill in the widget.
Fill and write configuration
After you configure the filling control for a form, you must create a submission area for the form. In this area, configure the basic information, writing method, physical table, and data verification parameters.
Go to the event center page
Menu bar data filling under the function, in addition to filling in controls and filling in forms, it also includes create filling submission area and fill area management.
Create and submit a form
In the upper-right corner of the page that appears, click Fill in data form and select Create Submission Area.
Click Create Submission Area to go to the Basic Information, Write Settings, Data Verification, and Function Settings page.
Basic Settings
Area Title: Set the title of the data form area.
Circle Selection Range: Click
to adjust the range of data filling. 
Write Settings
Commit Type and Write Mode
First, there are three types of filled cells: normal cells, filled tables, and dataset tables. The writing method is divided into two types according to the selected filled cell type:
Excluding Dataset Tables: Plain Normal Cells, Plain Filing Tables, and Filing Tables + Normal Cells. The writing method can only be added, but cannot be modified or deleted, and does not require a primary key.
Dataset tables include: Dataset tables, Dataset tables, and Normal cells. You can select Intelligent Submission or Submission after deletion.
Smart Submit: adds, edits, and deletes data. When filling and submitting, the background will automatically judge the add, edit and delete operations.
If you select Intelligent Commit, you can select Add, Edit, or Delete.
The Delete and Submit function clears all data in the row based on the primary key field that is specified in the Receipt parameter. If your inbound configuration table does not contain all fields, the field values that are not bound to the fill control are also cleared. Exercise caution when you perform this operation.
Write Physical Table Settings
Select Data Source and Physical Table
Select Data Source: You can select only a data source that has both the use and write permissions of the database account.
Select Existing Table or Create Table.
Add, Delete, and Copy: You can configure multiple write configurations to write data to multiple tables at the same time.
Configure field mapping: After you select an existing table or create a table, you can configure the mapping between the fields of the form and the bottom table.
Select Existing Table.
The name of the table field that you want to write to the control. Description and Type of the table field name are automatically matched. You can also specify whether the field is the primary key.
You can add and delete field mapping lines
Select Create Table.
You can create a physical table and specify Table Name, Table Field Name, Field Description, Field Type, and Primary Key.
You can add and delete field mapping lines
Write verification
You can add data verification to ensure the quality of data entry.
Fill in the logical expression of the verification rule. You can use the table function and reference the filled field (format "[filled field name]"), such as [order amount] - [cost] > 0, and fill in the error copy.
Click Add to add a verification rule and click
to delete the verification rule. 
Fill in region management
In the upper-right corner of the workbook, click Filling Area Management. In the dialog box that appears, you can view the filling controls configured for the current sheet, including standard cells, filling tables, and dataset tables. You can click a specific control to locate the control. 