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 ...
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()....
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
1answer
501 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 ...
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 - ...
-1
votes
1answer
17 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 ...
3
votes
0answers
103 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
80 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 ...
2
votes
0answers
231 views

How can I insert a text item (question) with multiple response fields (and descriptions) in Google Forms?

I'm trying to create a survey/Google Form specifically to export data into an Excel sheet. This isn't very important because I can tweak the arrangement after the fact, but naturally I have a lot of ...
2
votes
0answers
43 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
167 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
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
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 ...
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 ...
1
vote
0answers
36 views

Google Form doesn't show all answers in Summary

I've created a Google Form and got 26 answers. When I go to "Summary" it only showed 22 answers. I tried to refresh the browser cache but it didn't fix the problem. Trying with another internet ...
1
vote
0answers
22 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
238 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 ...
1
vote
0answers
98 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
156 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
56 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
37 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
132 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
27 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
60 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
249 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
246 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
182 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
93 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 ...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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 ...
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. ...
0
votes
0answers
55 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, it'...
0
votes
0answers
64 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 ...
0
votes
0answers
67 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 https://support.google.com/docs/contact/...
0
votes
0answers
102 views

Specific questions based on answers of multiple questions on Google Forms

In Google Forms, how can we display a question to the user based on what he/she selected for two other questions? I know how it can be done based on the answer to one question, by making use of Go to ...
0
votes
0answers
31 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
192 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
158 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
314 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: ...