Solved: Copy multiple rows from Table A to one Row in Tabl... - Page 2

sathishk · 07-27-2023 11:27 AM

Hi guys, thanks for your help in advance

Table A - Column 1, 2 & 3 are same (unique) values in Rows 1 & 2

I want to copy

values from Table A - Column 1, 2 & 3 Rows 1 & 2 to (single) Row 1 of Table B Column 1, 2 & 3

Copy from multiple rows of Table A to single row of Table B

is this possible? how?

Marc_Dillon

@Marc_Dillon wrote:

B
1. Use your existing setup, with multi-select on tableA record, and a bulk action. But instead of that bulk action creating the invoice record, have it just flag those tableA records in some way (set a value to some column that can be looked up later).
2. Add a second inline action, that only appears on the first flagged tableA record. This action will create the invoice record and set all tableA's [invoice] values to it (MAXROW again).

A clarification on a point that you apparently misunderstood:

These are 2 separate actions.

One is for flagging the records first, you run this action in bulk across all records.
The second is for creating the invoice with the flagged records. You only run this action once on a single record. MINROW is to be used in this action's show_if condition so that it only displays on a single one of the flagged records.

View solution in original post

Copy multiple rows from Table A to one Row in Table B