Moving a table to a different google sheet

[EliK]

Hi!

I have an app where all of my tables are saved as separate tabs in one sheet. I'm going to need to change the location of one of the sheets to be it's own separate sheet.

What's the best way to do this? I have dozens (!) of virtual columns saved in this table, so I can't just make a new sheet with the same data.

Can someone explain to me what the button "copy data to new source" does, and if it can help me in this case?

Thanks!

[dbaum · Accepted solution]

Move the sheet to a new spreadsheet file and change the table's Source Path and Worksheet Name. Try the technique first with a dummy table and you'll feel comfortable.

[dbaum · Accepted solution]

Move the sheet to a new spreadsheet file and change the table's Source Path and Worksheet Name. Try the technique first with a dummy table and you'll feel comfortable.

[EliK]

I will be brave and try it on a dummy sheet, like you suggested.

Thanks!

[MultiTech]

If you made a mistake, you can always undo things with the version history!

Have no fear! 💪💪💪

[Swoopy · Accepted solution]

You can create (or copy) new Google Sheet to store separated tables in any folders in your Google Account. The structure of column (the first/header row) must be exactly the same as the current table your AppSheet's linking to.

Now you just change table location in AppSheet. That's it.

Use these options to point your desired table.

More info regarding 'virtual column' in AppSheet, the virtual columns have nothing to do with the physical Google Sheet table. They are just things that's happening ONLY in the apps you created, like their name "virtual" not "real". In other words, your Google Sheet table can't be modified by any virtual columns created in AppSheet.

[EliK]

Thanks guys!

That was super simple and easy, worked like a charm.