Freestyle Form Filling

<< Click to Display Table of Contents >>

Current:  Create Dashboard > Form > Freestyle Form Component 

Freestyle Form Filling

Previous pageReturn to chapter overviewNext page

Making Freestyle Form

Take the scenario where the data of the detail table is summarized and backfilled into the target summary table in the cross table format (the relationship between the source field and the target table is a - > b), and the specific information is as follows:

 

1. The component data of constant free table in metadata mode is shown in the figure

freestyleForm35

2. The matching information of cell and target table is shown in the figure

*Cell "product type" - > target table "PRODUCT_TYPE "

*Cell "market" - > target table "Market"

*Cell "sales_sum" - > target table "SALES"

*Cell "profit_sum" - > target table "PROFIT"

*Cell "sales_sum - profit_sum" - > target table "COGS"

*System parameter current login user"_ USER_ "- > target table" user"

*System parameter current time date"_ NOW_ "- > target table" date"

freestyleForm41

 

3. Set the row column relationship

*When only one cell is added to the original field, this cell will be automatically selected in the row column relationship table

*When multiple cells are added to the original field, the row column relationship table needs to be selected manually, and the cells that are logically a row of data need to be filled into one row of the row column relationship table

freestyleForm42

 

4. Submit type is "intelligent submit"

5. Check "submit all data when auto-commit"

6. The primary key of the target table of the database is consistent with the conditional column, and the table structure is shown in the figure

freestyleForm25

6. Other items not specified are default values

 

Data filling and submitting 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

freestyleForm36

 

freestyleForm26

 

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

Results: 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)

freestyleForm37

 

freestyleForm38

 

Operation 3: write down the sales and total cost of tea southern market and submit the data

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

Result 2: update one row of data and update the data of tea southern market row with new data, as shown in the figure

freestyleForm39

freestyleForm40