<< Click to Display Table of Contents >> Freestyle Form Filling |
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
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"
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
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
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
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)
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