As stated in the title, I have trouble setting the value of a column of specific row( provided with key) using the current row’s data. I created an action that “Sets the value of a column” and added another one that references the previous action with “Execute an action on a set of rows”. The problem here is that the output being set is based on the column value of the target row.
Suppose that I selected row 10. I want row 10’s [Identification key] column to be copied in the [Selected key] in row 1. What happened is that row 1’s [Identification key] value is the one being put in the [Selected key], not from row 10. I hope you could help me on this.
I think if you want the value that is being set to come from a different row than the target row; then perhaps in your first action (“Sets the value of a column”) you could use a LOOKUP() to grab the value from another row?
What kind of reference do you have between these rows… or is there any? With the question I mean you should have some kind of reference so you would know what is the source row. It should be row#10, but you should know it from the row#1.