HI!
I am trying to figure out how to copy contents from one cell in a repeating table to another repeating table. This is to save users having to put in repetitive values.
Ideally users enter all values in table 1, then click a button I make, and all those values are copied down automagically.
Example:
Table1:
------------------------------------------------
Label1 | Value1 | Value2
-------------------------------------------------
Label2 | |
-------------------------------------------------
Label3 | |
-------------------------------------------------
Label4 | |
-------------------------------------------------
Table 2: (all values in first column is copied in, not written)
------------------------------------------------
Label1 | |
-------------------------------------------------
Label2 | |
-------------------------------------------------
Label3 | |
-------------------------------------------------
Label4 | |
-------------------------------------------------
There is a function for "set value as" where I can use table1/column1 as source, and table2/column1 as recipient.
But problem is it only uses the first rows value, i.e. all rows in table 2 would have value "Label1". Not quite what I was after.
Any clever people out there who can give me some tips on how to solve this pickle? Thanks!