All Questions
148 questions
1
vote
1
answer
111
views
Capturing Google Form data as it gets filled [duplicate]
How can I capture Google form data entered in any section immediately upon clicking the Next button to move on to the next section (before submitting the form)?
Specifically here I wish to capture the ...
- 509
-5
votes
1
answer
178
views
Google Apps Script for OTP Generation [closed]
I tried using a google apps script attached to a google form to generate a one-time password.
The script intends to make the respondent fill out the email id, leaving the OTP field blank. The submit ...
- 509
-1
votes
1
answer
66
views
Google Apps Script for inserting data onformsubmit is executing, but not inserting any data
I'm trying to reactivate scripts in Google Sheets which broke when my colleague's account got deactivated. He created them. They functioned before he left.
Now, these only work when I manually submit ...
- 7
1
vote
2
answers
135
views
What am I doing wrong with event objects in google apps script?
Maybe i'm misunderstanding how event objects work, but i've been following a tutorial on how to get google forms to send a pdf every time the form is submitted. This led me to the function ...
- 15
0
votes
1
answer
43
views
Forms data gathering, Conversion and forwarding
I'm a beginner and I'm trying to create an automation for our org. The set up of the automation is when ever an entry has been submitted via forms the API function will then gather the data from the ...
0
votes
2
answers
128
views
Form submitted file MailApp
I cant figure out how to get a file that is submitted in a form to send as a email.
function onFormSubmit(e) {
var responses = e.response.getItemResponses();
var fileItem = responses[1]; // ...
0
votes
1
answer
82
views
Based on a Google Form Submitter's name, create a folder, rename the files and relocate those files to that created folder
I am trying to create a Google Apps Script that allows me to do the following.
My Google Form looks like this:
What is your company name.
Submitt your company logo.
Submitt your company photo.
...
- 11
0
votes
1
answer
74
views
Why doesn't this onChange script run when a Google Forms response is added to the Google Sheet?
I have a Google Form that records an expense into the expenses sheet in a Google Sheet. Following this guide, I created this script that is supposed to send me an email with a value from another sheet ...
- 4,635
0
votes
0
answers
39
views
Google app script form submit trigger throws a message This trigger has been disabled for an unknown reason [duplicate]
I am creating a google form add on , and i created a trigger on form submit , but for some reason it says "This trigger has been disabled for an unknown reason."
I tried using app script ...
0
votes
1
answer
106
views
Google Forms Script to save txt files on Google Drive
I need help with a script to save each response from a Google Form in a separate TXT file in my Google Drive. I'm stuck at line 3: I'm getting an error in var responses = e.values
Debug:
TypeError: ...
0
votes
0
answers
34
views
Google Forms Apps Script FormSubmit not passing e.values [duplicate]
I have a very simple form which I would like to use Apps Script to process data from. I have created the form and a trigger which fires an Apps Script function. However, when I try to access the &...
- 425
-1
votes
1
answer
57
views
Autofill Google Doc From Form not working; GSheet also stops updating new form responses
I want to automatically copy incoming Google Form responses to a Google Doc. For this, I followed Jeffrey Everhart's tutorial step by step. I then tried submitting a new response, but no Google Doc ...
0
votes
1
answer
52
views
Cannot get form response in onFormSubmit as it reads as undefined
When I try and get a form response from onFormSubmit(e), it returns {"authMode":"FULL","response":{},"source":{},"triggerUid":"604XXXXX"}, ...
- 3
0
votes
2
answers
73
views
How can I make a script to delete multiple instances of text?
I have a form which will generate a letter once submitted based on the Google form submission.
One of the questions has three outcomes and depending on the entry, it will delete either one line, or ...
0
votes
2
answers
64
views
Google script not sending email
I have a google script to use a form submission to fill out a document, then convert it to a PDF and save the PDF, then email it out to 2 emails. One is to the respondent whos email is on the google ...
- 175