Hi!

I am working on a link task where the user wants to ‘import’ data from one table to another

For example: 

Purchase orders can be generated through a purchase needs table. The purchase order table consists of purchase order lines. The user also wants the possibility to import purchase needs into an existing purchase order. I set up the following process flows:

Process Flow 1

1. The user clicks on the link task located in the purchase order line. The purchase_order_id is one of the task parameters.
2. The purchase needs table is opened (as a floating document) with the necessary active filters. Only active purchase needs with the same supplier as the purchase order’s supplier are shown.
3. A hidden column ‘link_purchase_order_id’ in the purchase_need is filled with the purchase_order_id. This is done in a decision process action.

Process flow 2

1. The user must be able to select multiple rows in the purchase need table. 
2. A decision performs an update and empties the ‘link_purchase_order_id’ of all unselected rows.
3. The selected rows are inserted into the purchase_order_line table and the necessary purchase_order_id is retrieved through the ‘link_purchase_order_id’ column.

This however does not seem as best practice. Since the process can be disturbed when users start performing these actions simultaneously with the same supplier.

Is there a possibility to ‘save’ the purchase_order_id or send it to another process flow?