Google Form Reader (Google Apps Script)

README.md

Google Form Reader

A google apps script that reads metadata from an existing Google Form.

Prerequisites:

Set a script property called FORM_ID using the File menu.

Usage

Paste the contents into a new window and run.

CREDITS.md

Credits, Notes, References

• https://developers.google.com/apps-script/overview
• https://developers.google.com/apps-script/reference/forms/
• https://developers.google.com/apps-script/reference/forms/form-app
• https://developers.google.com/apps-script/reference/forms/form
• http://stackoverflow.com/questions/24721226/how-to-define-global-variable-in-google-apps-script/24750489#24750489
• https://developers.google.com/apps-script/guides/rest/

get_form_metadata.gs

function getFormMetadata(){
  Logger.log('MY EMAIL --> ' + Session.getActiveUser().getEmail());


  var formId = PropertiesService.getScriptProperties().getProperty('FORM_ID'); // http://stackoverflow.com/a/24749707/670433
  var form = FormApp.openById(formId);

  Logger.log("CONF MESSAGE --> " + form.getConfirmationMessage())
  Logger.log("CUSTOM CLOSED FORM MESSAGE --> " + form.getCustomClosedFormMessage())
  Logger.log("DESCRIPTION --> " + form.getDescription())
  Logger.log("DESTINATION ID --> " + form.getDestinationId())
  Logger.log("DESTINATION TYPE --> " + form.getDestinationType())
  Logger.log("EDIT URL --> " + form.getEditUrl())
  Logger.log("EDITORS --> " + form.getEditors())
  Logger.log("ID --> " + form.getId())
  // Logger.log("______ --> " + getItemById(id))
  Logger.log("ITEMS --> " + form.getItems())
  // Logger.log("______ --> " + getItems(itemType))
  Logger.log("PUBLISHED URL --> " + form.getPublishedUrl())
  //Logger.log("______ --> " + getResponse(responseId))
  Logger.log("RESPONSES --> " + form.getResponses())
  //Logger.log("______ --> " + getResponses(timestamp))
  Logger.log("SHUFFLE QUESTIONS --> " + form.getShuffleQuestions())
  Logger.log("SUMMARY URL --> " + form.getSummaryUrl())
  Logger.log("TITLE --> " + form.getTitle())
  Logger.log("ONE PER USER? --> " + form.hasLimitOneResponsePerUser())
  Logger.log("PROGRESS BAR? --> " + form.hasProgressBar())
  Logger.log("RESPOND AGAIN LINK? --> " + form.hasRespondAgainLink())
  Logger.log("ACCEPTING RESPONSES? --> " + form.isAcceptingResponses())
  Logger.log("PUBLISHING SUMMARY? --> " + form.isPublishingSummary())

}