Join us for a full day of learning and inspiration at the Google Workspace Developer Summit! 🇺🇸 Boston, September 12: goo.gle/ws-dev-summit-24-boston 🇩🇪 Berlin, September 17: goo.gle/ws-dev-summit-24-berlin
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.
Yes, that is possible once you have shared that script as a library. Learn more about how to use libraries: developers.google.com/apps-script/guides/libraries?hl=en#create_and_share_a_library
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.
This is valuable feedback. To make sure it reaches the teams working on Apps Script, please use the feedback form in the Apps Script IDE which you'll find when clicking the question mark and then "Send feedback".
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.
@@googleworkspacedevs Doesn't matter any more, ended up linking from the responses Sheet, then grabbing the Form URL, binding the trigger with the Form to get the responses, then matched them to the Sheet row by timestamp, had to play with indexes to grab the row instance and then find the cell by the Drive file ID with a TextFinder (turns out the file URL in the response is not the same URL you get from the File instance, so had to search specifically by ID)...
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!
I want to make any user with the spreadsheet access click on an image in the sheet and redirect to an external URL. How can I achieve it via container-bound script
It's probably easiest to achieve this by using the Sheets formula Hyperlink (see support.google.com/docs/answer/3093313?hl=en). If you have to programmatically set the formula then check out the setFormula method: developers.google.com/apps-script/reference/spreadsheet/range#setformulaformula
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.
There are a couple of different variables in this equation that have to be taken into account (e.g. are the users all of the same Google Workspace domain or from different domains? Is the user using a free Google account? etc.). There is a dedicated page in the developer documentation that should provide you with the needed guidance: developers.google.com/apps-script/guides/client-verification
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.
I think the best practice is that you can use different Google Chrome User Profiles to separate all your accounts and works. Also, you can benefit from work-specific bookmarks when you organize them in this way. Changing profiles and avoiding signing in with multiple accounts into a single user profile is always error-proof. So I think if every client and user gets educated while starting a new user profile and how to change it easily to organize it better. Many people still using Chrome without signing in. Or they accidentally sign in to their primary Chrome profiles with multiple accounts at the beginning. So they trapped themselves unconsciously. Then they get vexed etc. ☺
I am managing 45 Chrome profiles right now on my desktop. This approach never failed for years. On my phone, I have 8 accounts. Because managing accounts and assets was designed in this way by Google itself. Why would it fail? The big and only confusion for people starts when they are able to sign in to their other accounts from their primary profile. Then this agony happens. They lost their orientation easily right from the beginning of their journeys. If Google educates people about the essence of organizing everything with the help of separate Chrome profiles the world will be a better place. This is a tiny but mandatory good practice for start. I am training every new team member in our organisation about how to switch Chrome profiles and how to organize wisely. No pain at all. Also, there is a good but not well-known practice of transferring bookmarks with folders, by drag and drop from one Chrome profile to another Chrome profile when you need to set up their Chrome bookmark bar with the right resources for the right job. @@liveautomationexperts
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.
Join us for a full day of learning and inspiration at the Google Workspace Developer Summit!
🇺🇸 Boston, September 12: goo.gle/ws-dev-summit-24-boston
🇩🇪 Berlin, September 17: goo.gle/ws-dev-summit-24-berlin
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.
Yes, that is possible once you have shared that script as a library. Learn more about how to use libraries: developers.google.com/apps-script/guides/libraries?hl=en#create_and_share_a_library
A deeper video about: how to build your first Add-On? , it will be great
Thank you for the suggestion.
@@googleworkspacedevs0:43 0:45
@@googleworkspacedevs❤
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.
This is valuable feedback. To make sure it reaches the teams working on Apps Script, please use the feedback form in the Apps Script IDE which you'll find when clicking the question mark and then "Send feedback".
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.
Thank you for that insight. In the Apps Script Editor (click the question mark > send feedback), you can leave your feedback for the product team.
@@googleworkspacedevs Doesn't matter any more, ended up linking from the responses Sheet, then grabbing the Form URL, binding the trigger with the Form to get the responses, then matched them to the Sheet row by timestamp, had to play with indexes to grab the row instance and then find the cell by the Drive file ID with a TextFinder (turns out the file URL in the response is not the same URL you get from the File instance, so had to search specifically by ID)...
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!
I want to make any user with the spreadsheet access click on an image in the sheet and redirect to an external URL. How can I achieve it via container-bound script
It's probably easiest to achieve this by using the Sheets formula Hyperlink (see support.google.com/docs/answer/3093313?hl=en).
If you have to programmatically set the formula then check out the setFormula method: developers.google.com/apps-script/reference/spreadsheet/range#setformulaformula
Cheers, nice to see such fundamental notions clearly explained.
You can build super cool solutions on a good knowledge foundation.
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.
There are a couple of different variables in this equation that have to be taken into account (e.g. are the users all of the same Google Workspace domain or from different domains? Is the user using a free Google account? etc.).
There is a dedicated page in the developer documentation that should provide you with the needed guidance: developers.google.com/apps-script/guides/client-verification
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.
Thank you for the feedback. We are aware of the issue and are looking into possible solutions.
I think the best practice is that you can use different Google Chrome User Profiles to separate all your accounts and works. Also, you can benefit from work-specific bookmarks when you organize them in this way. Changing profiles and avoiding signing in with multiple accounts into a single user profile is always error-proof. So I think if every client and user gets educated while starting a new user profile and how to change it easily to organize it better. Many people still using Chrome without signing in. Or they accidentally sign in to their primary Chrome profiles with multiple accounts at the beginning. So they trapped themselves unconsciously. Then they get vexed etc. ☺
@@DemirAydemir Is there any tutorial from google with mutiple profiles and using google sheets? This is going to be a temporary turnaround solution.
I am managing 45 Chrome profiles right now on my desktop. This approach never failed for years. On my phone, I have 8 accounts. Because managing accounts and assets was designed in this way by Google itself. Why would it fail?
The big and only confusion for people starts when they are able to sign in to their other accounts from their primary profile. Then this agony happens. They lost their orientation easily right from the beginning of their journeys. If Google educates people about the essence of organizing everything with the help of separate Chrome profiles the world will be a better place. This is a tiny but mandatory good practice for start.
I am training every new team member in our organisation about how to switch Chrome profiles and how to organize wisely. No pain at all.
Also, there is a good but not well-known practice of transferring bookmarks with folders, by drag and drop from one Chrome profile to another Chrome profile when you need to set up their Chrome bookmark bar with the right resources for the right job. @@liveautomationexperts
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.
Thank you for sharing your feedback with us.
Hi google team my old Gmail account recover code problem please help me
Check the Gmail Help for support: support.google.com/mail/?hl=en#topic=7065107
Thanks, great video!
Happy you liked it 😃