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.

150 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5 votes
2 answers
3k views

Google Forms Answer Validation Based On Another Previous Given Answer

I am working on a form in Google Forms. At some point during my form, I need to validate an answer based in a previous answer. To make it more clear, I give you an example: How many hours do you ...
user avatar
  • 51
5 votes
0 answers
430 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 ...
user avatar
  • 253
2 votes
2 answers
19k views

I lost my response in Google Form after accidentally deleted the questions

I created a google form this afternoon and there were lots of response that I received. And then I accidentally deleted all of the questions and I thought I can simply edited it back. when I edited it ...
user avatar
2 votes
1 answer
1k views

Importing data into Google Form response sheet with date, list, grid

I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
user avatar
2 votes
1 answer
672 views

Google Sheets - Query Multiple Columns for same Data

We have Employee training data in a Google 'Form Response' spreadsheet which ranges from A1 to JQ1000. This spreadsheet is automatically populated when a Google Form is completed but it is difficult ...
user avatar
  • 121
2 votes
2 answers
5k views

How do I get Google forms edit url to work

I want to generate an edit url link in the google sheet for a google form which is linked to it. There are already instructions on how to do it. However they do not work for me. I have followed the ...
user avatar
  • 21
2 votes
1 answer
3k 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?
user avatar
  • 21
2 votes
2 answers
6k views

How to pull last value in a Google Sheets column and populate it across another worksheet column?

This is my first post here- I hope this is the right place for it, apologies in advance if it isn't. Context: I have a password protected presentation that I need to give users access to, but only ...
user avatar
2 votes
1 answer
977 views

How to send Google Form results to a particular sheet ("tab") of a Spreadsheet

Is there a way to create a Form that submits to a particular TAB of a Google Sheet? Use Case: We are using this for meeting pre-check-in. There's standard form. I'd like the results for each ...
user avatar
  • 2,981
2 votes
0 answers
297 views

Color customization in Google forms

Google forms is automatically altering color when I insert a custom photo banner (which does not match our brand). How and where can I enter in a specific color code (if possible)? Is there a specific ...
user avatar
  • 21
2 votes
1 answer
547 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 ...
user avatar
2 votes
0 answers
1k 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 ...
user avatar
  • 21
2 votes
0 answers
228 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.
user avatar
2 votes
0 answers
222 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 ...
user avatar
1 vote
2 answers
668 views

Hide Respondent's Email Address in Google Form

When someone responds to my Google Form, it displays their email address at the top of the form. I've disabled the option Disable autosave for all respondents in the form settings but the message ...
user avatar
  • 1,918
1 vote
0 answers
383 views

How to retrieve Google Form and its 240 responses that have disappeared

Please help me retrieve my Google Form and its 240 responses have disappeared. Those 240 responses have been collected over 2 years as part of my thesis survey. I could access the form and responses ...
user avatar
1 vote
1 answer
2k views

How can I merge responses of two Google Form identical to each other but in two different languages

I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
user avatar
1 vote
0 answers
64 views

How to find out the Google accounts that have answered a Google Form?

I have created a Google Form, but I have forgotten to add a 'fill in your email address' question. As a result I can not contact the applicants that have already completed the form. Unfortunately I ...
user avatar
1 vote
0 answers
28 views

Pull data from separate Google Sheet into a Google Forms response sheet and update dynamically

I have a Google Sheets leave sheet for employees where we track the leave days due and days already used. I also have a Google Form which submits responses to linked sheet and runs with Form Publisher ...
user avatar
  • 11
1 vote
0 answers
359 views

How to retrieve sections of a form I accidently deleted (including the surveyors responses)?

First time using Google Forms and I was so impressed! It was doing everything I needed for research on a book I am writing. However, Thursday night... on my phone looking at some responses I ...
user avatar
1 vote
0 answers
13 views

I want to send Google Form response to an Email address entered on the form

When a user completes the form to attend a conference. I ask for another email address so their supervisor knows they have signed up and for what date. How can I use the field on the form as the ...
user avatar
1 vote
0 answers
57 views

Google Form - Updates made after release

I created a quiz in Google Forms and released the scores to the students with my feedback. I am a big proponent of students revising their work, so I allow them to "edit after submit." ...
user avatar
1 vote
0 answers
37 views

Google Form to sheet to Doc, with calculations after pushing to sheet

NOTE! I am not a programmer I'm just fumbling through this! I've gotten as far as I can with searches, getting lost on multiple steps as most responses don't integrate on thing to the next. Background ...
user avatar
1 vote
0 answers
42 views

Array formula to extract N non blank cell in Row 1-16

I have a google form where team coaches input which players played on a given day. They also input if they were Man of the Match, Yellow/Red Cards Received, and how many Goals they scored. When the ...
user avatar
1 vote
0 answers
37 views

Combine imported JSON with Google Forms data

I've been watching the protests unfold and I see a lot of police brutality from videos and descriptions people have shared online. I found a GitHub where all of this is collected and I want to use ...
user avatar
1 vote
0 answers
33 views

How can I update the list of answers to an upcoming question in Google Forms based off of previous answers in the same form?

