Questions tagged [google-forms]
Questions related to interacting programmatically with the Google Forms service through the internal api or the external api. A language tag should also be included, e.g. [google-apps-script], [python]. Questions about general use of Google Apps should be posted on Web Applications Stack Exchange.
google-forms
3,233
questions
1
vote
0
answers
8
views
How to Create a Google Form with Dependent Dropdowns Using Google Sheets and Apps Script
I am setting up dynamic dropdown fields in a Google Form, where one dropdown's options depend on the selection made in another dropdown, using Google Sheets and Apps Script. My church choir has 8 ...
-2
votes
0
answers
13
views
Can’t save my form because of schema exceeding the choice limit
When I try to save my form I get this notification and it won’t allow me to, even though I was previously able to save it without any difference in my form - I do not know what it wants from me or how ...
0
votes
0
answers
18
views
Creating a fillable table on Google form to collect date reports
I need to collect reports from 150+ agencies on their performance per month. The form that I need they to fill in looks like this. I would like do this on Google Forms as I need the link to be ...
-1
votes
0
answers
35
views
doPost not working when a google form is sent [closed]
I am trying to automate my mail management.
I created a google form to add new participants on my mailing list. The form code is the following :
var formFile = DriveApp.getFileById('MyId');
var folder ...
0
votes
1
answer
36
views
How to solve error TypeError: Cannot read properties of undefined (reading 'response') onFormSubmit @ Code.gs:3
I faced an error when I build up google script for google form the purpose from the script only that if the birthdate that entered from the form is after 1-Oct-2020 stop submitting form after I finish ...
-1
votes
1
answer
43
views
Script to manipulate Google Form data
I have a Google Form that outputs responses to a Google Sheet. I would like to learn how to write a script that manipulates the data before saving the response to the sheet.
Basically, I have a few ...
1
vote
1
answer
27
views
Insert multiple choice questions and shuffle choices for Google Forms
I took the content of the choices from Google Sheets, then randomly mixed them and put them into the options of a Multiple Choice question in Google Forms. The code is as follows:
// Function to ...
-1
votes
0
answers
43
views
I want to send the Google Forms response with the same question to a specific/single column. How do I do it?
I created a google form that has a lot of sections to go based on first section's answer. When I submit the responses, it created a lot of columns with the same questions (since it has a lot of ...
0
votes
0
answers
28
views
How to Use Multiple Types of Questions in Google Forms
I want to add a textQuestion type reponse to have a feed back of the user but I got this error:
raise HttpError(resp, content, uri=self.uri)
googleapiclient.errors.HttpError: <HttpError 400 when ...
0
votes
2
answers
63
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
49
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 ...
-1
votes
1
answer
34
views
Can't see who answered questionnaire. email addresses not populated
I created a questionnaire in google forms. I required email address be collected. when I went to look at the responses, it shows the responses but no names or email addresses are attached even with a ...
0
votes
1
answer
41
views
JavaScript function in Google spreadsheets to send QR codes to emails
We are planning for an event, to register you have to fill out a Google form, after filling it there is this function in the "Apps Script" of the spreadsheet that will generate and send a QR ...
0
votes
0
answers
22
views
Reading values from 'Google form' is undefined [duplicate]
I wrote a code in App Script and connected it to a form on the Google Forum
Now the problem is that I can't read the data from the fields in any way.
I keep getting 'undefined' errors
Like: TypeError: ...
-2
votes
0
answers
47
views
Sending Google Sheet with Forms update
I'm using Forms to get requests from employees. I know how to get the Form by email, but I would like to get the Google Sheets or a PDF with the answers calculated and put in the right format.
...