Scribd
Upload
23 views2 pages

Google Form Limiter Setup Guide

This document defines functions to programmatically control a Google Form using triggers. It sets open and close dates to automatically start and stop accepting responses. It also checks the response count and closes the form if the limit is reached. Functions are defined to initialize triggers based on the dates, delete existing triggers, and notify the form owner by email when the form status changes.

Uploaded by

wildanbizshop
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
23 views2 pages

Google Form Limiter Setup Guide

This document defines functions to programmatically control a Google Form using triggers. It sets open and close dates to automatically start and stop accepting responses. It also checks the response count and closes the form if the limit is reached. Functions are defined to initialize triggers based on the dates, delete existing triggers, and notify the form owner by email when the form status changes.

Uploaded by

wildanbizshop
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

FORM_OPEN_DATE = "2014-12-20 08:00";

FORM_CLOSE_DATE = "2014-12-25 23:30";


RESPONSE_COUNT = "100";

/* Web tutorial: [Link] */

/* Initialize the form, setup time based triggers */


function Initialize() {

deleteTriggers_();

if ((FORM_OPEN_DATE !== "") &&


((new Date()).getTime() < parseDate_(FORM_OPEN_DATE).getTime())) {
closeForm();
[Link]("openForm")
.timeBased()
.at(parseDate_(FORM_OPEN_DATE))
.create();
}

if (FORM_CLOSE_DATE !== "") {


[Link]("closeForm")
.timeBased()
.at(parseDate_(FORM_CLOSE_DATE))
.create();
}

if (RESPONSE_COUNT !== "") {


[Link]("checkLimit")
.forForm([Link]())
.onFormSubmit()
.create();
}

/* Delete all existing Script Triggers */


function deleteTriggers_() {
var triggers = [Link]();
for (var i in triggers) {
[Link](triggers[i]);
}
}

/* Send a mail to the form owner when the form status changes */
function informUser_(subject) {
var formURL = [Link]().getPublishedUrl();
[Link]([Link]().getEmail(), subject, formURL);
}

/* Allow Google Form to Accept Responses */


function openForm() {
var form = [Link]();
[Link](true);
informUser_("Your Google Form is now accepting responses");
}

/* Close the Google Form, Stop Accepting Reponses */


function closeForm() {
var form = [Link]();
[Link](false);
deleteTriggers_();
informUser_("Your Google Form is no longer accepting responses");
}

/* If Total # of Form Responses >= Limit, Close Form */


function checkLimit() {
if ([Link]().getResponses().length >= RESPONSE_COUNT ) {
closeForm();
}
}

/* Parse the Date for creating Time-Based Triggers */


function parseDate_(d) {
return new Date([Link](0,4), [Link](5,2)-1,
[Link](8,2), [Link](11,2), [Link](14,2));
}

You might also like