On Open Trigger - Episode 3.2 | Apps Script ~ Script Service
Вставка
- Опубліковано 9 лют 2025
- Hey Coders! When you need to run a function every time a user opens a Sheet, Slides, Doc, or Form, name it onOpen. This trigger will work miracles in customizing your files so your end-users get a personalized experience.
Check out the source code on GitHub:
github.com/dav...
Apps Script Documentation: developers.goo...
🎙️ Help me get a new Microphone! gofund.me/67b2...
❤️ Support the ongoing growth of this channel! / davidweissprogramming
🧑💻 Apps Script Documentation: developers.goo...
----------------------------------------------------------------------------------------------
Other playlists:
App Engine:
• Google Cloud - Season ...
Google Cloud Orientation:
• Google Cloud - Season ...
Utilities Service:
• Apps Script - Season 1...
Properties Service:
• Apps Script - Season 1...
URL Fetch Service:
• Apps Script - Season 1...
Drive Service:
• Apps Script - Season 1...
Forms Service:
• Apps Script - Season 9...
Lock Service:
• Apps Script - Season 8...
HTML Service:
• Apps Script - Season 7...
Document Service:
• Apps Script - Season 6...
Slides Service:
• Apps Script - Season 5...
Calendar Service:
• Apps Script - Season 4...
Script Service:
• Apps Script - Season 3...
Gmail Service:
• Apps Script - Season 2...
Spreadsheet Service:
• Apps Script - Season 1...
Apps Script Orientation:
• Apps Script - Season 0...
----------------------------------------------------------------------------------------------
David, your channel is GREAT !!! You explain very well, thanks for your knowledge, the best google spreadsheet channel greetings from Argentina
Helpful video! Gave me what I needed in the first 3 minutes.
David this channel is amazing, super clear and friendly.
Question: I'm creating an installable trigger which I want to create programmatically onOpen. The problem is that the authorization does not popup as the function setUpTrigger fires. The trigger is created but still it needs authorization. So it wont fire at the specified events. I need to go to my triggers on script.google.com/home/triggers, open the trigger and save it, for it to be authorized.
How can I prompt the authorization to open on the document ?
Thank you very much for this channel
Hi Rodrigo! Thanks for the kind words. Yes, I do plan on making another video within this playlist on how to prompt a user of a document with an authorization dialog if it is necessary to run a script in the backend. That will be my episode 3.9, so stay tuned! However, I was curious to hear that your own authorization dialog did not automatically appear when you were setting up the trigger. I tried to recreate the problem on my side but as soon as I run the function to create the trigger, I get a dialog requesting authentication. If you want to post your code here, I'll take a closer look to see what's going on.
how to auto refresh on importhtml table data?