Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-forms]

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.

-1
votes
1answer
11 views

Why doesn't google forms recognize responses manually added to the responses sheet

I'm trying to see if I can add responses to a sheet manually through a proprietary application but whatever response I add to the sheets document is pushed down and isn't recorded on the responses ...
1
vote
1answer
8 views

How can I track the time it takes for someone to fill out a Google form?

I am running a study for my thesis, and would very much like to track the time it takes to complete a Google form to compare against how long it takes to fill.
1
vote
1answer
9 views

Google Forms addressed only certain people

I would like to create a survey on Google Forms, addressed only and for certain and specific people. the user must enter the name, surname and other data. if this information does not match those in ...
1
vote
2answers
66 views

Send a google form result to an email

I need help with the google form. The problem is this: I want to receive an email with its results for every user who completes the form. For example, if you had a form that required email, name and ...
0
votes
1answer
15 views

Repeatable questions

I'm trying to create a daily personnel report. Each manager needs to report who their personnel are, whether they are Present, Sick, On Leave, etc, and where they are. I then plan on having a set of ...
0
votes
0answers
14 views

Google Forms Duplicating answers to Google Sheets

I have a google form to capture order information, When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much. ...
0
votes
1answer
40 views

Why does google forms ask me to sign in even though I am signed in?

I have gmail account signed in and when I open google forms that I received in my inbox, it asks me to sign in to continue. When I click sign in, it again reloads the same page and again asks me sign ...
0
votes
0answers
4 views

Edited Google Form questions not same when open in spreadsheet

I used google form to create few surveys. I do some edit on the questions, questions sequence, etc. However, the questions sequence in spreadsheet is not the same as in google form. If there are new ...
0
votes
1answer
8 views

Update giveaway quantities in Google forms

I am in charge of giving away a number of T-shirts which come in different sizes and colors, but they are limited in quantity. I wanted to create a Google Form for giving the T-shirts away, but I do ...
0
votes
0answers
10 views

Google forms - How to capture a list of items from user?

I wish to use a google form to capture user input in the form of a list? The default question templates do not allow it, is there an add-on I can use? Following is the desired template.
1
vote
1answer
17 views

Insert a weekday in Google Forms' date selector

We have created a Google form that works perfectly, there is only one issue, and that's the DATE selector, it sends the DATE, but we would like to receive the DATE and the WEEKDAY in the form we ...
0
votes
1answer
31 views

Re-using a google form sent data, avoiding entering all data

I am building a Google form to manage summer camp subscriptions. Each request must enclose parents and child data. The problem is, if a family wants to subscribe more than one child, the process must ...
0
votes
1answer
13 views

Data cleaning in Google forms

I've recently conducted a survey using Google Forms. The graphs and charts in the summary section are enough for me. However, I want to clean 10% of data (change ambiguous answers). Is there an easy ...
1
vote
1answer
13 views

How to find a spreadsheet to which a form submits?

In my organization, we have recently found a form that is supposed to collect some kind of submissions from people. The problem is that we don't know who exactly created it and where are the answers ...
0
votes
1answer
23 views

Look up a list embedded in a Google Sheets from a Google Forms, and add attributes to the corresponding row?

I'm running an event for a large number of children and need a way to let them register quickly as they come in, to the event. We're expecting about 400 kids who have pre-enrolled and we will have a ...
0
votes
2answers
17 views

Prevent shifting of rows in auto-updating sheet

I am struggling with an automatically updating spreadsheet that is connected to a Google Form. Whenever there is a new accomplished answer in the Form it is adding a row in the spreadsheet, resulting ...
1
vote
1answer
12 views

Lost responses from Google Forms

I have updated my form with some responses recorded. After deleting one question section, the responses for that question disappeared. Can I still get to them?
0
votes
1answer
12 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
0
votes
1answer
80 views

Is it possible to recover deleted responses from Google Forms?

