1. Data preparation Data preparation is consistent with the general dashboard please refer to <Data preparation>. 2.Make the form dashboard 1)Create a new dashboard and select the form parameter component from the right side as shown in the figure below. 2)From the data, select the MySQL dataset and bind the data column "Product", "Sales volume", "Profit", as shown in the figure below. 3)Click on the top menu [form> form mapping], create "Form1", select the need to mapping "connection" and "table" after the "click the "auto match field group ", automatically match the source column and target column, and check the order ID line corresponding condition box, at the bottom of the commit type selection" intelligent commit ", set complete click" OK". 4)Drag the commit component from the right form component, and in the component [Setting> Option], select the commit type as "Commit Data to Database", and check the parameter as "Form1". 5)Save the dashboard. 3.Form Preview or view the dashboard, as shown, modified order ID to 556 sales volume to 60 and modified profit to 88. Click the commit button, to see that the data of the database has been updated.
|