Home‎ > ‎

Google Apps Scripting

Examples 1 - 5  Scripting in spreadsheets
   
Make a copy of the scripting examples spreadsheet from here.
  Example 1:
  • Learn to start the script editor and run a script. 
  • Take input from the user. Store it in a spreadsheet.
  • Do a calculation on the input. Store result in a spreadsheet and output it to the user.
  Example 2:
  •  Learn to add a menu choice to a spreadsheet to run a function
  Example 3:
  • Learn how you can send emails from a spreadsheet with data in it.
  Example 4:
  • You can access google docs too!
  • Learn how to search your google docs and return the matches to your spreadsheet
  Example 5:
  • Learn about executing a function based on a trigger such as when a form is submitted or a time driven event


Example 6 Scripting and Google Sites

Scripting on a Google Site



Next Steps:


    Creating you own user interface in a spreadsheet - step by step
            

   You also can create a user interface on a site page have the data submitted to a spreadsheet.
   The following example does not work but it does show how you can create a customized user interface - an upgrade to a form.
 
Pats In Progress User Interface on a Site



Resources:

Guide for Apps script: http://code.google.com/googleapps/appsscript/guide.html
Examples of Apps Script: http://code.google.com/googleapps/appsscript/articles.html
Google Script Expert Site with examples especially for UI services: http://sites.google.com/site/scriptsexamples/home
I want to learn more javascript: http://www.w3schools.com/js/default.asp