Here is the context of this question. We used Google Forms for an election of 6 people. I want to know if it is possible to delete individual responses and then recover all responses (deleted and not ...
0
votes
1answer
13 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
0
votes
1answer
27 views

How to assign internal names (“programmatic”/cryptic and non-visible for the form participant) for each question in a google form

Is there any way to set question cryptic-name/variable in addition to the question visible to one answering the form. What I need is that when I export forms questions to google sheet I can ...
0
votes
1answer
20 views

How to disable new row when Google Form collects responses for Google Sheet?

When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I ...
0
votes
0answers
28 views

How to print Google Form section

How to print each section of Google Form? I want to print section A and then section B but there should be no title for section B.
0
votes
0answers
19 views

Is it possible to stop Google Forms adding a sequence number to each question when printed

I have set up a form in which each section has its own number and each question within the section a sequence number based on the section number. All is fine when the form is being send by email, ...
0
votes
1answer
26 views

Google Forms Quiz Response Sheet

I have added a couple of columns to the Google Sheet Responses for a quiz created using Google Forms. When creating the response sheet (created in the "Responses" tab of the quiz, it automatically ...
0
votes
1answer
35 views

Reconnecting form responses to current sheet after file move to Team Drive

I have searched for an answer for the "current" Google Forms problem I am having. It seems the answers here for this issue are outdated as Google keeps changing their technology about as fast as I ...
0
votes
1answer
44 views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...
1
vote
1answer
34 views

Create a Google Classroom assignment in which students cannot attach files

How can I create an assignment that only allows students to submit their answers via an attached form? I tend to assign questions to be answered via Forms, but sometimes students answer by attaching ...
0
votes
0answers
19 views

Google Form File Upload - Change File Name to Match Form Value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
2
votes
1answer
29 views

Google form anonymity in organization

I have a Google account that's part of an organisation. There's this form that only people in the same organisation can respond to. Is there a way for the owner of the organisation to find out that it ...
0
votes
0answers
56 views

URL code for Google Form section

I have Google form with 10 section(lets call it page), and I use app inventor to create the mobile interface. The problem is when I get the pre-fill link with a link to be execute: https://docs....
1
vote
0answers
26 views

How to add text box at the end in Google Forms

I need to add at the end of the Google Form a piece of text saying that respondents can withdraw their consent at any one time. Is it possible? How?
0
votes
0answers
23 views

Google Forms, can I let the responder name a row in a grid?

I'm creating an RSVP form and wanted to let the answerer write a list of participants and for each pick from a multiple choice. It should look something like this: name vegetarian ...
0
votes
0answers
18 views

unique numbers based on respondent's answers

I am managing a group of participants (example: doctors, nurses,etc) in filling the form, each participant chooses an option according to his goup (doctor, nurse, etc) i want different sets of unique ...
1
vote
1answer
86 views

Google Forms sending me duplicate email on automatical email

So, I've used this code, just reworked for my needs: Can Google Forms send emails automatically? The problem I have is that the account that sends those emails also receives them. Is there a way to ...
0
votes
0answers
20 views

How to record Google Form responses back to Google Sheets

I am a beginner in Google scripts. I have learned how to write to a Google scripts sheet using the examples below. However, I do not know how to set the range ("?") Because the range ("AB7") will ...
1
vote
1answer
33 views

Populating alternatives in question 2 based on answers in question 1

I have ten people who sell something to companies, and I want to track what they do IN GOOGLE FORMS. Every agent has his own 10 companies that he contacts. So, in Question 1, I will have a drop-down ...
0
votes
1answer
17 views

Google Form reply to form respondents from a @domain email

I'm using Google Forms to create a survey but the auto response email has my personal email account in it. How can I change it so the from: is, for instance company@company.com instead of company@...
0
votes
0answers
34 views

Generating unique 4 digit code as Google Form response

I want to generate a unique 4 digit code to send to submitter as an unique code validation. I work in an environment where customers inform us of their names but they interchange it between English ...
0
votes
1answer
96 views

How to upload a photo from mobile phone to Google Forms as an answer?

One can choose file upload to Google Forms, but when answering in form option only opens Google Drive upload dialog. Is there any way to upload photo from mobile phone as an answer? E.g. is it ...
0
votes
1answer
42 views

How to use the “Make a Copy” trick when sharing a Google Form?

I want to share a Google Forms file with customers and, when each one of them open it, I want the file to automatically ask them if they want a copy of the file in their own directory.
0
votes
1answer
16 views

Active Survey Modification

I have a live survey via Google Forms. I want to edit one of the multiple choice questions. What will happen to the existing data? Will I lose the previous answers? Is it safe to modify one of the ...
1
vote
1answer
23 views

Share Google Form's result publicly with a link

I would like that the user who completed the form can share the answers to his questions with a link, and anyone with that link can see the answers. Is it possible?
1
vote
0answers
17 views

When importing a Google form submission to a spreadsheet, how do I automatically change the time format from “d-m-yyy” to “dd-mmm-yyy”

I am importing information from a Google form into a spreadsheet. It imports live. It creates a time stamp. There are also several other dates in the form (when you type it into the form there is only ...
1
vote
1answer
378 views

Show quiz result on the same page in Google Forms

Google Forms allows to create questionnaire and make it like a quiz in order to get score to correct answers. I created a quiz in Google Forms but after submitting answers to all questions it shows a ...
0
votes
1answer
1k views

Submit another response missing from Google Form

If I create a new Google Form, and leave the "Limit to 1 response" option unchecked: At the end of the form, the user will see a "Submit another response" link: However, I have an existing Google ...
0
votes
0answers
26 views

How to create a chart with list of values as aggregated separate values?

I'm trying to do something similar to how Google Forms populated my data (which was with checkboxes, where multiple options could be checked): This data in Google Sheets is represented as a column, ...
0
votes
0answers
17 views

Flow and Google Sheets automation inserting data stating at a certain cell?

I have set up a form for a user to request a WiFi account through Google Forms and Flow. I already have two columns set up as username and password for all the default accounts I need to add the data ...
0
votes
0answers
18 views

Copy previous submit form

We need to make a copy of submitted form, we need to entry almost 90% same data as previous entry. Any one have same issue, please share if you have solution on this Google Form ? ( same function as ...
0
votes
0answers
127 views

How do I make a Google Form public on the web, but for viewing only? [duplicate]

I'm trying to share a Google Form document in Google Drive and make it public to view, but I don't want anyone to be able to edit it. If I set the link sharing mode to anything other than "Off", the ...