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

0
votes
1answer
7 views

How to connect different questions in forms to one column in the responses

I created a form to take the attendance of my students and created one page for each class and one main page that has all the grades that enables me to move to the other pages. The responses sheet has ...
3
votes
1answer
29 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
29 views

Easy way to create a survey with an image attached to each question?

I'm trying to create an online survey with where each question would be an image plus a textbox for the answer (the theme is "what do you call this thing"). I've started doing it in Google forms, ...
0
votes
1answer
25 views

How to dynamically retrieve and display data based on input from google forms

To be very specific, let's say I have a google form where it asks you your name (text box) and how much do you like carrots, with a multiple choice prompt of "very much" and "I hate them!" After the ...
1
vote
1answer
62 views

Send recurring reminders to Google Form respondents

I need to create a Google form like below : My objective is to send an reminder of Activity Described in < Your Activity > Question Then I need to send reminder email to email mentioned in < ...
2
votes
1answer
42 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 ...
2
votes
1answer
35 views

How to automatically wrap text to new responses from form?

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 ...
3
votes
1answer
37 views

Use a Google Form to update an existing Google Sheet

Is there a way to update an existing sheet in a Google spreadsheet using a Google form? I only see how to update to a new tab (sheet) on an existing spreadsheet.
0
votes
0answers
33 views

Selecting and unselecting checkbox not updating response sheet

