Managing the scripts

[Balubeto Balubeto]

Hi

On my Apps Script page, I have some scripts that should be associated with various spreadsheets.

How should I do this?

Also, if I were to move a spreadsheet with its scripts to another Google account, how should I ensure that the spreadsheet works correctly also on the new account?

Thanks

Bye

[George Ghanem]

That's a good question and I had to move a bunch of spreadsheets and scripts recently from one account to another. Here are some steps you should do:

1- disable or delete the triggers on old account for the spreadsheets/scripts you are moving.

2- add new account as editor in sharing setup of spreadsheet.

3-transfer ownership of spreadsheet to new account.

5- On new account, accept transfer of spreadsheet

6- On new account, remove old account from sharing setup

7- On new account, enable needed triggers, this will also ask you to authorize the script to run.

The script should work the same way on new account as old, assumes it does not access any specific file id's. If it does, you will need to change the script to provide the new id's of the files it accesses.

As for how to manage scripts, that's a difficult one and I have yet to find a method I like. But one good practice is to minimize scripts in spreadsheets and have the scripts standalone as much as possible and place them in specific folders for easy access.

--
You received this message because you are subscribed to the Google Groups "Google Apps Script Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-script-c...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-script-community/bc382744-b9f2-4ddb-abf1-09ca09a2199bn%40googlegroups.com.