Hello,
I have a workflow which includes repetitive data input. Simple copy-paste have some drawbacks.
I have a table called Orders. Each row is one order which includes product, quantity etc. Each order requires multiple tasks to complete and there is a linked table for that called Order tasks.
Orders come in patches with different products but every product tasks are very similar. I would like to configure first order tasks and then copy it to the rest of the orders. The problem is that then there are only first few tasks which are linked to ALL of the orders. Each order should have their own set of rows in Order tasks table.
I have tried multiple workarounds but I haven’t found working solution. For example, duplicating rows in Order tasks table makes it very tedious to relink to correct row in Order table. I have also configured “allow linking to multiple records” but it seems to have no effect when copying and still links to multiple records even when not allowed.
Is there some kind of copy paste workflow which duplicates rows in Order task table?
