Intake form for the submitter to create a workspace
Google Forms have a Script Editor where you need to inject the code from the google-form
.
The code is in gs
format, which is loosely based on JavaScript.
The service account will be automatically created [email protected]
and used for deployment.
Complete this setup on the account that you want error messages to report to.
NOTE: Create the Cloud Function in GCP to get the HTTP URL before proceeding
-
Link the GCP project to send the form answers to in the settings section
- In general settings, check the 'Show "appscript.json" manifest file in editor'
-
Add the code from the
google-form
folder into the files section of the Editor- Change the
URL
variable to the HTTP trigger for the Cloud Function
- Change the
-
In the Triggers tab, add a Trigger with the following settings
- "Choose which function to run":
onSubmit
- "Choose which deployment should run":
Head
- "Select event source":
From form
- "Select event type":
On form submit
- "Choose which function to run":
- Responses are parsed based on the question name You may add descriptions to assist the users, but changes to the questions will require code refactoring
- Due to Google Form limitations, submissions with more than 8 cohorts will require manual review
- The form requires submitters to have access to the GCP project through IAM roles or they will not be able to create workspaces