I have a Google Form and a response spreadsheet that is updated as soon as a recipient of the form answers and submits the form. I have several different types of field ( multiple choice, grid, ...
1
vote
1answer
74 views

Create question in Google Form where all answer options calculate to 100%

I have this question in a survey I'm trying to build a percentage accumulation like so: Put the % of how much you spend of your salary in the following categories: [Food, Transport, Health, ...
2
votes
2answers
59 views

Google Sheets/Forms/Script: How to send an email then replace “@” with “#”

I am trying to create a script where the user gets an email (column 1) with the body being column 2. However, after that, I want to replace the "@" in the email with a "#" so that they do not get the ...
2
votes
2answers
23 views

Google Form list question to send different data from displayed value on select option

Is there a way to have a Google Form list-type question pass different values on the backend (e.g., to its linked Google Spreadsheet) than what are displayed? For example, under Provinces at ...
18
votes
1answer
773 views

How can someone answer my survey form or Google form without creating their own Google account?

How can someone answer my survey form or Google form without creating their own Google account? They told me that they can't open my form because they didn't have an account.
0
votes
0answers
10 views

How do you make a drop list dependent upon another drop down list? [duplicate]

I work with schools and districts. I would like the form to have a drop down menu for the district, then based on that choice, another drop down menu for the school choice. Is that possible?
1
vote
1answer
21 views

Is there a way to check data entry consistency in Google Forms this way?

In the questionnaire I'm working with, there's a question like this: What was your facility's total revenue last year? And a bunch of following questions asking about sources of that revenue, ...
1
vote
0answers
26 views

Google Form from Facebook Group

I have a a google form that I would like to only make available to members of a closed facebook group. The form is anonymous and members are free to use it as often as they would like. The problem is ...
4
votes
1answer
45 views

Check Google Form entry for duplicate answers

I want to make a new form where I ask people about their "top 15" within a list of elements. I have searched a lot, but I couldn't find anything. I decided to just make 15 questions, "what's your ...
2
votes
1answer
64 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 ...
0
votes
1answer
16 views

Is there a way to specify multiple conditions for “Go to section” feature in Google Forms?

I'm learning to use Google Forms to create a survey questionnaire, whose skip patterns of some variables need multiple conditions. For example: Question 1: When did you have veggie yesterday? ...
2
votes
1answer
26 views

Cannot plot null values in Google Forms

I have a Google Form with questions that I collected the responses from. Now I am trying to create the charts. I click on Responses -> View responses, then I click on Explore to see the chart. The ...
2
votes
1answer
33 views

How can I round a Google Form input to nearest .5?

I'm trying to write a script that will calculate based on user input from a Google Form and then send a customized email based on the input provided. I've written an apps script bound to the ...
0
votes
1answer
33 views

Pre-filled Google form with varying number of questions

So I am doing a client check in...some clients have 5 things about which I need a status, some have only 1. How/Can I create a Google form with pre-filled answers and questions that would vary by ...
3
votes
1answer
34 views

My students are losing their answers before submitting the form

I do my assessments using Google Forms. Things have been good so far until today. This morning, two of my students who were taking their assessment, found that all of their responses had been ...
4
votes
2answers
40 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 ...
2
votes
1answer
41 views

Google Form with an alert

I created a registration form with Google Forms. Now I would like to have an alert displayed before the submitter starts filling out data. This is my code: function onOpen() { FormApp.getUi() ...
2
votes
1answer
24 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 ...
2
votes
1answer
29 views

Using a script to process form input every time a form is submitted

I'm trying to have it that every time I submit a form, it adds automatically some data. This is the script I have: function onFormSubmit(Test) { var sheet = SpreadsheetApp.getActiveSheet(); ...
0
votes
1answer
11 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 ...
2
votes
1answer
25 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 ...
1
vote
2answers
45 views

Sorting Pre-Sorted Google Form Data by Timestamp

I have Google Form checkbox data that I am separating out into another table so that each checkbox selection generates its own line. I received some help in pulling the data over, and the resulting ...
2
votes
1answer
42 views

How do I include multiple fields for each answer (two-part answer) choice?

My specific question is how to set up Google forms to allow a two-part answer. For example, which of the following books have you read and how many days did it take you? So you would have many book ...
2
votes
1answer
51 views

Edit multiple form responses inside a Google form

I am looking an editing form responses on Google Forms. So basically, I was thinking to create a simple form for the fields I need and having a drop down on the top to edit form responses ...
1
vote
1answer
177 views

Is there a way to generate edit response url for google form

I have a Google Form With a Google spreadsheet to store responses. In my spread sheet I have 4 column: name, email, revenue, and a fourth column Id which is used to identify the particular recipient. ...
1
vote
1answer
72 views

Email respondents a copy of their completed Google Form

I am the new coordinator of a high school theatre awards program. I have created an evaluation form for the judges to fill out after they have seen their show. They would like to have a copy of their ...
1
vote
1answer
45 views

“sort” function results in all of my data going to the bottom of the sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. I would like to be able to have any staff member add jobs that need to be ...
3
votes
1answer
45 views

How to get information from Google Sheets to send it via form emailer?

I created a Google Form. There is a field called email. With this I can receive emails from the submitter. I want to send them a confirmation email taking some information from the sheet. How can I do ...
2
votes
1answer
45 views

Rearranging Google form data in a new sheet

I am trying to use a form to create a list of jobs for our student employees, which exists as an editable Google sheet. The thought, being any of the staff could add jobs that need to be taken, by ...
1
vote
1answer
19 views

Appending the content of one cell to another cell

I'd like to automatically create the content of a cell, based on the value of another cell. For instance: Cell content: 1337 Cell content 2, automatically created: http://www.superuser.com/1337 ...
1
vote
1answer
51 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 ...
0
votes
0answers
36 views

Finding old Google Forms edit links

How do I find old Google Forms edit links for which I don't have the direct URL any more? I have submitted a few forms recently where I didn't bother to take note of the edit URL. Now I want to check ...
2
votes
1answer
259 views

Simplifying Google Form Checkbox Responses into Itemized List

This is more of a Google Sheets question than a Forms question. I want to receive form responses from checkbox questions (which unfortunately cannot be separated into separate rows) and flip the data ...
0
votes
0answers
40 views

How to make special subquestions in Google Forms?

I want to make form with different length dependent on some previous responses. I can do this with page break, but I would like to do something like this ...
2
votes
1answer
109 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 ...
1
vote
1answer
45 views

Creating Google Form with many list options

I am creating a dropdown list in Google Forms, and have approximately 300 options that my users can choose from. Is there an efficient way to add the options to the Google Form as opposed to manually ...
1
vote
2answers
25 views

Google Forms submits times that are not numerically consistent with those in a spreadsheet

When I submit a Google Form, and I fill in a time the number that is entered into the spreadsheet is not the same number the spreadsheet will use for that time. ie. If I enter 3:30 PM in a form and ...
0
votes
1answer
40 views

Google Sheet Cell Link to Google Form test score

I have a pre-made Google Sheet which has cells to be marked as "pass" or "fail" depending on the person's score. Is it possible to link a Form response to record a pass or fail mark depending on the ...
1
vote
1answer
60 views

Google Sheet not being populated and responses summary not getting incremented after Google Form submission

My wife has a paint & wine party business and I've been using an embedded Google Form for registration on her site for nearly a year without issue. Last week I updated the photos in the ...
-1
votes
1answer
15 views

Google Survey Help

How do I share a google forms (survey) in a computer lab for several students to rotate through to complete without getting the error message that one has already completed the survey?
3
votes
1answer
211 views

Is it possible to link a Google Form to a desktop Excel sheet so that when someone fills in the form the data goes into the Excel sheet?

I work for a sporting organisation and track all sorts of monitoring variables using Excel spreadsheets. Up until now I have used macros in Excel to do this, but this requires players taking it in ...
2
votes
1answer
29 views

Limiting access to a Google Form

I am using Google Forms for yearbook quotes and need to only allow the seniors to use the form/ The form is posted on our web page however all of the grade levels have Google accounts. Can I put ...