<< Click to Display Table of Contents >> Current:  Create Dashboard > Form > Examples of Reporting  FreestyleForm Component

When the data is uncertain and not prepared in advance, it is hoped that all the cross table style data can be imported into the target database table without any operation

 

❖Analysis Scenario

1. The data style is a cross table - the "Form parameter" component that cannot be filled in using the flat table style, but the "Freestyle Form" component needs to be used

2. The data is uncertain and not prepared in advance - "Freestyle Form can be used to fill in constant cells for storage

3. Do not do any operation + import all - check "submit all data when auto-commit"

 

❖Making Freestyle Form

•The component data of constant free table in metadata mode is shown in the figure below:

 

•Set the corresponding relationship between the cell and the data column of the target table in the database

First, we can divide the cells on the free table according to the data characteristics, as shown in the figure:

 

According to the divided area, the corresponding cell can be matched with the target field of the database. The structure is shown in the figure

 

•Set row column relationship

Set the relationship between cells and select the cells that are logically a row of data into a row in the row column relationship table.

For example: user - coffee - East - sales1 is one row of data; user - coffee - South - sales2 is another row of data.

 

•Submit type is "Intelligent submit"

•Check "submit all data when auto-commit"

•The primary key of the target table of the database is determined by the actual user scenario. The temporary no primary key is consistent with the conditional column, and the table structure is shown in the following figure:

•Other items not specified are default values

 

❖Reporting Data to Database

Operation 1: open the report in the report module

Result: the initial values of report and database target table are shown in the figure

 

 

Operation 2: do not do any operation, directly click Submit warehousing

Result: all the data in the free form filling were submitted intelligently (all data were updated first, and then converted to inserted data after it was detected that the data did not exist)

 

Operation 3: enter values in cell5 and cell6 and submit data

Result 1: the data entered in the cell is preserved after submission

Result 2: the database target table updates two rows of data, as shown in the figure

 

 

Operation 4: click refresh report, click submit to stock in

Result 1: the report is refreshed and the data filled in the free form is reset to the initial value

Result 2: all the data on the free table were filled in and submitted intelligently again (updating the data of the same condition column), and the structure was as shown in the figure