Sharing Apps Script code between multiple sheets?

[Michael Newstead]

Hi,

For one of the teams I work with, I have a sheet which I have written some Apps Script for which processes buganizer data in the sheet (synced from Culvert).

This has been successful, and now I want to roll it out to other teams I work with.

The App Script code will be the same for each team, how do I have multiple sheets using the same code, rather than copy & pasting the code to each new sheet and creating a maintenance nightmare for myself?

Any tips?

Thanks

Michael

[Andrew Roberts]

Typically, you would create an Add-on that was private to your domain. Failing that you could move the code to a library and just have a minimal bound script in each sheet (what I most use). However this way each sheet would have to be manually updated, unless you can give everyone edit access to the library (in which case they can see the latest code).

--
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 on the web visit https://groups.google.com/d/msgid/google-apps-script-community/fdd994d1-ac1b-4078-9205-8f5a2490c3een%40googlegroups.com.