Quick BI supports adding data reporting events to a cross table. After you add a form, you can use this event to directly record the form data to the destination database.
Prerequisites
A cross table is created. For more information, see Cross tables.
A form is created. For more information, see Create a form.
Add a data fill event
Go to the dashboard edit page. For more information, see Create a dashboard.
Add a cross table as shown in the following figure.
On the dashboard edit page, configure a cross table.
On the Analysis tab, click the Advanced Settings tab. In the Advanced Settings section, select Event and set Event Column Name.
Click Add Event.
On the Event Configuration page, configure the following parameters:
Event Name: required. You can customize the event name.
Event Type: required. Data filling and DingTalk are supported. In this example, data filling is selected.
Open Method: optional. Page or pop-up window is supported.
Style: optional. You can configure the text and icon styles.
Associated Form: required. This form is the one created in Data Fill.
Unique Primary Key of Source Table: required. Select a unique primary key to associate with the unique primary key of the data source of the data form to ensure data uniqueness.
Field Mapping: optional. Synchronize the dataset fields of the cross table to the form. You do not need to specify this parameter here.
Field relationships take effect only when you click Fill, and do not dynamically change with the cross table dataset.
NoteIf the fields bound to the filling form are canceled in the cross table field filtering list, you cannot click to jump to the filling interface.
For example, the mapping between "province" in the cross table and "province" in the filling field is bound:
In this case, the Province field is removed from the Selected field.
The following prompt appears when you click Fill in an event.
Then, click OK.
You can click Feedback Form in the Feedback column to go to the data form page and add data.
After the configuration is complete, you can add or modify a filled record table to the corresponding form.
