I'm using google sheets as a data source. If ...

(Marc Dillon) #1

I’m using google sheets as a data source. If I wanted to move a sheet from one workbook to another, will I be able to easily just redirect the table source in appsheet to the sheet in the new workbook? Or will it bug out and make me redo a bunch of things?

(Reza Raoofi) #2

As long as the column headers remain the same after moving the sheet (tab) to another spreadsheet, your app should remain intact.

In order to make it seamless, I recommend to first open your app in app editor, then move/copy the sheet to new spreadsheet while app definition is open in app editor; go to Data > Tables; open table definition and change Source Path (spreadsheet name), and Worksheet Name/Qualifier (sheet name) accordingly, and save.

(Marc Dillon) #3

Thank you!

(Reza Raoofi) #4

@Marc_Dillon You are welcome Marc!