Thursday, October 31, 2013

Google App Script

http://www.google.com/script/start/

Specifically, working through https://developers.google.com/apps-script/quickstart/forms resulted in the following lessons learned:

  1. Whenever you are updating the spreadsheet bound to a form, unbind the form before resetting and rebuilding the form, otherwise, you'll get an error.
  2. Even if you remove the form, the binding persists, and unlinking thereafter won't fix the error.
  3. Lesson learned while examining the Conference Spreadsheet sample in the examples above.
  4. Also don't forget to delete the calId project variable (File | Project Properties | Project Properties tab, from within the script editor).
  5. And delete the calendar from Google Calendar (drop down in cal | Calendar Settings - bottom of page - remove/delete).
  6. Delete the form that's created in the google docs folder.
  7. The PDF created will be placed into the google docs space, so delete it when done... but the email sent has a PDF attachment as well as a link to the doc version of the PDF... so the link will be broken if you delete the google doc.

No comments:

Post a Comment