Google Forms is an integral part of the Google editors' suite. Its use is to collect responses. It can work with or without Google Sheets.

learn more… | top users | synonyms

2
votes
2answers
41 views

Is there a way to prevent oversubscription using Google Forms

I am in a team of people organising an event. . So in the picture, for the first session, each person only attends one of the strands and not both. I would like to know if there is a way of ...
0
votes
0answers
24 views

OnSubmit function, Google Forms and Google Apps script

If the number of rows increases, does retrieving a particular value using the below getValue function performs slower? Is there a better and more efficient way instead of retrieving a single Value ...
1
vote
1answer
499 views

Apply custom CSS styles to Google Forms

Google forms are presented for the user to embed in his/her website as an iframe, which means they can't be styled by the website's own CSS. How can a Google Form be inserted into a website with a ...
2
votes
1answer
22 views

How to change position of column form responding sheet after add form item

I can add an item to a Google form and to change its position in the form by Google apps script. The corresponding column in the responding sheet is always the last column. I can manually move that ...
1
vote
0answers
19 views

Porting Google Form answers to GitHub and generate link

I'm trying to generate files using user input on my Google Form, and send it to GitHub while providing the user a link to the newly created GitHub file. I suppose one can do it by asking for the user'...
1
vote
1answer
39 views

How to save logic branching in lines, not in columns

Is there any way to save new information that comes from logic branching questions into new lines, instead of new columns? I'm trying to have something like this on my Answer Spreadsheet: Provider - ...
2
votes
1answer
26 views

Copy submitted form data to new automatically generated Google sheet

I have created a new sheet for every new name entered in the form using the following code. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; SpreadsheetApp.getActiveSpreadsheet()....
1
vote
1answer
18 views

Auto-create and name new sheet in Google sheets from names being filled from a google form

How can I automatically create and name new sheets in a google spreadsheet from a list of name which are being input in the sheet from a google form.I would like each new sheet to be created when a ...
3
votes
2answers
847 views

How to delete a single answer in Google poll/survey

I started a survey with Google form. Everything is fine. But one Answer was accidentally given twice. As I understood, there are two locations of the answers. Internal, of the form and a copy of each ...
0
votes
0answers
12 views

Create dynamic form with data from a spreadsheet

I'm trying to create a form that collects the questions from a spreadsheet dynamically. Example Table: Name Number Age Don yes no Andy no yes Marry yes yes The ...
0
votes
0answers
15 views

Is there a way to get the summary section from a form into a Google Doc

I've got a survey using Google Forms and it has useful graphs in it's summary section (under responses). How can I get these graphs into a Google Doc? I tried downloading the CSV file and recreating ...
1
vote
0answers
23 views

Is there a script to draw a list of variables from a table to Google Forms?

I would like to have a field in Google Forms that allows the user to select a value from a "List" of values. The options in the list being drawn from a list in the sheet itself. This allows me to add ...
2
votes
1answer
52 views

Sending emails onSubmit using Google Apps Script Web Forms

Is it possible to send emails onSubmit() with Google Apps Script Custom Web Forms just like we can do using mailApp with Google Forms? I am currently transferring google forms code into html forms ...
0
votes
1answer
23 views

How do I add a field in Google Forms to show the sum of multiple fields (that are numbers)

Say for instance I want the user to input into 4 fields the meters they will dig up in different areas. On the form itself I would like to have a number at the bottom displaying the sum of 3 of said ...
1
vote
0answers
28 views

Google Forms - Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
0
votes
0answers
22 views

One form submit produces two updates to spreadsheet

I have an application in which a user submits a form, the data are logged in a spreadsheet, the form submit triggers a script that records the new data and deletes any previous form responses from ...
3
votes
2answers
381 views

How to limit one response per email for Google Forms

I am creating a survey in Google Forms and I'm going to that use inside our organization. I am going to send the form link to everybody inside organization using their internal email. The form will ...
2
votes
1answer
98 views

Combining data from two columns to one (in separate rows - not comma separated) and removing blank lines

I have a Google Sheet which receives information from a google form. I would like to collate some of this data in a separate sheet (within the same document). I would like the new sheet to combine ...
1
vote
1answer
15 views

Completing survey on Google Forms without a Google account

I have created a survey using Google Forms and need to send to University staff. How can I restrict to only one response per person without survey group having a Google account?
3
votes
1answer
42 views

Import only those cells from a spreedsheet that have certain conditional formatting

I have created a Google form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created a conditional formatting which highlights the ...
0
votes
0answers
16 views

Separate Google Forms checkbox responses into individual rows

I would like to use Google Forms to record events that students participate in. How do you separate Google Form responses so that that data goes into individual rows to then use vlookup to find the ...
0
votes
2answers
60 views

“Select Users from organization” field with Google Forms?

So here is my scenerio, I have a Google form that allows users to send a co-worker a digital greeting card, but they have to manually enter the email address of the person they are sending it to. The ...
0
votes
0answers
17 views

Scroll up to the success message once the embedded Google form is submitted

How to scroll up to the success message once the embedded Google form is submitted, so that the user sees the message? I have a height of about 2000px and when it's done the submitted message is out ...
1
vote
1answer
46 views

How do Google Forms handle the “Other” field in Multiple choice/Checkboxes/Drop-down questions?

We use the "Other" option on our multiple choice questions but get inconsistent results recorded for the field on both the form "Responses" tab and the connected spreadsheet as well. There seems to ...
6
votes
1answer
150 views

How to create a question in Google Forms that allows two distinct answers?

