Fill Control

The filling control is the most basic component of complex table filling. This topic describes how to configure the filling control, such as text, value, drop-down, date and time, image, tree drop-down, and function.

The developer role configures the filling control in the workbook. The filling control types include Text, Number, Date, Drop-Down, Image, and Function, which determines the value types and filling methods that can be filled in the cell. The Basic Controls and Advanced Controls parameters are used in the following example.

Basic Control Type

Basic Control Type	Parameter configuration
Text Effect display Component configuration	Basic information: The name of the field. You can customize the field name. Control type, you can switch to other control types. Enter tips: You can customize the tips displayed in the Enter status. Default: If you do not select Read-only, the control can be edited. If you select it, the control cannot be edited. Use Login Username: If you select this check box, the control is populated with the user name by default in the specified status. Default Value: the default value displayed in the Enter status. Verification: Required: This control is required by default. Minimum Characters: Specify the minimum number of characters that can be filled in the control. Maximum Characters: Specify the maximum number of characters that can be filled in the control. Format type: Email. Prompt text when input data is invalid: you can edit the specific prompt text. Style: Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.
Value Effect display Component configuration	Basic information: The name of the field. You can customize the field name. Control type, you can switch to other control types. Enter tips: You can customize the tips displayed in the Enter status. Default: If you do not select Read-only, the control can be edited. If you select it, the control cannot be edited. Decimal: Set the number of decimal places to retain. Default Value: the default value displayed in the Enter status. Verification: Required: This control is required by default. Minimum: Set the minimum value that the control can fill. Maximum: Set the maximum value that the control can fill. Prompt text when input data is invalid: you can edit the specific prompt text. Style: Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.
Single Select Drop-down Effect display Component configuration	Basic information: The name of the field. You can customize the field name. Control type, you can switch to other control types. Enter tips: You can customize the tips displayed in the Enter status. Default: If you do not select Read-only, the control can be edited. If you select it, the control cannot be edited. Options: User Data Select Custom Data from the Source drop-down list to manually edit the content of each option. Click to drag and drop the display order of an option. Click to delete an option. Add Options: You can click Add Options to add options individually. You can also copy the content and add multiple options at a time. Click Clear in the lower-right corner to clear all options. Datasets Select a dataset from the From drop-down list. Select the dataset and data field on which you have permissions. Data sources Select a data source from the From drop-down list. Select the data source, data table, and data field on which you have permissions. Default: You can select the default options in the Status field. Validation Required: This control is required by default. Prompt text when input data is invalid: you can edit the specific prompt text. Style Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.
Drop-down Multiple Selection	The operation is the same as that of the single-selection drop-down control. The difference is that you can select multiple options in the filling status.
Date and Time Effect display Component configuration	Basic information: Field Name: You can customize the field name. Control Type: You can switch to another control type. Enter tips: You can customize the tips displayed in the Enter status. Default: If you do not select Read-only, the control can be edited. If you select it, the control cannot be edited. Format: You can select Year, Year-Quarter, Year-Month, Year-Week, Year-Month-Day, Year-Month-Day, Year-Month-Day-Hour-Minutes-Second. Default: Customize the default date displayed in the Enter status. Validation Required: This control is required by default. Prompt text when input data is invalid: you can edit the specific prompt text. Style Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.

Advanced control type:

Advanced Control Type	Parameter configuration
Image upload Effect display Component configuration	Basic information: Field Name: You can customize the field name. Control Type: You can switch to another control type. Enter tips: You can customize the tips displayed in the Enter status. Upload Method: You can select Local Image or Link. Validation Required: This control is required by default. Prompt text when input data is invalid: you can edit the specific prompt text. Style Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.
Tree drop Effect display Component configuration	Basic information: Field Name: You can customize the field name. Control Type: You can switch to another control type. Enter tips: You can customize the tips displayed in the Enter status. Default: If you do not select Read-only, the control can be edited. If you select it, the control cannot be edited. Parameter Select Dataset Source and select the dataset and data fields on which you have permissions. You can specify up to five fields. Select Source and select the data source, table, and linkage field on which you have permissions. Validation Required: This control is required by default. Prompt text when input data is invalid: you can edit the specific prompt text. Style Display Wireframe for Input Box: When checked, a wireframe will be displayed when the person filling in the selected cell input value.
Function Effect display Component configuration	Basic Information Field Name: You can customize the field name. Control Type: You can switch to another control type. Function Configurations Excel functions can be used to reference fields in table filling and dataset tables in [field name]. For more information, see Functions supported by workbooks.