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

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.

Nope. :frowning:

2 Likes

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.

3 Likes

@Bellave_Jayaram agreed.

Maybe this warrants a feature request.

2 Likes

made it a feature request.

1 Like

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.

1 Like

Not that I know of.

1 Like

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

2 Likes