Copy all rows in a slice to new table

[temp4scripts]

Hello experts

Is it possible to copy entire slice to a new table while both have same columns names? So as to make a button which transfers all data on click.

Please share some resource to learn this function or let me know what info you need to answer here.

[Aurelien]

Hi @temp4scripts 

You can, but "new table" should exist, it won't be created by AppSheet.

A quick search here should help:

https://www.googlecloudcommunity.com/gc/forums/searchpage/tab/message?filter=location&q=copy%20to%20...

The action you need is here:

Actions: The Essentials 

in the section: "Data-change action types/Data: add a new row to another table by using values from this row"

combined with: "Data: execute an action on a set of rows"

[temp4scripts]

Hi Aurelien

Thank you for your suggestions

I can work with "Data-change action types/Data: add a new row to another table" but it transfers only one row.

I understand "Data: execute an action on a set of rows" is the solution you are mentioning but I am confused about how to select the Reference Rows. I will be transferring all rows shown in slicer. Is there some example video or app which can shows how to select Reference Rows? Thanks

[Aurelien]

FILTER("yourTable", 
  IN([_THISROW],sliceOfYourTable[key_columnOfYourTable])
)

Can you try with something like that ?

[temp4scripts]

I have tried to apply this method and for a while it was working but now I am getting this error ;

[temp4scripts]

There is no reference to above error anywhere.😥

What can be that error related to?

[Aurelien]

The field expects an expression that produces a list of references values of the destination table.

From what I understand, you should start your expression with:

FILTER("WasteRecord", yourConditions)