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
Platforms
Entry 1: Select the cells that you want to insert into a table, click Fill Data Form in the upper-right corner of the toolbar, and then select Fill Form. 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 creating, automatically open the filling and filing 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.
Modify the control type. The control type displayed under Table Form is added to the cell control.
Click
icon to go to the Field Configuration page of the field. Click 
icon to delete the field. 
Table Style
The toolbar display is divided into always show, hover show, the filling person can do it on the toolbar. Add Row, Reset(Clear all data), delete Row, check value operation.
Configuration side entry
effect display
- 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 an application.
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.
Operation
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 and select Create Submission Area.
Click Create Submission Area to go to the Basic Information, Write Settings, Data Verification, and Function Settings page.
Basic Information
Area Title: Set the title of the data form area.
Circle Selection Range: Click
to adjust the range of data filling. 
Write Settings
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:
Dataset tables include a dataset table and a dataset table + normal cells. You can set the Write Method parameter to Add, Edit, or Delete.
Dataset tables are not included: plain normal cells, plain filling tables, and filling tables + normal cells. The writing method can only be added but cannot be modified or deleted, and the primary key is not required.
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 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. 