Questions tagged [google-forms]

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.

Filter by
Sorted by
Tagged with
10
votes
1answer
28k 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 ...
20
votes
6answers
62k views

Can I add an autoincrement field to a Google Spreadsheet based on a Google Form?

Is it possible in Google Forms to give a unique value to each row it inserts into the spreadsheet as well as the timestamp?
4
votes
2answers
14k views

How do I implement a script that creates a unique ID for a Google form submission?

I need to create a unique ID upon submission of a form which will be used as a project number for tracking. The number needs to be unique but not based on rows or other changeable data because ...
8
votes
6answers
4k views

How can I get Google Sheets to treat my form-submitted strings as plain text and preserve leading zeros?

I have Google Forms where users enter information, some of which contains leading zeros (e.g. zip codes, ID numbers). However, when this data is saved to the Google Sheet, it doesn't treat it as ...
8
votes
1answer
70k views

How to make subquestions in Google Forms?

I want to make form with different length dependent on some previous responses. For example: Q1: Do you like cats? Yes/No Q2 (Q1=Yes): Which kind of cat do you like most? Q2 (Q1=No): Why do you ...
4
votes
3answers
3k views

Forms Data Manipulation In Google Sheets

I'm trying to develop a solution using Google Forms with Google Sheets that will collect Google Forms data and then automatically divide that one form submission's data into multiple rows of data in ...
4
votes
2answers
6k views

Google Spreadsheet: Adding formulas to Google Forms responses rows

I have a sheet with form response data in several columns, say A:G. Some of the data are numerical and I'd like to have some calculations done on them, e.g. in columns H through J. I have already ...
1
vote
2answers
12k views

Is there a way to keep track of the URL used to edit responses in Google Form? [duplicate]

I would like to use Google Forms to keep track of the progress of an application process (similar to what this websites does for immigration applications). One key functionality that I need is to be ...
0
votes
1answer
1k views

Responses missing in Google Forms under the 'Checkbox - Other' question

I have a Google Form with a checkbox question and I can see from the responses summary that two respondents have ticked 'Other'. But, I can't see what they have typed, even in the responses ...
2
votes
3answers
9k 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 ...
10
votes
3answers
111k views

How to add attachment option in Google Form?

I need to make a Google Doc Form, in which the users need to upload a Word file. Is it possible to do so using Google Docs form? If yes, then how?
7
votes
1answer
24k 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 ...
4
votes
1answer
6k 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 names which are being input in the sheet from a Google Form? I would like each new sheet to be created when a ...
2
votes
1answer
2k views

How to set input type = “tel” to the answer input field?

In my Google Form I've got multiple text questions with answers with data validatation set to numbers only. Unfortunately when I enter the answers using the mobile browser the keyboard shown is full, ...
2
votes
1answer
853 views

Report/process only using the last entry made by the user in Google Forms

I have a form where students can enter choices: for instance the specialisation they want to pursue, and the semester when they will start that specialisation. An example entry form is here, but it ...
0
votes
1answer
4k views

Link Google Form responses To Already Existing Google Spreadsheet Tab

I have a Google Form. I had all of my Google Form responses linked to a specific tab in my Google Spreadsheet. Somehow my form responses were unlinked from my tab. When I go to re-link my form ...
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
votes
1answer
606 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.
10
votes
3answers
11k views

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms with a question that contains a drop-down box with the following values: - Fewer than 10 - 11-25 - 26-50 - More than 50 If the user selects 11-25, Google Sheets renders the ...
2
votes
1answer
32k 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 ...
2
votes
1answer
3k views

Google Form can be edited, or not viewed at all - where is the view only option?

I am trying to create a Google Form. I am unfamiliar with Google Forms, but I am familiar with Google Sheets and Docs. I'm having a problem with the form, however. When I go to the Sharing Settings ...
2
votes
1answer
1k views

Google forms hierarchical multiple choice questions [duplicate]

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 ...
10
votes
7answers
19k views

Is there a way to link a “Choose from a list” style question in a Google Form to a list of data (e.g. in a spreadsheet)?

