Join Scott Simpson for an in-depth discussion in this video Working with the online integrated development environment (IDE), part of Up and Running with Google Apps Script.
- The Google Apps Script editor…provides an integrated environment…to develop and run your script.…To get started, go to script.google.com…and sign in to your Google account.…When you first come to the editor,…you'll see a pop-up with some options for creating scripts…and some handy tutorials that I encourage you to check out…if you're interested.…There's also a section for recent projects as well.…For right now, I'll click on Blank Project.…Right up here at the top of the window,…I can set the project name.…
I'll call this one First Project…and then I'll press OK.…Below the project name is the menu bar…with options you're probably pretty familiar with.…The File menu gives you some options…for creating new scripts,…working with other files,…checking out the revision history,…sharing the project and checking out the project properties.…Under the Edit menu, you've got…Select all and Find and replace…and a couple of convenient options at the bottom for…word completion,…content assist which we'll see in a little bit,…
First, learn how to use simple scripts to edit documents and spreadsheets, work with files in Drive, and find and send messages in Gmail. Then find out how to add custom functionality to your spreadsheets, and build user interface elements for your scripts, using menus, alerts, and dialogs. Finally, Scott shows how to share your work with others by publishing scripts as web apps.
- What is Google Apps Script?
- Understanding script types
- Logging and debugging your scripts
- Scripting common tasks
- Building custom spreadsheet functions
- Creating add-on functionality such as dialogs and sidebars
- Sharing your script as a web app
Skill Level Beginner
Q: The OpenWeatherMap API is not working, or the call returns a 404. What do I do?
<div>A: OpenWeatherMap now requires you to use a free API key (or APPID) when requesting information. You'll need to register for a free key at <a target="_blank" href="http://home.openweathermap.org/users/sign_up">http://home.openweathermap.org/users/sign_up</a> and then add the APPID parameter and your key to the end of the request URL.</div><div> </div><div>So, your request string "api.openweathermap.org/data/2.5/weather?zip=94040,us" would become "api.openweathermap.org/data/2.5/weather?zip=94040,us&appid=abc123abc123" (using your APPID/API key).</div><div> </div>