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

6
votes
2answers
209 views

How to add fields to a Google Form visible only to specific users

Is it possible to add fields to a Google Form which are visible only to specific users (based on their email ID)? Or allow only users whose email IDs fall in a set to fill the fields?
2
votes
1answer
427 views

Google form to spreadsheet, create new column

I created a Google form and a spreadsheet associated that form. On the spreadsheet there are two columns by default. A is Timestamp and B is Untitled question. Now I want to create another column in C ...
1
vote
1answer
33 views

Email copy of filled-out Google Form including boilerplate

I have constructed a Google Form used to book a community hall, and the form includes some Terms and Conditions that the user is agreeing to. I've displayed the Ts&Cs using the description field ...
1
vote
1answer
92 views

How to edit a particular sheet using Google Forms

I created a form that has list of items to be selected. I also created a spreadsheet that has a couple of sheets that correspond to the elements in the form. I wanted users to select a category and ...
1
vote
1answer
27 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 ...
1
vote
1answer
56 views

How can I get my set values and formulas to populate to a row of values received from a Google Form?

When I receive submissions from a form I am trying to find a way to include my formulas and set values in the same row as the information submitted by form. My form is only collecting 14 values but my ...
1
vote
1answer
236 views

Auto sort of Forms responses

We use Google Forms to collect guest surveys for our resort. New responses get added to the bottom of the response sheet. While we can manually sort the responses using the time-stamp feature, not ...
1
vote
1answer
63 views

Google Apps Script with forms to check if a doc url is 'shared'

Does anyone know "IF" it is possible to use Google Apps Script with a Google form to auto check "IF" a document URL pasted into the form is a "shared" document? I'm a teacher and I use Google forms ...
0
votes
1answer
100 views

want a simple sum of check boxes

I created a form with three checkboxes for each question. Each group of check-boxes starts with the same repeating words (as in: Vata - xxxx, Pitta - xxxx, Kapha - xxxx). I want the total number for ...
0
votes
1answer
466 views

How to see names for survey responses?

How can I show the name or email address for responses to form survey in the results spreadsheet? We want to see each other's responses but results sheets seem to be anonymous and only show time ...
-1
votes
1answer
14 views

Including Google surveys in email

Pressing 'submit' on google survey Sorry to bother you but I am having problems creating a google survey. I would like to get people to fill in the survey on the email without being re-directed. I've ...
2
votes
0answers
29 views

Restricting date selection

Is there a way to restrict the user of a Google Form from selecting today's date? I always want them to be able to select the next day but never the same day.
2
votes
0answers
68 views

How to send an email with a link to an auto-populated form in MailChimp?

MailChimp always appends the "update subscription preferences" link at the bottom of an email, which links to a page that is auto-populated with the subscriber's name and email. Is there a way in ...
2
votes
0answers
108 views

How to enable duplicating questions in Google form by the user who is filling it

I have a Google form with two parts. The first part is personal details (name, phone etc.). The second part is other information from the users. For my real needs, each part contains several ...
2
votes
0answers
131 views

How to see who has already received a Google Form

