Copy all rows in a slice to new table

AppSheet AppSheet Q&A
,
1

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.

2

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%20another%20table&noSynonym=false&location=category:appsheet&collapse_discussion=true

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”

3

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

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

Can you try with something like that ?

5

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

temp4scripts_0-1654279054810.png
temp4scripts_0-1654279054810.png1262Ă—770 55.2 KB

6

There is no reference to above error anywhere. :sad_but_relieved_face:

What can be that error related to?

7

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)
1 Like