Google Forms is an integral part of Google Spreadsheet. Its primary use is to collect user responses.

learn more… | top users | synonyms

0
votes
0answers
5 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 ...
2
votes
2answers
81 views

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

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 ...
2
votes
0answers
57 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
1answer
44 views

How can I sum a row in Google Spreadsheet so that the formula isn't overwritten when Google Forms adds a new row?

I'm using Google Forms to collect some data from students. Each time a new student submits a form, the data (4 columns worth) is added to a new row in a Google Spreadsheets, bumping anything ...
0
votes
1answer
20 views

“other” response not collected in Google Forms

I have created a survey using Google Forms many of which are multiple choice with an "other" option at the end and a small box for users to enter their own response. In the results spreadsheet it ...
0
votes
1answer
33 views

Google Spreadsheet changing cell references on its own

I have created a Google Form with an attached spreadsheet. Within that spreadsheet I have created several sheets to sort the answers to my liking. Sheet 2 is just an exact copy of all the original ...
0
votes
0answers
51 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: ...
2
votes
2answers
67 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 ...
0
votes
1answer
68 views

How do I add a counter value into a cell once a row is added

I work for a small company that monitors all service calls in an old database. I recently moved this database into a Google Spreadsheet and a Google Form. Once a user submits a ticket, I would like ...
0
votes
2answers
31 views

Google Forms - Checkboxes - Edit Option

I've got a google form with a checkboxes question: https://docs.google.com/forms/d/1ngHnWZlyZQ3RirL7X4rHj8_x9gLa_CvVyPiyLkUmQls/viewform I edited an option (to clarify it), and now the number of ...
0
votes
0answers
23 views

How to populate a text box in Google Forms

I would like to make the answer from a choose from a list to populate a text box in a Google Form. Any suggestion on how to accomplish this task?
0
votes
1answer
21 views

Google Forms - Checkbox - Other

I've got a google form with a checkboxes question: https://docs.google.com/forms/d/1ngHnWZlyZQ3RirL7X4rHj8_x9gLa_CvVyPiyLkUmQls/viewform I can see from the responses summary that two respondents have ...
0
votes
0answers
53 views

How to link two forms in Google Forms

Is there an option where I can link two forms? Example: I have a form running in production say "A", I am introducing new form say "B", in the new form "B" for a particular question the question type ...
0
votes
0answers
41 views

Google Forms: Add numeric values and use them for billing in paypal on form submission

I am using a google form to let people signup for a conference that lasts 3 days. A user has options to pay for a day, 2 days or the full conference. He/she has the option whether or not to pay for ...
0
votes
0answers
38 views

How create a Google Doc from a Google Form Input?

I would like to create a Google Form where the user input will do the following: fill in a Google Docs based on a template name the document according to the input place the document in a folder ...
1
vote
1answer
108 views

How do you automatically align incoming form responses in Google Sheets?

I like to have each of my form responses aligned in the center of their cells. However when I submit any new information through Google Forms, they are always automatically aligned to the left, and so ...
2
votes
0answers
55 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 ...
0
votes
1answer
62 views

Google FormsApp: Change item based on answer

Is it possible to change item, in my case - checkbox, based on user answer? For example, I have Date item, where user have to put his/her birthday, and then if user is born on 2001 or later, then add ...
0
votes
1answer
55 views

Transfer data from a form to a new spreadsheet

I have a simple form that inputs entries into a spreadsheet in Google Doc's. All I want to do is open a new sheet and import the data from the forms spreadsheet so I can manipulate it in my own way. ...
0
votes
0answers
38 views

Getting error while using a Google Forms/Spreadsheets Auto-Increment Script

Similar to Kelly's problem here: Can I add an autoincrement field to a Google Spreadsheet based on a Google Form? I need to create a unique ID upon submission of a form which will be used as a case ...
0
votes
1answer
60 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
114 views

Show user name on Google Apps Form

In Google Apps I can choose to "Automatically collect respondent's username". How do I display the username or First Name and/or Last Name on the subsequent form? I'd like the form to read something ...
0
votes
0answers
33 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 ...
0
votes
0answers
43 views

Unique ID in Google Sheets to persist so it's not updated when row is updated via the form?

I'm using this: function onFormSubmit(e) { var sheet = SpreadsheetApp.getActiveSheet(); var row = SpreadsheetApp.getActiveSheet().getLastRow(); var bugCount = ...
1
vote
0answers
39 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
36 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
86 views

Google Form to Spreadsheet formula questions (index/match array and 24hr-12hr clock)

