Standalone vs. Container-bound Apps Script

In this video you are going to learn the difference between standalone and container-bound Apps Script projects. You will also learn when to use which.

0:00 Intro
0:21 How to create a script?
1:20 How to find and edit a script?
2:02 How to run a script?
2:48 How to share a script?
3:50 How to delete a script?
4:30 When to use a standalone and when to use a bound script?

#googleappsscript #googleworkspace #GoogleWorkspacePlatform

[googleworkspacedevs]

Subscribe to this channel to learn more about and Apps Script.

[eudesgrangeDGC]

Cheers, nice to see such fundamental notions clearly explained.

[daque]

A deeper video about: how to build your first Add-On?, it will be great

[CarlosEstebanLopezJaramillo]

The biggest issue I find is that I can't bind the script to both the form and the sheet, the form trigger gives me easy access to get all uploaded files, then upload them somewhere outside Google Drive, but has no easy way to tell which row in the Sheet that response represents, on the other hand the Sheet trigger contains the exact row of the sent response, but all the values come as strings, so I would have to loop through all the items and do some weird regex for Google Drive URLs to check if the URL is a file, quite painful tbh.

[JosephTorres-ls]

Please do a video on default vs standard Google Cloud Projects for app scripts. I would particulary like to know if with VPC Network rules, I can limit what IP address access my App Script web app. Thanks!

[maximelecourt]

Great video, I didn't know standalone scripts existed so I didn't understand many tutorials. Quick question, is it possible from a bound script to call standalone script functions ? I would think yes but I'm not sure.

[michaelbingham-hawk]

one way to better manage the multiple copies of container bound scripts especially when people are copying from the template gallery, is to build a standalone library, here is where I do most of the heavy lifting, and then in the container bound script, I call to those libraries. End users can read the library, but can't edit. I use this to be able to control the custom menu or sidebar formatting and functionality for all referencing sheets. I have been playing around with a "DataTab" where each sheet template that I have has a non editable cell which contains the sheetid of the template (parent) that was use to create the copy (child) of that template. Using an on edit script in my library, I pass down a rule that if someone deletes the parent id in the cell on the datatab, it reverts back to the previous value and warns that the cell cannot be edited. This is outsside the typical sheets permissions. In the library, i stage helperfunctions, where I declare the source of truth for any document that has parent id of "x" in the child cell on DataTab. IF that is found onopen, then the custom menu from the library is passed down to the child. My endusers treat our sheets like a notebook. I had to lock it down haha.

[SukhjitSingh-mv]

hi team,
I have a very specific question about container bound scripts and workspace development.
Lets say I have a google sheet and an associated container bound apps scripts project.
Any user who creates a copy of this sheet also gets associated apps script copied, which is great.
But the user gets an Unverified App Screen warning.
How can I prevent this from happening? (assuming I have a google workspace account and a website for privacy policy).

I would assume since its a container bound apps script project, it would not make much sense to publish this as an add-on to marketplace, so I would also assume it would not require app verification process?

What steps I can take to prevent Unverified App Screen?
I couldn't find info regarding this specific question on website.

[googleworkspacedevs]

Join us for a full day of learning and inspiration at the Google Workspace Developer Summit!

[liveautomationexperts]

There are issues in editing container - in bound scripts. When we have multiple accounts, it is an issue. I will have to sign-out and sign-in again where the google sheet associated with. Any solutions for this? Clients get vexed with this.

[Sparky_]

It's really too bad you won't provide the ability for the owner of a google sheet to lock the container script from being viewable by editors of the google sheet.
I want to create a Custom Menu in my Google Sheet and allow the users to edit only particular ranges, while also being able to run scripts from the Custom Menu.

THIS, would be so so SOO.... Useful.

[cloudengineering]

Problem with simple fix:
It is nice that container-bound script copy with the file. However, the GCP project_id that is set in project settings is not copied. This leads to users having to change a setting (the project_id) every time they copy a file with a container bound script if that script relies on GCP. This can be easily fixed by just automatically copying (or setting) the project_id of the script when the script is copied.

[mdkolixa]

Hi google team my old Gmail account recover code problem please help me