Action 1 is defined: For a record of Table A, “Execute an action on a set of rows”. Referenced table: Table B. Referenced action: Action 2.
Action 2 is defined: For a record of table B, “Add a new row to another table using values from this row”。 Table to add to: Table C.
In action 2, I want to set a column of the new row in Table C equal to the key of the row in Table A where action 1 was used. Is that possible? How do I refer to that row in table A from Action 2?
If that’s not possible, here’s my use case.
Table A contains orders (columns: order number, pieces ordered, and related worktasks to fabricate pieces ordered).
Table B contains fabrication steps (columns: step, estimated time per piece)
Table C is the worktasks Table A refers to. Columns for table C:fabrication step, duration, start time, end time, employee assigned, associated order.
The idea of the whole flow is to, for a particular order, create one of each kind of worktask (e.g. prep, create, package) listed in table b.
I use table b as an intermediary because the fabrication steps are altered from time to time. It
If there isn’t an easy way to do what’s in the “quick version”, is there a work around to accomplish this?