Overview
Application Scenario
If you need to modify or add data when designing a data entry report, you must add data entry widgets for the cells to which data is to be entered.
FineReport supports 16 types of data entry widgets, each of which applies to different data entry scenarios.
Function Entry
To add a data entry widget for a cell, select a cell, select Widget Setting on the right attribute panel, and select the required widget from the drop-down list of Select Widget.
Data Entry Widget Type
The following table lists the application scenarios for 16 types of widgets. You can click the corresponding hyperlink to view a detailed description of each widget.
| Type | Widget Name & Help Doc | Application Scenario |
|---|---|---|
Data Entry | Text Widget | You can fill in single-line text information, such as the name, email address, mobile number, and postal code. |
| You can fill in multi-line text information, such as a personal introduction, product description, and survey response. | ||
| You can fill in numbers, such as sales volumes, profit amounts, and scores. | ||
| You can fill in passwords, which will be hidden and invisible while typing. | ||
Click | You can click a button widget to achieve a certain effect, such as inserting or deleting a row during data entry. | |
Selection | You can select multiple records simultaneously and perform operations on them, such as batch deleting data, submitting multiple records, or batch editing data. | |
| Multiple options are available, but only one can be submitted, for example, single-choice questions in exams or questionnaires. | ||
| Multiple options are available and can be submitted simultaneously, for example, multiple-choice questions in exams or questionnaires. | ||
| You can select one option from a drop-down list to fill in a cell. | ||
| You can select multiple options from a drop-down list to fill in a cell. | ||
| You can select a date to fill in a cell. | ||
| You can upload and store files to a database table. | ||
| You can select one from the options displayed in a list and perform the submission. | ||
Iframe Widget | You can insert a web page or a report into a cell. | |
| You can select one or more options from a tree structure to fill in a cell and execute the submission. | ||
| You can select one or more options from a tree structure to directly submit the options into the database. |
Default Value Setting for Date Entry Widgets
If you want a widget to have a default value during data entry, you just need to enter the default value into the cell containing the widget when designing the data entry template.
For example, if you want to set a default value for Date in the following template to dynamically display the current date, you just need to enter the formula =today() into the cell that contains a text widget next to Date when designing the template.
Notes
Widget Value Clearance Caused by Data Dictionary Linkage
According to the current function design, the value of another widget linked to one widget triggering data dictionary linkage will be cleared.
Data Dictionary Calculation During Initialization
If a widget that has been configured with the data dictionary on the parameter panel has no default value, the data dictionary will calculate data when you click the widget to trigger option loading. If the widget has a default value, the data dictionary will calculate data directly during widget initialization. Therefore, if the data dictionary executes SQL statements at a slow speed, setting default values for widgets will significantly impact the overall template loading speed.
Reversion to the Previous Value in Text/Number Widgets
If the entered value does not meet the validation rules that have been configured in text or number widgets, a corresponding prompt will appear, and the current input will be cleared and reverted to the previously entered value.
Numeric Precision Loss in the Data Dictionary
Note:If the data in the data dictionary of a widget is of a numeric type (for example, bigint), the numeric precision may be lost, as shown in the following figure.
The solution is to convert the numeric type to the string type. For example, you can perform the conversion by SQL statements, as shown in the following figure.
Ineffective Display in Cells with Drop-Down Widgets
If the data dictionary is set to a dataset containing dataset parameters in Display for the cell containing a drop-down box widget or a drop-down checkbox widget, the display will not take effect during frontend preview.
Previous：Learning Path of Data Entry
