Hi, this is working great. I want to send user to some other website on Submit... basically - if someone submits - the person should redirect to my website. How can I do that with this?
Hi! Make sure you've set up a trigger on your own spreadsheet (change the spreadsheet ID for the method "forSpreadsheet" to match your own spreadsheet ID). Then run the function "setUpTrigger" just once. Once the trigger has been activated, don't run the function "timestamp" from the code editor, it will run automatically once you edit the the spreadsheet. If you try to run it from the code editor, it will say your range is undefined since nothing is being edited on the spreadsheet. Let me know if you run into any other problems! :)
hi thanks for the tutorial. could you possibly update on how onEdit trigger works now? i copied this line for line and get an error message when "Run" that says: "TypeError: Cannot read property 'range' of undefined onEdit" if however i don't run this, and just "save" it, the trigger does nothing. googled and can't find any solutions as well. any help would be greatly greatly appreciated! thanks!
Hi Norman! Thanks for watching my video and commenting! First, make sure you set up the trigger on your own spreadsheet! Then, you only need to run the "setUpTrigger" function. Once the trigger is activated, the function "timestamp" will run automatically! If you try to run the function "timestamp" from the code editor, it will error out since nothing on the Spreadsheet is being edited. Does that make sense? Make sure the trigger is set up, and then test it by editing the spreadsheet. :)
@@DavidWeissProgramming hi! thanks for your reply! i actually found out the source of my error. basically simple triggers will not work if i didnt use the method .getActiveSpreadsheet() i used .openById() instead. love your videos; cheers!
Hey You can click on insert>drawing>draw any shape/enter text/okay Now right click on the drawing and select - script > type the name of the script/okay Now everytime you click on the drawing it triggers your funciton
Thank you so much. I have been googling for so long but couldn't find any tutorial on how to actually install a trigger from a standalone script.
Can we use this on auto-update spreadsheets like a spreadsheet linked with a google form?
I am not able to execute the below code on the spread sheet edit, can you help me please
Hi, this is working great. I want to send user to some other website on Submit... basically - if someone submits - the person should redirect to my website. How can I do that with this?
If data sheets start from Column C then what script i write? Please help me. I want it badly.
When I copy and paste the script which I have set on a different sheet to a new sheet it does not want to work. Any advice
Nice! but range is undefined in my script. Any suggestions?
same, did you find a solution?
Same, here.
Hi! Make sure you've set up a trigger on your own spreadsheet (change the spreadsheet ID for the method "forSpreadsheet" to match your own spreadsheet ID). Then run the function "setUpTrigger" just once. Once the trigger has been activated, don't run the function "timestamp" from the code editor, it will run automatically once you edit the the spreadsheet. If you try to run it from the code editor, it will say your range is undefined since nothing is being edited on the spreadsheet. Let me know if you run into any other problems! :)
Hi there, could you make a tutorial to auto reload a page in AppsScript after a cell data is changed in Spreadsheet?
Thank's, It worked for me event I did some modification as I need.
hi thanks for the tutorial. could you possibly update on how onEdit trigger works now? i copied this line for line and get an error message when "Run" that says:
"TypeError: Cannot read property 'range' of undefined
onEdit"
if however i don't run this, and just "save" it, the trigger does nothing.
googled and can't find any solutions as well. any help would be greatly greatly appreciated! thanks!
Hi Norman! Thanks for watching my video and commenting! First, make sure you set up the trigger on your own spreadsheet! Then, you only need to run the "setUpTrigger" function. Once the trigger is activated, the function "timestamp" will run automatically! If you try to run the function "timestamp" from the code editor, it will error out since nothing on the Spreadsheet is being edited. Does that make sense? Make sure the trigger is set up, and then test it by editing the spreadsheet. :)
@@DavidWeissProgramming hi! thanks for your reply! i actually found out the source of my error. basically simple triggers will not work if i didnt use the method .getActiveSpreadsheet()
i used .openById() instead.
love your videos; cheers!
Hi, is there any way to run a script by clicking on a Hyperlink?
Hey
You can click on insert>drawing>draw any shape/enter text/okay
Now right click on the drawing and select - script > type the name of the script/okay
Now everytime you click on the drawing it triggers your funciton
thank you.
why log this:Exception: You do not have permission to call ScriptApp.newTrigger.