how to deal with revisions to sheet script

[aronwc]

so that when we update the script, we can auto push to all the sheets out there.
maybe the script's first line can read from a URL where the canonical script lives? seems a little crazy...

[aronwc]

Can we use a "Google Web App" or a Library or Addon to do this?

[sfeldman1]

Web app - Deploy script as a web app that provides a unique url for the script. The sheet template has google.script.run function to call the web app - https://developers.google.com/apps-script/guides/web

[aronwc]

We can now do this! have a "unattached" script that will be in the FINAL DATA folder that will be referenced from each sheet. https://script.google.com/home/projects/1wHPphHnaklK9pW-HuoEBdOGib19-bEMosatzjfWhwmsxJPawQXaUoJN1/edit
Steps are:

1. Deploy the script
2. From sheet, reference the deployment id

Any changes to script will automatically be reflected in sheet.

We need to figure out how to do development without immediately affecting existing sheets.