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
6 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
6 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 ...
0
votes
0answers
12 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
34 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
0answers
61 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 ...
0
votes
0answers
68 views

Custom field names in form linked to Google Spreadsheets

I would like to use Google Spreadsheets to store responses from a custom form. The name attributes of the input fields appear to be randomly generated (entry.<random num>). Is there anyway to ...
1
vote
1answer
246 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
198 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
185 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
192 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 ...
1
vote
0answers
45 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
0answers
188 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
33 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
30 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
67 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
81 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
86 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
794 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
391 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
202 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
99 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
32 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
304 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
687 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
132 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
0answers
227 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
60 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 ...
4
votes
2answers
1k 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 ...
2
votes
1answer
83 views

Geocode in Google spreadsheets, keep results

I have a form for internships and I am passing over the address of the internship provider to a function which gives me latitude and longitude for it, which is then consumed by a webmap using tabletop ...
4
votes
1answer
451 views

Auto-sort column Google Spreadsheet on incoming Google Form response

How can I get the Google Spreadsheet to automatically order the incoming form responses alphabetically (2nd column)? I know how to do this manually or by going in and editing a cell, but cannot get ...
0
votes
0answers
66 views

Sort Google Form Responses to Different Sheets [duplicate]

I need to take Google form responses and separate them based upon one of the questions. How can I set this up so that this occurs automatically?
0
votes
0answers
135 views

Filtering data based on dropdowns in Google Forms

Is it possible for me to have a choose from a list question in a Google Form and have two dropdown boxes? Such that, the list items in the second dropdown box will depend on the item chosen in the ...
0
votes
0answers
47 views

Google Forms link sharing to Google Community as Google Page owner

I have a Google Plus Page and Google Plus Community connected to the page. If I share a Google Form link as the page owner to the Google Plus Community I got an error, whereas sharing the same link as ...
1
vote
2answers
527 views

Google forms script to delete responses counter

I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated. My copy sheet function, and delete ...
0
votes
2answers
789 views

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

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 ...
1
vote
0answers
209 views

How can I get drop down in grid in Google Docs form?

I have been trying to get drop downs inside the grid type questions in Google Forms but I was not able to do it. I want something like the following: We want to survey multiple designs for ...
2
votes
1answer
394 views

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet?

Can I map specific parts of a Google Form to one spreadsheet, and other parts to another spreadsheet? Some of the responses on one will be public and viewable by anyone, but others will be private.
1
vote
3answers
152 views

Access to a Google form once people have used it

I created a form for students to submit their assignments. They copy their URL of the Google document, then paste it in a form. When I get their responses, I can't open their URL, it says I am not ...
1
vote
0answers
45 views

Publish last 5 entries from a Google Form

We currently create and html table to list our last 5 Webinars. This is done manually. We are adding external contractors into the mix and would like to give them the ability to enter basic webinar ...
1
vote
0answers
397 views

Google Docs Forms: Create Checklist Item with adjacent Textfield

Using Google Docs Forms, I'd like to create a checklist with a "quantity" and "comments" textfield adjacent to each checklist item. Is it possible to do this without writing a custom script?
4
votes
1answer
280 views

Google Forms Submit and Return to a page within the form

I am trying to get my Google form to return to a page within the form after submitting. This is a payroll form in which there are 5 locations in which each of the managers will choose there location ...
0
votes
0answers
246 views

Google Form Summary of Responses - Hide a field

In a survey form made using Google Forms, I have a name field. Is it possible to keep names hidden and show the remaining charts?
0
votes
1answer
127 views

Google Forms: Auto-update other sheets

Response are automatically added to the sheet "Form Responses". I want to apply certain formulas in a sheet called "Student Answers". However, "Student Answers" doesn't auto-update from the submitted ...
1
vote
3answers
535 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 ...
0
votes
1answer
142 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
vote
0answers
89 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
1answer
452 views

How to view history of filled in Google forms?

I have filled in many Google forms for an interview in last month so I want to view details of what I have entered in those Google forms. How can I get the history of all my filled in Google forms?
1
vote
2answers
181 views

Is there a way to speed up the auto-increment routine in Google Spreadsheets?

The solutions that have been provided for this question does the job, but when more people submit data at the same time, things go wrong. The same number is used in multiple rows. Is there a way to ...
0
votes
0answers
41 views

How to revoke “can edit” from google forms

I created a form in Google Drive that I intend to share, but for some reason, I can't revoke the "can edit" for collaborators. Image Does anyone have an idea why is that?