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
- In an Apps Domain Google Site (sorry, works for Apps Domains ONLY), go to "More->Manage Site->Apps Scripts->Add new script" and copy and paste the script below into the script editor.
- Be sure to delete or paste over any existing lines of code in the code editor.
- Run the function "doGet" and authorize the script to run as "any domain user."
- Save the script with a name you will recognize later
- Create a Sites page or use an existing Sites page and insert an Apps Script Gadget.
- Insert->Apps script gadget
- You will see the script listed. Select it.
- Adjust the pixel dimensions, title, and settings as needed. You can eliminate the gadget border if you want.
- 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