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.

146 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
415 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 ...
4
votes
1answer
1k 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 ...
2
votes
2answers
260 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 ...
2
votes
1answer
441 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 ...
2
votes
1answer
40 views

I was sent a google form (link) and can see the senders answers

I was just sent a link by a colleague to a google form. I can see that they ran a test of the form with "dummy' answers. Can the sender change this so that others don't see their responses in the form?...
2
votes
1answer
85 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 ...
2
votes
1answer
943 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.
2
votes
2answers
3k 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 ...
2
votes
1answer
527 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 ...
2
votes
0answers
293 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 ...
2
votes
0answers
478 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
1k 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
896 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 ...
2
votes
0answers
199 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
219 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
18 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 ...
1
vote
0answers
23 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 ...
1
vote
0answers
16 views

Automate Google Groups and Google Forms

I have a Google Groups that only accept invited members. I really want a Google Form where member input their email address and automatically an invitation to the group is sent to their email. As soon ...
1
vote
1answer
15 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 ...
1
vote
1answer
24 views

How can I populate and submit a Google form using info from Google Sheets?

I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
1
vote
1answer
24 views

Google Apps Script send attachment on cell value

First of all I am a complete beginner in coding. So I am trying to build a form, that once it is submitted, will send a different gdrive file as excel sheet based on a key word in the form. So far I ...
1
vote
0answers
29 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 ...
1
vote
1answer
167 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
29 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 ...
1
vote
1answer
318 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 ...
1
vote
0answers
442 views

Anonymous voting on google forms

I have this situation: A group of people must vote using Google Forms. Their voting choices must be anonymous. But, they don't have gmail accounts and we would like to collect who has voted and who ...
1
vote
1answer
47 views

How do I get responses in Google Forms to automatically be updated when updating the spreadsheet?

I'm in a situation, where I have been given a source of information, with all sorts of people. And with that, I wish to insert all this inside of Google Forms, in the response section. And so I was ...
1
vote
2answers
258 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. ...
1
vote
2answers
904 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 ...
1
vote
2answers
25 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 ...
1
vote
1answer
1k 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?
1
vote
0answers
566 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?
1
vote
0answers
44 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. ...
1
vote
1answer
308 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 ...
1
vote
1answer
145 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
703 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.
1
vote
0answers
23 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
2k 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 ...
1
vote
1answer
549 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 ...
1
vote
1answer
10k views

How do I find out who created a Google Form

I opened a Google Form and can't find it on any of my Google accounts - perhaps a colleague created it. Students have responded, but I can't find the original to see the responses. Is there any ...
1
vote
0answers
182 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 ...
1
vote
1answer
502 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 ...
1
vote
0answers
728 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, ...
1
vote
0answers
68 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 ...
1
vote
0answers
973 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 ...
1
vote
2answers
64 views

Google Form - 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 ...
1
vote
0answers
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 ...
1
vote
0answers
758 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 ...