Copy this row and edit the copy not complete

[Espegg]

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?

[TeeSee1]

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?

[Espegg]

Hello, yes.

These columns are blank.

why?

[TeeSee1]

If they are uneditable, how do you populate them in the first place?

[Espegg]

Are pre-populated in the sheet from an apps script.

it is a bug?

[TeeSee1]

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.

[Espegg]

If I make the columns editable and then I run the actions, the values are copied.
So it is a problem of the table?

[TeeSee1]

I really have no idea, unfortunately...

On copying source rows, you just have plain values, right? No formula, etc.