Thanks! I'm quite new at programming. I'm trying to bound an html form to a google sheet but somehow it doesn't. I will continue watching all your videos, because there are just for me, thanks again! awesome work!!
Hi Diego! Thanks for the encouragement! It means a lot :) If your HTML form is hosted on a Google Apps Script Web App, there are many ways you can do this! Check out my videos Episode 3.7 (ua-cam.com/video/XdGY4AcXD38/v-deo.html) and Episode 7.4 (ua-cam.com/video/vGEfzs7oS1s/v-deo.html). If you're hosting your website anywhere else, you will need to use the Google Sheets API (developers.google.com/sheets/api)
Hi, I'd like to create a spreadsheet with a custom sidebar that users can access and use an instance of the spreadsheet but they should not be able to copy it or the code. What would the best way to set this up be? The user will interact with the sheet by changing values on the sidebar only.
You reference "last episode" but I don't see any link to it in the description. Thank for the tut. Edit: I tried finding it. It is Ep 0.3 but nowhere in the title does it say Standalone Apps like it does here (but its not here!). Also you havent really covered standalone apps in that particular episode the way you did other things here.
Thanks for the video. I am enjoying this well put tutorial from beginning to end. I have a question you might know the answer for. My script doesn't seem to recognize the e parameters neither for the doGet nor the doPost. if I try to log (e) it returns null from the web app. if I try to run doPost() it throws a red error saying: TypeError: Cannot read property 'postData' of undefined (line 7, file "Code") I think something is wrong with my scripts page.
Can I invoke a standalone app script from a Google sheet? I’m the owner of a file, as such I’Ve protected some ranges so that these can’t be edited by others set up as editors However, I also want user editors to be able to run some script that just won’t run if it’s bound to the sheet due to relevant ranges being protected. Should the script be run as me then there would be no problem, right?
Thanks for the info. It's pretty useful! Still trying to work out how to develop a stand alone script for sheets, to be deployed as an add on. How to you test this during production?
Great to hear! To test your script which you are intending to produce as an add-on, simply go to the run menu in your code editor, and click the drop-down "Test as add-on..."
Hi Craig! Yes, a standalone script is created when you press the "New Project" button on your Apps Script dashboard. That was accomplished in Episode 0.3 at around the 2:22 mark. To convert a standalone script into a web app, simply include the functions doGet() and/or doPost() in your .gs file and publish as a web app. Finally, a bounded script is created when you access the script editor through a Google product like Sheets, Slides, etc. Once in one of these products, you'll have to click the menu button "Tools" > "Script Editor". The editor that pops up is a bounded script.
@@DavidWeissProgramming Hey, thanks for the quick and informative reply. I just started writing a simple gs yesterday and found your coverage. I'll start at your beginning video and move forward.
Thanks for putting effort to make these set of videos. Really helpful.
Thanks! I'm quite new at programming. I'm trying to bound an html form to a google sheet but somehow it doesn't. I will continue watching all your videos, because there are just for me, thanks again! awesome work!!
Hi Diego! Thanks for the encouragement! It means a lot :) If your HTML form is hosted on a Google Apps Script Web App, there are many ways you can do this! Check out my videos Episode 3.7 (ua-cam.com/video/XdGY4AcXD38/v-deo.html) and Episode 7.4 (ua-cam.com/video/vGEfzs7oS1s/v-deo.html). If you're hosting your website anywhere else, you will need to use the Google Sheets API (developers.google.com/sheets/api)
Is there a way to run a script living in a standalone file from a google sheet?
Hi, I'd like to create a spreadsheet with a custom sidebar that users can access and use an instance of the spreadsheet but they should not be able to copy it or the code. What would the best way to set this up be? The user will interact with the sheet by changing values on the sidebar only.
You reference "last episode" but I don't see any link to it in the description. Thank for the tut.
Edit: I tried finding it. It is Ep 0.3 but nowhere in the title does it say Standalone Apps like it does here (but its not here!). Also you havent really covered standalone apps in that particular episode the way you did other things here.
Thanks for the video. I am enjoying this well put tutorial from beginning to end.
I have a question you might know the answer for. My script doesn't seem to recognize the e parameters neither for the doGet nor the doPost.
if I try to log (e) it returns null from the web app.
if I try to run doPost() it throws a red error saying: TypeError: Cannot read property 'postData' of undefined (line 7, file "Code")
I think something is wrong with my scripts page.
Can I invoke a standalone app script from a Google sheet? I’m the owner of a file, as such I’Ve protected some ranges so that these can’t be edited by others set up as editors
However, I also want user editors to be able to run some script that just won’t run if it’s bound to the sheet due to relevant ranges being protected. Should the script be run as me then there would be no problem, right?
Thanks for the info. It's pretty useful! Still trying to work out how to develop a stand alone script for sheets, to be deployed as an add on. How to you test this during production?
Great to hear! To test your script which you are intending to produce as an add-on, simply go to the run menu in your code editor, and click the drop-down "Test as add-on..."
You mentioned in this video that standalone script was previously covered. Which video is that 0.3 stops at creating a project. Thanks.
Hi Craig! Yes, a standalone script is created when you press the "New Project" button on your Apps Script dashboard. That was accomplished in Episode 0.3 at around the 2:22 mark. To convert a standalone script into a web app, simply include the functions doGet() and/or doPost() in your .gs file and publish as a web app. Finally, a bounded script is created when you access the script editor through a Google product like Sheets, Slides, etc. Once in one of these products, you'll have to click the menu button "Tools" > "Script Editor". The editor that pops up is a bounded script.
@@DavidWeissProgramming Hey, thanks for the quick and informative reply. I just started writing a simple gs yesterday and found your coverage. I'll start at your beginning video and move forward.