Is there a faster way ...create an action to copy whole record to archive table?

[Lucinda_Mason]

Feature Request: Automatically copy the whole row’s data then allow some columns to be edited or removed as desired.

It appears I have to enter each column in both places to copy every one over to the Archive table. Is there a way to simply say copy every column? The two tables have the EXACT same column structure and names.

[Steve]

Lucinda_Mason:

Is there a way to simply say copy every column?

Nope.

[Bellave_Jayaram]

Yes, it would be nice to be able to say make a copy of ALL the columns OR make a copy of ALL columns except change these columns to these values.

[MultiTech]

@Bellave_Jayaram agreed.

Maybe this warrants a feature request.

[Lucinda_Mason]

made it a feature request.

[Lucinda_Mason]

Thanks for the reply. Is there a recommended way to archive records? I have another table with tons of columns that will need to be archived regularly based on a date column. I don’t like the thought of creating a similar action with all those columns.

[Steve]

Lucinda_Mason:

Is there a recommended way to archive records?

Not that I know of.

[Bellave_Jayaram]

If you are using Gsheets, you can use a GAS script. See this How to create an automated gSheet backup within your app