Me on twitter
Categories
Literary

Entries in Sites Services (2)

Monday
Mar212011

Displaying the Contents of a Google Docs Collection using the Tree UI Widget in Google Apps Script

The following script can be used to generate a tree view of a Google Docs Collection in Google Sites on the fly. Very useful for displaying contents of large Google Docs Collection on a Google Sites page.

Saturday
Mar122011

Google Apps Script File Upload UI Service Demo

In this script, we will use the Google spreadsheet to keep track of files uploaded to Google Sites' File Cabinets. There are four parts to this script:

 

  1. Creating a File Upload form using the Google Apps script UIApp and the FileUpload UI
  2. Adding a button to invoke the form from the Google Spreadsheet File Menu
  3. Using the Sites Service to store the uploaded file to the Google Sites' File Cabinet
  4. Using the Spreadsheet Service to save the URL to the Uploaded File in the active spreadsheet cell.