I need help with a Google Spreadsheet populated by a Google form. I cannot get the following formula to work correctly with my form submissions: =(ARRAYFORMULA(if(row(H:H)=1,"Language",(INDEX('INDEX ...
1
vote
1answer
285 views

How to save users' responses in Google Form survey as they continue from page to page?

I have a long form for users to answer survey questions with about 20 pages. It's long enough that users may want to stop and finish the survey later, or they may abandon the survey altogether half ...
1
vote
1answer
613 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 } ...
2
votes
2answers
785 views

Setting maximum number of sign-ups in Google Forms

We use Google Forms to manage a large school event in which each activity requires sign-up using a separate form. We have a maximum number of students per activity. How do we “close” the sign up once ...
2
votes
1answer
404 views

Can I have formulas in a Google Form, not just the worksheet?

We use a Google Form for registration for our charity road race. I need to have two fields that contain formulas so people registering do not have to do the calculating. They can order t-shirts. ...
0
votes
0answers
218 views

Populate Google Form field from spreadsheet to generate unique url

I have a customer satisfaction form that I am going to send out to multiple people. I'd like to link that survey to a unique incident number. Each person can fill out a survey multiple times for ...
0
votes
0answers
96 views

Continue formula on Form submission

I want the following formula to be continued on form submission: =ARRAYFORMULA(D2:D*E2:E+L2:L*M2:M+Q2:Q*R2:R) I came across =ARRAYFORMULA(FILTER(D2:D;D2:D<>""*1.2)) this formula works perfect ...
1
vote
1answer
387 views

Is it possible to automatically add question numbers to Google Forms?

I'm new to using Google Forms and have added all my questions. Is it possible to automatically add question numbers or do I need to go back and manually write them at the beginning of each question?
0
votes
0answers
43 views

Google Forms - Can I Show All Previous Responses?

I want to use a Google Form as a business brainstorming tool. Is there a way to have responses show up as a running list beneath the questions?
0
votes
1answer
56 views

What Infomation is collected by a Google Form

I have a question about what information will Google Forms collec. Will the form creator ever know who fills the form (the Google Account that the user is logging in) ?
3
votes
1answer
86 views

Google form at specific time

Is it possible to create a Google form that will accept responses only during a particular time period?
1
vote
1answer
144 views

Can I have the results of Google Form sent to someone else?

I'm making a health info form for my boss, but I want the results to be only viewable by her and not by me. Is there a way to do that? Or would she have to make a copy of my form and then delete me ...
1
vote
1answer
144 views

Google Form and Group email

I have set up a group email that I'd like to use within a Google Form. Currently the Google Form is pre-filled with my personal email and I'd like to change it to the group email. Any help in ...
2
votes
2answers
1k 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 ...
1
vote
1answer
623 views

Is it possible to feed multiple form drop down lists?

I am using Tom Horwood's code which has worked for me for updating one drop-down. But my form has multiple drop-down lists which I would like to make dynamic. Is this possible? Tom Horwood's code ...
0
votes
0answers
252 views

Prefilled Google Forms with Google Spreadsheet Data

I'm looking for a way to 'pre-fill' a Google Form with specific data from a Google Spreadsheet. The form will have the same 'standard' questions for everyone, but the data in the first two question ...
3
votes
0answers
138 views

How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
2
votes
0answers
43 views

Send form daily/automatically [duplicate]

I was wondering if anyone knows a way of sending a Google Form daily and automatically to someone? More specifically, I am a tutor who would like to send a HW check-in to my students daily, but I ...
0
votes
0answers
38 views

Is it possible to create a form in an HTML component in an edX unit that sends parameters to Google Spreadsheet

The edX platform doesn't have functionality to create poll style questions. I would like to create a form in an html component of a unit that saves the input from the form into a spreadsheet as a ...
3
votes
2answers
629 views

How do I automatically expand a =QUERY when receiving submissions from a Google Form?

The Query below 'works' on a line by line basis (when manually filled down), but it does not 'autofill' down when new data is added to the 'responses sheet'. The data being added to the 'responses ...
0
votes
1answer
836 views

Script error trying to populate form drop down menu from spreadsheet

We are trying to link a list on a Google Spreadsheet to a drop down menu on a Google Form. The twist is that this Google Spreadsheet list will be continuously updated and needs to automatically ...
1
vote
0answers
185 views

How to build a decision suport app with Google forms or other Google Apps Script resource?

I want to create an app which helps newbie employers to take some decisions. So, using their answers to a form, the app asks new questions based on previous responses, something similar to a decision ...
1
vote
1answer
287 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 ...
0
votes
0answers
64 views

Trying your code

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)? I am trying your coding on this page and I cant seem to get it to ...