I have a question like this (it's a DISC test, if this matters): 1. From the following list, which option is 100% you and which option is 0% you? a. tall b. fat c. happy d. unemployed How can I ...
4
votes
5answers
6k views

Importing responses into a Google Docs Form (spreadsheet)

I have some Google Docs Forms and I would like to import legacy survey data into the responses spreadsheet, so as to benefit from the data presentation features (having the combined data set) but I've ...
-1
votes
1answer
62 views

Is it possible to show answer based on results in google forms

I want to make a troubleshooting tool where the customer could answer the questions and in the end get the suggestion on how the problem could be solved.the questions are dependent. So if you choose ...
1
vote
1answer
79 views

How to increase Google Forms content width?

I have a google form for which I have some grid questions, using long labels. This implies that some of the questions are shown with scroll bars I do not want. is there a way to configure my form to ...
2
votes
3answers
4k views

How do I create a multiple choice question in Google Forms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have ...
2
votes
1answer
91 views

Creating conditional sub-questions in Google Forms

I have an initial (round 1) question, which asks user to select options (checkboxes) that applies to him/her. There are total 5 checkbox options (#1, #2, #3, #4, #5). Out of the 5 options, let's ...
1
vote
1answer
31 views

Force Google login page to appear when accessing a Google Form?

I'm trying to create a Google Form that is locked to a specific Google Apps domain, however I'm running into the issue where if I send out the link to the form to my users and they are logged in to ...
2
votes
1answer
27 views

I created a copy (B) of a Google Spreadsheet (A). Now the Google Form that used to feed A is feeding B

Is there any way to change the settings of the Google Form so that it again feeds into the same worksheet of the same Google Spreadsheet (A) that it used to feed before I created the copy B? The only ...
2
votes
1answer
62 views

Google forms hierarchical multiple choice questions

Supposing I have 2 multiple-choice questions concerning: Country students are from: ..... (choices include USA, UK, China ....) States where they are from: then if they selected USA in the first ...
1
vote
1answer
698 views

Retrieving user email address from Google Form survey results

I am a Google Apps user. Is there a mechanism or script which allows me to retrieve the respondents email address from a survey? I can see the timestamp but there is no respondents email field. ...
3
votes
2answers
424 views

How do I record the value of GET parameters passed to a Google form in hidden inputs?

My question is basically the same as this one asked on StackOverflow, too old to migrate, but which seems to be a better fit here. This answer (more authoritatively, here) suggests a way to add a ...
0
votes
1answer
58 views

Google Forms Flow not working as expected

I have a Google Form with 4 sections and it is setup like this: Section 1 - One multiple choice question Yes (Go to section 2) No (Go to section 3) Section 2 - A few questions After finished ...
0
votes
2answers
36 views

Auto entering functions in sheets managed by forms

I want to fill a single column of my sheet with a function, the sheet is being managed by forms. So, whenever a new entry is added it adds a new row and that row will not have the function that I want,...
7
votes
3answers
5k views

Google docs forms confirmation email when someone signs up?

When you are using google docs forms so people can sign up to an event. Is it possible to make the form send out a confirmation email when someone registers?
0
votes
0answers
75 views

Script to create an edit response URL in Google Sheet sometimes fails

I have been using the "FormMule" addon to create "Form Edit URL" apart from mail merge. However, the triggers for the addon seemed to have stopped working. I found this post answered by Rubén: Show ...
4
votes
1answer
485 views

Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script

I'm trying to make the edit URL for a Google Form automatically populate in the response Google Sheet that it's attached to. I've seen this already and want to use it, but I'm having issues trying to ...
0
votes
0answers
47 views

Google form that shows calculated quantity

I need to create a Google form with following properties: It should automatically take today's date as input. For many inputs there is point associated with it. The total score is sum of all points. ...
3
votes
2answers
8k views

How do I publish this survey created in Google Docs?

I have a student who created a Form in Google Docs using their Google Apps for Education account. For some reason, we are unable to send this published form so that others can take the survey. Why ...
0
votes
1answer
6k views

Can you style Google Forms (from Google Apps)?

While Google makes themes available to style forms in Google Docs, there seems to be no provision for styling forms yourself. I have a two-column layout and want the form on the right. There are ...
1
vote
0answers
436 views

Filter out reponses to a Google Docs form by a failed “check” value in a multi-choice item

I want to lay traps in a Google Docs form to filter respondents. The form has some questions with answers in checkboxes like so: Question 1 ☐ Answer A ☐ Answer B Question 2 ☐ Answer A ...
2
votes
1answer
137 views

Running a Google survey through an online panel

I will be conducting a survey through an online third-party panel and need to upload my Google survey link but they require a unique ID tag for them to be able to identify unique responses. Do you ...
2
votes
1answer
64 views

Can I add two calculated fields to a Google Spreadsheet based on a Google Form?

I am new to Google Scripts and am hoping for some guidance on improving a manual process I complete in Google Sheets. To analyse the data I receive on a Google Form I run, I manually add-in (or copy ...
-1
votes
1answer
81 views

How can I make a minimal, unstyled HTML form which works with Google Forms?

I want to embed a Google Form in my website, but make it unstyled, etc., so it looks neat and can be placed in widget form.
2
votes
1answer
209 views

How to automatically wrap text to new responses from a form in a Google Spreadsheet?

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet. Now recently I had to remake this ...
2
votes
2answers
316 views

Automatically copy and paste cells that have just been updated to a list from forms

I have a spreadsheet that collects information from two different forms. Each form feeds a different sheet in the spreadsheet. There are 3 other sheets that the info from either of the first two forms ...
2
votes
2answers
74 views

How can I set a Google Forms survey to read-only?

I finished the collection of responses through a Google Form. Now I want to set the survey to read-only, i.e. allowing people to view the form but not submit any more responses.