Google Sites - tbd‎ > ‎How To...‎ > ‎

Add comments or other content using a form - tbd

Contents

  1. 1 Announcement Page Submission Form
  2. 2 Comments on a Page Submission Form
  3. 3 Setting up the Form
  4. 4 Initiating the OnFormSubmit trigger
At the moment, 'comments' on a Google Sites page can only be added by Site editors or owners. It is a common requirement to be able to allow people to add comments or other content to a Google Sites website without giving them 'Can Edit' or 'Owner' access. 
(See also New commenting system )

One good technique that meets most people's needs, is the embedded Form and Spreadsheet technique described by Raveen and Steegle
Using this technique, the comments appear in a spreadsheet that may be embedded in a page.

Similar, but better looking, is the comment form and board developed by Mori
Other options are Disqus and Pnyxe. Examples of these commenting systems are shown here

The form and script described on this page have been developed to enable the submission of Announcements and/or Comments via an embedded Google form. The difference between this technique and those above is that the end result is that the comments end up in the comments section at the bottom of a page or, if you are using it with an Announcements page, as Announcements. 

Announcement Page Submission Form

(Enter something on this form and goto this page to see the results)

Announcement Page Form

Comments on a Page Submission Form

(Enter something on this form and goto this page to see the results)

NB: The new commenting system introduced by Google on Sept 20th has broken the script so sadly it no longer works for comments. And until Google make some changes it cannot be mended

Comment Form


Setting up the Form

The spreadsheet form and script that drive the forms above can be copied by using the Spreadsheet template 'Google Sites Data Submission Form'. 

Initiating the OnFormSubmit trigger

You have to open the "Script editor" because you need to tell Google that you want the script to be run on every form submit - the script can't do that by itself.

Click on "Tools" > "Script" > "Script editor..."

At the new window, click on "Triggers" > "Current script's triggers"

Now click the blue link: "No triggers set up. Click here to add one now."
Confirm that "aaaFormSubmission" function is selected then, at the "Events", select "From spreadsheet" - "On form submit"

Click "Save", close the "Script editor" window and you're done!