You've created a Google Form and you've embedded the Google Spreadsheet of responses into your blog, website, etc. Awesome. The only problem is... it won't automatically republish whenever someone fills out the Google Form. Google was kind enough to place a checkbox for this feature, but only manual updates to the Google Spreadsheet will automatically republish. Unfortunately it currently doesn't republish if your spreadsheet is being updated via Google Forms.

How can we fix this? We are going to create a script that will automatically make a small manual update to the spreadsheet.

First of all, click the File menu, then Publish to the web..., and make sure that you have a check next to Automatically republish when changes are made.

Next, click the Tools menu and then Script editor...

You may get a pop-up wizard that says "Google Apps Script" and has links to tutorials. You can just close this.

Add the following code:

function ChangeIt() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  var t = new Date();
  var x = 'upd: ' + t;
  var range = sheet.getRange('f1');
  range.setValue(x);
}

Where I have sheet.getRange('f1'), you may need to change f1 to the name of some other empty cell.

Save your script and name it something like autorepublish or republishme.

Click on the little clock icon.

You will get a pop-up that says "No triggers set up. Click here to add one now." Go ahead and click to set up a trigger.

There are two possible ways to set up your trigger...

• Run ChangeIt, From spreadsheet, On form submit
• Run ChangeIt, Time-driven, Minutes time, Every minute

If you'd like, you can even click Add a new trigger and use both of those triggers.

Save your current project's triggers. You will next need to authorize the app. The pop-up will say, "This app would like to: View and manage your spreadsheets in Google Drive." Click Accept.

Close your script and go back to your Google Spreadsheet. Click the Tools menu and then Script Manager... You should see ChangeIt listed here. Press the Run button to test it out.

About seven years ago I wrote a song called Funeral. That song has inspired Jon Kovach (an actor, musician, director, writer, and producer from Cincinnati) to write a play called THE FUNERAL.

In the play, Luke is hiding out in his bedroom because he doesn't care about his great grandmother's funeral happening in his parent's living room downstairs. His beautiful cousin, conflicted immediate family, and eclectic friends all visit Luke, each with their own scheme to lure him out of his bedroom. Will Luke venture downstairs, or will his parents follow through with their threat to bring his great grandmother up?

Jon is writing/directing THE FUNERAL as part of Serials! happening throughout the summer at Know Theatre of Cincinnati. As the name Serials! implies, the play is being presented in six parts: June 23rd, July 7th, July 21st, August 11th, August 25th, and September 8th. The cast includes Jared Earland as Luke, Tara Williams as Luke's mom, Becca Howell as Luke's cousin Erika, and Annie Kalahurka as Luke's sister Leslie.

Blogger Kirk Sheppard wrote, "Kovach’s piece is sharp, funny, and professional. Tara Williams, who plays the mother, is as good an actress as anyone in town and this piece seemed like the start of a pretty well developed series. I’m excited to see where it goes."

David Lyman of the Cincinnati Enquirer wrote, "[THE FUNERAL] is the smartest and best-crafted offering of the entire evening."

Behind The Curtain Cincinnati wrote, "[A] smart, tightly-written and emotionally true script. Kovach packs alot into just 15 minutes without it feeling too dense or hurried. Definitely intrigued by the big question of the son’s reluctance to attend the funeral being held downstairs."

The following Polaroid cameras can use the Fuji Packfilms: FP-100c and FP-3000b

Folding Pack Cameras:
100 Series: Automatic 100, 101, 102, 103, 104, 125, 135
200 Series: Automatic 210, 215, 220, 225, 230, 240, 250
300 Series: Automatic 315, 320, 325, 330, 335, 340, 350, 355, 360, M60,…
400 Series: Automatic 420, 430, 440, 450, 455, Countdown 70, Countdown 90
Pro Models: 180, 185, 190, 195
New Style Folding Cameras: EE100, EE100 Special, The Reporter, ProPack

All plastic Body:
Big Swinger, Colorpack II, Colorpack III, BigShot, Colorpack IV, Colorpack M6, Colorpack V, Minutemaker, Minutemaker Plus, Super Colorpack, Super Shooter