Is there a way to link a "Choose from a list" style question in a form to a list of data (e.g. in a spreadsheet)? This would mean that as new options were added to the list in the spreadsheet (or ...
5
votes
7answers
19k views

Importing data into a Google Forms response sheet

I have some Google Forms and 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 been ...
5
votes
2answers
31k views

Can Google Forms send emails automatically?

I used Google Forms to create a form for people to register for an event, by entering their name and email address. I would like to set it up so that when a person enters his name and email, the ...
22
votes
4answers
49k views

How to create a countries drop-down list question, without entering all countries manually?

I am creating a Google Form, and as the final question I want to ask the participants what country they come from. As it often comes up in polls, I am surprised that this country component is not ...
4
votes
1answer
8k views

Figuring out who is the owner of a Google Spreadsheets form

I have noticed that Google spreadsheet form's have URLs in the form of http://spreadsheets.google.com/viewform?formkey=.... I don't see anything that relates to the Google account in the URL. There ...
9
votes
1answer
58k views

Set up specific questions to appear only after particular answers on Google Forms

I am currently creating a survey using Google Forms. It's quite a long survey, so I would like to make it as quick as possible for everybody doing it. A lot of the survey questions are repeated and ...
7
votes
1answer
820 views

Google Forms erroneous deletes rows in second sheet

I created a form in Google Docs with quite some questions. For a good overview I created a second sheet to pick the important parts from the survey. There I'm also able to add extra columns to add ...
7
votes
1answer
26k 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 ...
4
votes
3answers
13k 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 ...
4
votes
4answers
19k views

Email Google Form daily?

Is it possible to email out a Form created with Google daily? I would like to do this simply to email myself a form for use in personal data aggregation. One specific use I'd like to do this for: I ...
3
votes
1answer
8k views

Customize the “other” box of a Google form

I have a Google form and I want the "Other box" of a multiple-choice question to say something other than “Other”. For example: Other programs:[ ] How to do it, if this is ...
2
votes
1answer
2k views

Validate age (>18) Google Forms?

I working on this form that has to be filled only by those over 18 years old. I was wondering if is possible to ask for the date of birth or the age in the first question and if is over 18 then the ...
1
vote
1answer
804 views

Share Google Drive Folder with submitters of Google Form

I have a Google Form that is used as a sign up form. This form has a question requesting emails. It uses the email validation. I have a Google Drive folder that I want everyone who signs up to be able ...
1
vote
1answer
793 views

Can I auto-fill an answer on a form edit URL?

I periodically send out emails to our team to check in on from entries that have a specific field set to "No". And after they complete a certain task then need to change that entry to "Yes". The ...
0
votes
1answer
2k views

I can't get the script to show in the menu of a G Suite document

I'm new to scripting and have been trying to get this URL shortener script to show in my spreadsheet. I have clicked 'debug' to authenticate the script, then what? I thought the menu item would be ...
10
votes
5answers
70k views

Adding hyperlinks in a Google Form

How can I add hyperlinks in Google Form?
6
votes
2answers
5k views

Limiting the amount of Google doc's forms that can be submitted

I'm arranging an event and I'm using Google Forms so people can sign up. I can only have 100 people and want the sheet to stop accepting new signups to the form when the number is 100. Is this ...
5
votes
2answers
4k views

Can I get an RSS feed of changes to a Google Doc?

If I would like to track edits to a Google Doc or inputs to a Google Form by receiving an RSS feed thereof, how do I go about doing so?
4
votes
2answers
278 views

How to add up the correct answers from the check boxes question?

What syntax do I use when adding up the number of correct answers that have boxes checked? My question is; In this example the correct answers are Cotton and Calico. I award the students a total of ...
3
votes
3answers
3k 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.
3
votes
2answers
4k views

How to insert an image into Google Forms?

Last time I tried, you can't put an image into a Google form. Example, if you want people to vote on pictures, you can't do this. People use hacks to put in their own image. Am I missing something ...
3
votes
2answers
13k views

How can I change the default text on the “Submit” button?

Can somebody please tell me how to change text on the Submit button in Google Forms? Please note: I am referring here to the standard Google Forms, the one's that anyone can setup in Google Drive ...
3
votes
1answer
3k views

Single Response Spreadsheet (with multiple sheets) from multiple forms

I have four surveys (google forms) from which I want responses to go to a single response spreadsheet (each on a different sheet). It appears in the form view that I can select to have the response ...
3
votes
1answer
7k views

Get the Id of the response from Google Forms via a Google Apps Script

How do I get responseId ? var form = FormApp.openById('myGoogleFormID'); var response = form.getResponse(responseId); function onSubmit() { // Here I'd like to get the id of the current response } ...
3
votes
1answer
6k views

How to post responses from Google forms to a specific sheet in a Google spreadsheet [duplicate]

I have a form, a Google form, and I'd like to post the user's responses to a specific sheet in the Google spreadsheet. Is this possible?
2
votes
1answer
175 views

How can we NOT record, but on the fly disregard responses not matching an already existing roster

We use google forms to send out tests to our students and must find a solution for the (as per title) following situation: The scenario limitations: NOT all our students can have a google account. We ...
2
votes
1answer
6k views

Is it possible to show dynamic information in a Google Form based on a previous response?

I set up a form to specify the location of household appliances in a residence. The form is based on a unique code assigned to each household. (it's working properly) To avoid entry errors, I would ...
2
votes
1answer
250 views

When creating a 'Checkboxes' question in Google Spreadsheets, what formula do I use to add a mark to each box ticket correct to the answer?

I am creating a Google Spreadsheet for the first time and I have suddenly become stuck. When filling out my spreadsheet I do not know what formula to use when adding up the correct answers. I have ...