I have this action “Copy this row and edit the copy” to duplicate a row in TABLE1.
The problem is that the action not copy the column not editable.
How could copy also these column with its values in the new row?
1 Like
In my test, even columns with its editable flag unchecked get copied to a new row. Of course you cannot edit it in the newly created row.
What is exactly happening? Your columns get blanks? Any App Formula defined for those?
1 Like
Hello, yes.
These columns are blank.
why?
If they are uneditable, how do you populate them in the first place?
Are pre-populated in the sheet from an apps script.
it is a bug?
Most likely Not a bug. It works fine for me. There has to be a reason.
Are you copying rows within one table or across different tables? What happens if you make them editable just to see what is going on?
Edit: first one is a stupid question. With the action you can only copy in the same table.
If I make the columns editable and then I run the actions, the values are copied.
So it is a problem of the table?
I really have no idea, unfortunately…
On copying source rows, you just have plain values, right? No formula, etc.
1 Like