lcenchew / gsuite-form-upload

G-Suite Google Form setup using Google Apps Script - including file upload

G-Suite Google Form File Upload - Google Apps Script

A simple setup for file upload using the file upload in Google Forms.

Quick Start

• See Using Clasp to login, create or clone a project
• Push code to project clasp push
• For first time only, go to Script Editor to open your project and run createFormSubmitTrigger from createFormSubmitTrigger.js
• Go to the form to create the file upload item to the form. (still unable to add programatically)
• If needed, create other form content by running setupForm from setupForm.js in the Script Editor
• If needed, create a spreadsheet to hold the form responses.

Note: If encounter "do not have permission" issue, run main from the Script Editor to review and approve the authorization.

Clasp

• https://github.com/google/clasp
• https://developers.google.com/apps-script/guides/clasp

Using Clasp

Login the user

clasp login --no-localhost

Create a new Project

clasp create --title "File-Upload" --type forms --rootDir ./src

Clone and work on an existing project

clasp clone "*******" --rootDir ./src

Watch and push code when saved

clasp push --watch

Edit (if need to)

• .clasp.json

"rootDir": "./src"

• appsscript.json

"timeZone": "Asia/Singapore"

other useful commands

Open in the script editor

clasp open

VS Code

Preamble

• Install Docker Desktop if not installed
• Install the Remote Development extension pack in VS Code
• Run Docker Desktop
• Open repo folder with VS Code using Run Remote-Containers: Open Folder in Container...

Container composition

• using this Dockerfile
• FROM mcr.microsoft.com/vscode/devcontainers/typescript-node:12

Gitpod

• Click on this button
• Sign in with yout Github account to start

Container conposition

• FROM gitpod/workspace-full Dockerfile
• FROM buildpack-deps:focal Dockerfile
• Ubuntu Focal based

gsuite-form-upload's Issues

Spreadsheet is removed if form is in the root folder

If the the form is in the root folder and createSpreadsheetDestination is run, the spreadsheet is created and then removed.

Default form item should be deleted

When the form is created with clasp, a default form item is added.
This default item should be deleted before adding more form items with setupForm .