The Stack Overflow podcast is back! Listen to an interview with our new CEO.

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.

122 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
5
votes
0answers
407 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
10 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
410 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
281 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
459 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
807 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
166 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
218 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
34 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 ...
1
vote
0answers
22 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
28 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
195 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
114 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
102 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
67 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
31 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 ...
1
vote
1answer
16 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
275 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
225 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
17 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
234 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
51 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
538 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
50 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
22 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
1k 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
468 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
6k 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
2k views

Fill out google form using an api

I have a private google form I need to fill out every day, so I would like to write a script to authenticate me using my google credentials, and then fill out some of the form programatically, is ...
1
vote
0answers
145 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
372 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
586 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
62 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
728 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
60 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
583 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 ...
1
vote
0answers
208 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 ...
1
vote
0answers
289 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 ...
1
vote
0answers
1k views

Checkbox grid in Google Forms?

Let's say we have 5 volumes each having 20 books. I want to submit a request to order: Volume 1 Books 18 - 20 and then: Volume 2 Books 1 - 5 Is there an elegant way to do this in Google Forms? ...
1
vote
0answers
484 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 ...
1
vote
0answers
610 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 ...
1
vote
0answers
43 views

Narrow sample space down with Google Forms evaluation

I got the results from a survey I did with Google Forms. The survey results are stored in a Google Spreadsheet (150 rows). I really like the feature to get the results in diagrams automatically, but ...
1
vote
0answers
1k views

Google Script: setValue function on form submit

I have written the following code function myFunction(e){ var options={cc: 'x@abc.com'}; MailApp.sendEmail(e.values[2], "New SMS Blast request", "A new SMS blast request has been entered, the ...
1
vote
0answers
292 views

Using a Live Google Form inputs for calculations

Spreadsheet is not recording responses from form I am able to see from responses appear fleetingly before they vanish. They are however indicated in summary I have tried un-linking, re-linking, ...
1
vote
0answers
165 views

Google Forms: Accepts forms with a specific sum of numeric fields

I am building a voting lottery form for my friends. Each participant should guess the number of seats that every party will gain in the upcoming Israeli elections. Each party is a required field, ...
1
vote
0answers
337 views

Can I make a list option unselectable in Google Forms?

Similar to the HTML <option> attribute disable, I want to make a Google Forms list have some options that are visible but unelectable. Is this possible?
1
vote
0answers
1k views

Allow multiple votes for the same option in Google Forms

I am trying to make a Google Form where users are allowed (or required) to cast two votes, and they are allowed to vote twice for the same option. Is that possible? I haven't been able to figure it ...