I have a Google form (From_1) that creates a Google doc and another form (Form_2). Form_2 is created from a template that contains its own Apps Script. When creating Form_2, I want to also create an onSubmit() trigger for that form. However, I get an error that states:
Exception: You do not have permission to call ScriptApp.newTrigger. Required permissions:
https://www.googleapis.com/auth/script.scriptapp
My appscript.json looks like:
{
"oauthScopes": [
"https://www.googleapis.com/auth/script.scriptapp"
],
"timeZone": "America/New_York",
"dependencies": {
},
"exceptionLogging": "STACKDRIVER",
"runtimeVersion": "V8"
}
Here is the code I'm using to create Form_2 and my attempt to create the onSubmit() trigger. How can I create a form with an onSubmit() trigger?
// Create job offer form
var templateOfferForm = DriveApp.getFileById('my_form_id_number');
//create a copy of the template, we don't wanna mess up the template doc
var offerForm = templateOfferForm.makeCopy();
//open the new template form for editing
var openForm = FormApp.openById(offerForm.getId());
// Setting title name
openForm.setTitle(items[1].getResponse());
// Setting name in form
offerForm.setName('Job offer form: ' + items[1].getResponse());
// Setting the trigger for the new form
ScriptApp.newTrigger('onFormSubmit')
.forForm(FormApp.getActiveForm().getId())
.onFormSubmit()
.onOpen()
.create();