How to run versions for a Google Sheet

[Stephen Schlager]

Hello,

I have found many resources for running versions and Managing deployments, but they all seem to relate to Web Apps with doGet or doPost etc. or libraries...

I have apps script code that runs for a spreadsheet (modifies the spreadsheet, sends emails, etc.)

I have tried playing with deployments but it always runs from the HEAD, is there a way to version control this type of Google Spreadsheet script?

I'd like the user to be able to go to the spreadsheet and when they click on the menu button I created it will run whichever version I've "deployed".

Does that make sense?

Also is there a way to version control code bases, so I could jump to a previous version in my Apps Script console and see the code from that version?

Thank you,

Steve

[Andrew Roberts]

> I'd like the user to be able to go to the spreadsheet and when they click on the menu button I created it will run whichever version I've "deployed".

I don't think you can do this without using libraries. Put your main code into a library, and a minimal bound script on the GSheet that uses the version of the library that you have "deployed".

> Also is there a way to version control code bases, so I could jump to a previous version in my Apps Script console and see the code from that version?

Not natively. The GasHub chrome extension lets you use GitHub to manage the version you want in a particular script project.

This is how I manage my dev flow.

--
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/3f1a36f8-3d12-4378-9a1f-39d4b436392an%40googlegroups.com.

[Stephen Schlager]

Thank you for the ideas...I thought it would be a kind of work around. Seems like something they should integrate at some point.

I appreciate you sharing your workflow!

Have a great weekend!

[Martin Hawksey]

It is possible to programmatically update apps script code by calling the Apps Script REST API. An outline of this approach is provided here https://stackoverflow.com/a/65560046/1027723

Rather than the user 'pulling' the deployed version by clicking a button you might find it better to 'push' code so that can can ensure the user is using the correct version of your script. You would do this by maintaining a list of script project ids then pushing code as needed.

If you want to take this one step further there are come nice workflows possible using GitHub https://pulse.appsscript.info/p/2022/06/how-to-automate-google-apps-script-deployments-with-github-actions/ (GitHub provides private repos on free accounts)

[Bruce Mcpherson]

This might be of some use

https://ramblings.mcpher.com/apps-script/add-ons/import-scripts/

https://ramblings.mcpher.com/apps-script/add-ons/inline-libraries/

You'd update the container bound script from some version of a master script

bruce

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/6d11afcf-b63f-4c6d-84cf-118e45d64bban%40googlegroups.com.

[Stephen Schlager]

Appreciate the ideas guys.

Google's platform makes development so easy...if they integrated something like that, it would be amazing!

For now, thanks for the ideas.

Steve

[Emerson Maia]

Good night I think the best option and you will create a library in them will have the updates.

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CAN1QPJR3ORDiNke%2B33q24YLShiXaeZ5_EU7%3D2cF_aTC5%3DTP3Zw%40mail.gmail.com.

[Витя Коледа]

пн, 13 июн. 2022 г., 12:44 Bruce Mcpherson <br...@mcpher.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/google-apps-script-community/CANijH0XzKbU8b%2BOY9Av9k9yhrT68SHCePnxK4y9xM6GjGUmTWA%40mail.gmail.com.