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

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?

0 3 1,258
3 REPLIES 3

RezaRaoofi
Participant V

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.

Thank you!

RezaRaoofi
Participant V

@Marc_Dillon You are welcome Marc!

Top Labels in this Space