Smart Submission
Application Scenario
Smart Submission offers a three-in-one approach for insertion, update, and deletion. The backend checks the number of operation types (insertion, update, or deletion) during data entry submission. If you perform two or more types of operations during data entry, you can select Smart Submission.
Note:Submission Logic
Data (deleted through the Delete Row function) is first recognized on the page and then deleted by locating the corresponding data in the database based on the set key.
After the deleted data is excluded, the system checks whether the remaining data corresponds to any data in the database based on the set key. If so, the update operation will be performed. If not, the insertion operation will be performed.
If you select No Modification, No Update, data (not modified on the page) will not be submitted during data entry. For details, see No Modification, No Update.
If you want to update or delete data, you must select keys (similar to the WHERE statement in SQL and not similar to those in the database). If you do not select keys, Insertion Submission will be uniformly performed.
If empty rows are inserted through the Insert Row function but not edited, the values of these rows will be recognized as null. In this case, these rows will be filtered out and not be stored during submission.
The order of data after storage into the database may differ from the data display order on the page.
Effect Display
1. Design the original template data in the data entry table, as shown in the following figure.
2. Set Submission Type Selection to Smart Submission on the Data Entry Attribute setting page, as shown in the following figure.
3. Perform the adding, modification, and deletion operations, as shown in the following figure.
Deletion Submission
Application Scenario
Deletion Submission can only be used to delete data. If you only need to delete data, you can select Deletion Submission.
Submission Logic
The logic of Deletion Submission is contrary to that of Smart Submission. Data (deleted through the Delete Row function) on the page is first excluded. Then the remaining data on the page is deleted by locating the corresponding data in the database based on the set key.
You only need to add the key field. Other non-key fields have no impact on the result no matter whether they are added.
The key field must be set, otherwise the Deletion Submission operation will not be performed.
Effect Display
Effect Display
1. Design the original data in the data entry template, as shown in the following figure.
2. Set Submission Type Selection to Deletion Submission on the Data Entry Attribute setting page, as shown in the following figure.
3. The following figure shows the frontend data entry effect. After submission, data displayed on the data entry page is deleted while data deleted through the Delete Row function is retained.
Insertion Submission
Application Scenario
Insertion Submission can only be used to insert data. If you only need to insert data, you can select Insertion Submission.
Submission Logic
The logic of Insertion Submission is the same as that of Smart Submission. After data (deleted through the Delete Row function) is excluded, the insertion operation is performed on the remaining data on the page.
The duplication of data is not detected. That is, duplicate data may be stored in the database. If the database cannot store duplicate data, a relevant error prompt will occur when you click Submit.
If empty rows are inserted through the Insert Row function but not edited, the values of these rows will be recognized as null. In this case, these rows will be filtered out and not be stored during submission.
The submission result is not affected no matter whether the key is set. The key setting is not read after the submission.
Effect Display
1. Display no original data in the data entry table, as shown in the following figure.
2. Set Submission Type Selection to Insertion Submission on the Data Entry Attribute setting page, as shown in the following figure.
3. Insert data and click Submit. Data is successfully stored in the database, as shown in the following figure.
4. View the database table information. A record of data has been added to the table, as shown in the following figure.
Update Submission
Application Scenario
Update Submission can only be used to update data. If you only need to update data, you can select Update Submission.
Submission Logic
Data on the page is updated by locating the corresponding data in the database based on the set key. Multiple records of data with the identical key are merged for update. That is, data is updated based on the last record of data.
The key field must be set, otherwise the Update Submission operation will not be performed.
The Delete Row operation is not recognized. That is, data deleted through the Deleted Row function is also updated after the submission.
Effect Display
1. Design the original template data in the data entry table, as shown in the following figure.
2. Set Submission Type Selection to Update Submission on the Data Entry Attribute setting page, as shown in the following figure.
3. Modify data and click Submit. The data is successfully updated, as shown in the following figure.
