You are missing some Flash content that should appear here! Perhaps your browser cannot display it, or maybe it did not initialize correctly.
Play with a live Demo and get the code
- Copy the code from the test page.
- Open up the code editor. To do this, go to (or create) a Google Site (within your domain - this script only works within Google Apps domains; make sure your Site is visible to everyone within your domain by clicking the 'Share' button) and click on More > Manage Site > Apps Scripts > Add new script. Paste in the code from step 1. Be sure to delete or paste over any existing lines of code in the code editor.
- From the File menu (or by clicking on the diskette icon), 'Save' the script, giving it a name.
- From the Publish menu, select 'Deploy as web app'. Click 'Save a new version', leave the 'execute the app as' setting to '<your account>' but set the 'who has access to the app' setting to 'anyone within <your domain>'.
- From the Run menu, select the function "doGet". (Click 'OK' if queried for authorization.)
- Return to your Site and refresh the 'Apps Scripts' page. The script's name should now be listed. On any new or existing web page on your Site, click the pencil icon to edit, and from the Insert menu, select 'Apps Script' and select the script. Save the edit. Refresh the page. The first time the page loads, refresh the browser. The first time your page loads, it will generate a copy of my starter spreadsheet to go with the script. If it gives an authorization error, do step 3 again.
- Play around with it. Change the template. Practice the tagging conventions. Build a new chart.
- I only recommend bringing your data into the provided starter spreadsheet once you are comfortable with how it's working.
- Once you have populated the data sheet and template with real values, return to the script and set the TEST_MODE variable to 'false.'
- Try assigning a row of data to your own email address so you can see if it is working in student (non-power user) mode.
- Populate the power user sheet with the emails of people who ought to have that level of access.
Security Note: The script is written to default to an "Access denied" note when a user is not listed in the data sheet or the power user sheet. Nevertheless, I recommend using sharing settings to restrict who can view the Sites page to your specific audience as an added layer of protection.
Push my thinking
rePortlet Script: Individualized data reports in a Google Sites Page
Problem of practice
Cast your vote