Tips and tricks to getting the most out of Google Workspace with Apps Script
ฝัง
- เผยแพร่เมื่อ 5 ต.ค. 2023
- As organizations of all sizes are focused on delivering improved user experiences, the need for agile and adaptable solutions is becoming increasingly apparent. Google Apps Script is a powerful, low-code development platform that makes it fast and easy to create business applications that integrate with Google Workspace.
Tune into the experts to learn Apps Script tips and tricks to combine APIs, automation, configuration as code, and more to improve your productivity using Google Workspace.
Whether you're a seasoned developer or just getting started with low-code development, you'll learn insights and information you need to start building custom solutions with Google Apps Script.
03:51 Automate anything
07:02 Jump right in - quickly create an Apps Script project, get ahead with project templates, etc.
08:31 Let code write itself - use the macro recorder
13:28 Dominate the IDE (integrated development environment)
16:46 Code code - back up your code files, copy script projects, remotely execute functions, etc.
20:29 You can code emoji - add emojis to your UI elements
23:31 Create dynamic menus - drive flexible function calling with minimal code
26:17 Work smarter, not harder - build expertise in arrays to save time, avoid errors, write cleaner
31:16 End endless searches - make finding code easy
33:09 Don't start from scratch - take advantage of Apps Script libraries and resources
36:54 Show link data in Docs - create a link preview card using HTML elements, without an API
39:41 Tailor your triggers - customize the onEdit trigger to run code on the data you care about
42:16 Get hooked on webhooks - send notifications to Chat with just a few lines of Apps Script
45:56 Track your changes with project history
48:11 Save state with properties - save user settings, configurations, and more
50:14 It's OK to ask for help - Bard is a great way to include AI in your Apps Script building process
53:09 Q&A
Link to resources: goo.gle/AS-TIPS
Join, learn, and engage with the Google Workspace Community: goo.gle/gws-community - บันเทิง
This was a great presentation of tips and tricks by a team clearly passionate about Google Apps Script. To me, Google Apps Script is the Flutter of the Google Workspace world. The Classes and Methods are so simple and fast to use providing the best possible framework for developing in Google Workspace.
Hats off to Mike Harm for being the brainchild behind the initial development of Google Apps Script and a huge thanks to Charles for being such a charismatic frontman for Google Workspace and sharing Apps Script with the world, Kara and her team for the docs, and the whole team behind the scene who keep Google Apps Script moving forward and evolving.
Stoked to see my tip included the presentation, thanks! 13:21 😁
Thanks for sharing your excitement for Apps Script 😃
Excellent video, thanks! Dynamic Menu tip is 🔥
Glad it was helpful! 😃
I cant find the code in your google drive from the description...
where is it? BR Eduard
This was brilliant, I learnt so much. Love how it was presented as tips and tricks, and with demos
Glad you enjoyed it! 😃
Thank you for give us those tips and tricks, I didn't know about F1 context menu with the list of commands. I would like to see in a future a friendlier IDE, trying to have the best of some others IDEs such as VScode.
Thanks for watching and sharing your feedback 😃
Thx
Thank you for joining us for this event 😃
re code code. for backups you can copy code out of apps script with clasp, into a git repo.
Thanks for sharing that tip 😃
Hello! I have made many web apps with apps script. But a few hous ago, suddenly it shows this error in console.
This document requires 'TrustedHTML' assignment.
Uncaught TypeError: Failed to set the 'innerHTML' property on 'Element': This document requires 'TrustedHTML' assignment.
and it stopped.
Is it something that Google changed its policy?
I need urgent help.
Can you help me out please?
There is a know issue for this which you can check here: issuetracker.google.com/issues/313466551
Kara's editor as seen at 13:36 has the usual vertical panel with sections labeled Files, Code, Libraries, Services hidden. How is this accomplished?
This is actually done using a bookmark with JavaScript. If you save the following as a bookmark on your bookmarks bar, you can get the same effect: javascript:(function() {const style = document.querySelector('div[jsname="Iq1FLd"]').style;if (style.display == 'none') style.display = '';else style.display = 'none';})()
@@karaireland6729Thanks Kara, that works! On a smaller laptop really that really saves space.
@karaireland6729 Thanks Kara, that works!
Where's the transcript or document with all of the tips & links from the video??
Did you find it? Click the 3 dots, then Show Transcript, then click the chip Show transcript under the video description. It appears on the right side of the screen (for me, at least).
If you're looking for the resources shared in the video, check the description of the video.
ji need devs to partner with us and use our assets to bbuild projects. you profit from projects for liofe