I need to send a Google form again but do not want to send it to people who have already received it. Is there a way to see who I have already sent the survey to (including those who have not ...
1
vote
0answers
39 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 ...
1
vote
0answers
12 views

Narrow sample space down with Google Forms evaluation

I got the results from a survey I did with Google Forms. The survey results are stored in a Google Spreadsheet (150 rows). I really like the feature to get the results in diagrams automatically, but ...
1
vote
0answers
36 views

Using a Live Google Form inputs for calculations

Spreadsheet is not recording responses from form I am able to see from responses appear fleetingly before they vanish. They are however indicated in summary I have tried un-linking, re-linking, ...
1
vote
0answers
46 views

Combine checkbox and paragraph in Google Forms

I am trying to create a new survey. The question will be directed to the patients about their current pharmacological therapy. I prepared a checkbox list of medications, but I can't add a textbox ...
1
vote
0answers
25 views

Google Forms: Accepts forms with a specific sum of numeric fields

I am building a voting lottery form for my friends. Each participant should guess the number of seats that every party will gain in the upcoming Israeli elections. Each party is a required field, ...
1
vote
0answers
22 views

Can I make a list option unselectable in Google Forms?

Similar to the HTML <option> attribute disable, I want to make a Google Forms list have some options that are visible but unelectable. Is this possible?
1
vote
0answers
63 views

Allow multiple votes for the same option in Google Forms

I am trying to make a Google Form where users are allowed (or required) to cast two votes, and they are allowed to vote twice for the same option. Is that possible? I haven't been able to figure it ...
1
vote
0answers
23 views

Automatically capture browser of respondent in Google forms or Wufoo

Is it possible to capture the browser version of a form respondent in Google Forms or Wufoo? Perhaps this is possible in Google using the built-in script editor?
1
vote
0answers
29 views

How to randomly choose from a list of questions or choose from a list of values in Google Forms

I need to do a transit survey and I've been researching how to do this with no luck. Your help would really be appreciated. I have questions where I give them a choice between 2 trains (A & B) ...
1
vote
0answers
164 views

How to use Google Forms for data entry in a lab, keeping track of which computer input each entry?

I wanted to use Google Forms for the following: People come into the lab, seated at 1 computer desk each. They do not sign in with any personal info. They enter addresses from a phone book (through ...
1
vote
0answers
185 views

Can I fill specific cells in my spreadsheet when submitting a Google Form?

I have a Google Spreadsheet that contains a list of dates, and empty cells. For a variety of reasons, I'd like to be able to have people add fill out a Google Form where they select a date, and fill ...
1
vote
0answers
163 views

Make some responses in Google Forms private

I am creating a Google form as a questionnaire and would like to allow people to see some parts of the responses but not others. I am not a programmer, so not really into using scripts to sort them ...
1
vote
0answers
546 views

Google Drive Form doesn't display on Google sites if not signed in on chrome

I have a site, hosted by Google Sites that includes a Google Form. Normally, the page loads, then a second or so later the form loads. In the problem case the page loads, but the form doesn't. It ...
1
vote
0answers
155 views

What is the better way to collect ordinal data for top three activities from a list

What might be the preferred way to post a list of 24 activities and then ask visitors to choose their 1st, 2nd & 3rd favorites? They were to provide a response: Why are you choosing this? What is ...
1
vote
0answers
251 views

How to share with others a poll results as a chart?

I've created a form on google drive, the form is public, anyone can see it and respond to it. I would like to also provide a link to the data gathered by the form, however I would like to provide the ...
1
vote
0answers
86 views

Filtering Form Feedback using Google Docs

Does anyone know how to filter respondent feedback into different sheets on the spreadsheet? For example, each sheet collects information for separate classes and I want the form information to be ...
0
votes
0answers
10 views

Edit existing google sheet using google form

I have data in a google spreadsheet that I'd like to modify in forms. I'm working on a large scanning project and have a list of all file names and associated utility types in a google sheet. I'd ...
0
votes
0answers
20 views

Google Script: setValue function on form submit

I have written the following code function myFunction(e){ var options={cc: 'x@abc.com'}; MailApp.sendEmail(e.values[2], "New SMS Blast request", "A new SMS blast request has been entered, the ...
0
votes
0answers
10 views

Items move unpredictably when I try to change the order of questions on a Google Form

When I drag and drop a question, other questions move in random order. Just as I get one question where I want it, three others move themselves. How can I prevent that from happening?
0
votes
0answers
32 views

Making specific questions appear only after particular answers on Google Forms via Formfuse

The answer to the question "Set up specific questions to appear only after particular answers on Google Forms", was very clear and helpful. I am using the Formfuse add-on to automate the creation ...
0
votes
0answers
24 views

Send to respondents a number between 1 and 10 using Google Forms?

My idea is to give to respondents by mail a number reference between 1 and 10. The idea works as follows: You have 10 boxes. When a response is submitted, automatically the form will send a email ...
0
votes
0answers
25 views

Google Forms - Go to list of pages based on checklist

I'm making a survey that parents can fill out with their opinion on the teachers that teach their children. Is there a way to have a list of teachers on the first page, and based on which teachers ...
0
votes
0answers
19 views

Read-Only Text Won't Display

How do I get the read-only text on my forms to display? It displays in my back office, and on my website, but not in the email notification that's sent out to my client and myself.
0
votes
0answers
94 views

How can I get the response ID of the person opening the form in the onOpen function in Google Forms?

I am using the following code in hopes of getting the responseID for the user who is editing their previous response to a Google Form. The problem is that the ID appears to be related to the ...
0
votes
0answers
59 views

Can entries automatically populate different tabs depending on the value entered in Google Forms?

Currently, the values (number of hours) are autopopulating in one tab next to the user's name. How would I create a tab that autopopulates the user's info if he/she enters a number, say, between 20 ...
0
votes
0answers
196 views

Google Forms Plugin - Change the Submit button text

I'm using Google Forms in conjunction with the WordPress Google Forms plugin to add various forms across different pages on my site. The forms are added using to following shortcode from the plugin: ...
0
votes
0answers
50 views

Delete a q​uestion in a Google Form

I want to delete a row in the Google Form, and it disappears well enough in the spreadsheet, but it is still in the presentation. I also want to modify the contents of the investigation, but it does ...