The title makes this sound more difficult or complex than it actually is. What I'm trying to accomplish is to build an entire elimination bracket prediction picker through Google Forms. I would have ...
user avatar
  • 33
1 vote
0 answers
59 views

Can I add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form?

I need to add a unique autoincrement field to multiple answers in a column in a Google Spreadsheet based on a Google Form. I was able to add the function trigger in scripts but I need to add the ...
user avatar
1 vote
1 answer
205 views

Can I set a limit of 2 entries on Google Forms?

I use Google Forms in my classroom to administer certain quizzes, however, I allow my students two attempts on these. I have noticed that I am unable to see how may actual attempts have been made and ...
user avatar
1 vote
0 answers
177 views

How to change font style for Description, Response and other fields?

My research shows that old version of Google forms allowed to set different font styles for EACH type of field (question Title, Description, Response etc.). It used to be possible to switch to the ...
user avatar
  • 11
1 vote
1 answer
658 views

Conditional checkbox in Google Forms

I'm creating a peer evaluation on Google Forms. The first question is for students to select their name. If the student has selected his/her name, the choice for his/her name will not appear in ...
user avatar
  • 11
1 vote
1 answer
345 views

Google Form response is modifying a cell on another row of linked sheet

I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...
user avatar
1 vote
1 answer
896 views

Hide skipped sections in responses

So, I've got an example form here with some conditionals. The flow is intended that it skips ahead to a specific section depending on the initial response—the usual. My issue, however, is when ...
user avatar
1 vote
0 answers
164 views

Can Google Form send email automatically based on entered field?

I would like to use Google Form as a help desk, hoping to find a script that can send email of the submitted form responses to different people depending on their option in one of the question? i.e. ...
user avatar
1 vote
1 answer
368 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 ...
user avatar
  • 11
1 vote
1 answer
257 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 ...
user avatar
  • 11
1 vote
1 answer
2k 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 ...
user avatar
1 vote
0 answers
25 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 ...
user avatar
1 vote
1 answer
739 views

Google Forms to spreadsheet edit responses and new responses on the top

I've created a Google form and I want to be able to drag the rows into categories below it, but I want the new responses to always show up at the top. Instead, it follows the previous row. For ...
user avatar
1 vote
0 answers
220 views

How do I edit file responses on Google Forms after submission

On a Google form that allowed me to edit my responses after submission, there was a question that asked me to add a file. I did just that and turned it in. Now I want to replace that file. I can edit ...
user avatar
  • 11
1 vote
1 answer
694 views

Linking multiple script created forms to 1 sheet in pre-existing spreadsheet

I work in manufacturing. I have created a Google form for our leadership safety audits which requires unique information (name(s), area being audited, and date) and also includes 25 multiple choice ...
user avatar
1 vote
0 answers
986 views

Adding multiple choice questions to sections of a Google Form via Script

I am working on a survey using Google Forms that I generated via a script. There are over 2000 questions that are all the same format but are broken up into different sections. So, for example, ...
user avatar
1 vote
0 answers
81 views

Auto-update specific cell in a spreadsheet depending on answer from a Google Form Response

My spreadsheet has two tabs Google Form responses Schedule of regular tasks The Google Form gathers data about a specific task and records the date of completion for that task. When a user has made ...
user avatar
1 vote
0 answers
1k views

How can I change Google Forms style to put multiple textboxes on the same line?

I want to conduct a recognition task for Chinese characters online. People who fill out the task will have to read the Chinese character, and type out the pronunciation of the character in English ...
user avatar
  • 215
1 vote
2 answers
72 views

Need questions related to initial questions?

I'm trying to make a google form that my friends and I can use to enter our board game scores into an excel sheet, which then calculates our overall and per game scores... Does anyone know how/if I ...
user avatar
  • 11
1 vote
0 answers
1k views

Need to add new data manually to Google Forms response sheet already in reverse chronological order

I have a Google Form, and I have re-organized the answers, in a separate tab where they're being captured on a Google Sheet, so that they are in reverse chronological order. I need to manually add ...
user avatar
1 vote
0 answers
904 views

Edit URL, Google Forms

Is it possible to get the edit URL of Google Forms if you are not sure of the form response number? For example, I have 2,000 forms submitted and I would like to generate the edit links for them now ...
user avatar
1 vote
0 answers
219 views

How to send mail to the client after submitting Google Form?

I create a Google Form. I want to mail my client when he submit the form. Now, I am doing this using form notification add-ons. But, problem is, I can't send any text that refer to a link. I use <a ...
user avatar
  • 111
1 vote
0 answers
356 views

Google Forms: Subquestion based on lookup

This question is similar to the one here: How to make subquestions in Google Forms? I want folks to pick from a list of projects, and then on the second question, pick from a list of phases for the ...
user avatar
1 vote
0 answers
808 views

Cancellation of form submission link in email, Google forms and Google apps script

For an approval workflow, I am using standard Google Forms and scripts behind the Google sheets to get approval from managers. Is it possible to click "Cancel" link in the email and be redirected to ...
user avatar
1 vote
1 answer
1k views

Easy way to create a Google Form with a lot of images?

I'm trying to create an online survey with multiple images, where each participant would write what they call the thing depicted. Each question would be composed of an image and a textbox for the ...
user avatar
  • 103