Integration & Automation-delete data inserted by business rules into the target table
1. Case Background
When a form setting business rule inserts data into the target table, input errors are often caused. However, deleting the data entered in the target table data will not be deleted, resulting in repeated work;
This example will automatically delete data from the target table through integration and automation to solve the above difficulties.
2. Achieve results
Submit flow chart insert data into the target table (common form) through business association rules. When deleting process data, delete the records inserted into the target table together.
3. Procedure
Two forms are required: information entry table (flow chart) and user information base table (common form)
3.1 Step 1: form design
Create two forms,Submit information entry form (flow chart) and user information base form (common form)
Path: after entering the application> Create page in the upper left corner> Create form/create flow chart
Create form/flow chart
3.1.1 user information base table
Form usage
- Store user information
Component configuration
- User Name: single line of text
- ID number: Single line text
- Mobile phone number: single line of text
Component configuration
Verify whether the submitted ID card number and phone number are standard. You can enable single-line text format verification.
Format configuration
3.1.2Submit information entry form
Form usage
- Basic information for submitting users
Component configuration
- Entered by: Member
- User Name: single line of text
- User ID card: single line of text
- Phone: single line of text
- Gender: Single line text
- Age: value
- Can be added according to your own needs
If you want to automatically obtain the gender and age by entering the ID number, you can refer to the following case documents for configuration.
Automatically calculate gender based on ID number
Automatically calculate age based on ID number
3.1.3 node submission rules
Yes"Submit information entry table" sets node submission rules and inserts some information into the "user information base table 」
Path: click information entry table> Edit inverted triangle symbol next to Flow Chart> Process Design> Global Settings> node submission rule> create rule
Set Business Association rules
At the same time, a verification rule is set to reset the ID number verification to prevent the same user from being entered.
Verify rule configuration
Further reading:
Purchase, sale and storage system construction
3.2 Step 2: Create Integration & Automation
Set Integration & automation to delete data
Create a path: Enter the corresponding application> Integration & automation> create Integration & automation> Name> form event trigger> OK
Create Integration & Automation
Triggered when the destination deletes process dataSubmit information entry form 」New Integration & automated form selection event triggered-deleted
Select trigger event
3.2.1 add and obtain a single data node
Create a node to obtain data.User information base table 」Data inserted in
Add get data node
Method of obtaining
- Get from the form and select get data from the user information bottom table
Obtain method selection
Data Filtering: All data
Sorting rules: do not sort
For more information about obtaining a single data node, seeData node-obtain a single piece of data
Configure data filtering and sorting
3.2.2 add and delete data nodes
Add a delete data node
Add and delete nodes
Select a data node: delete「Obtain a single piece of data」Data
For more information about deleting data nodes, see Data node-delete data
Select the deleted data node
4. Display effect
SubmittedInformation entry tableData is automatically insertedUser information base tableAnd delete the newly submitted data,User information base tableThe corresponding data is automatically deleted.
-------------------- Get the latest information YIDA, welcome to follow US--------------------
