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.

Filter by
Sorted by
Tagged with
2
votes
3answers
2k views

How to delete email addresses from Google Forms reminder list?

Google Forms sorts respondents into those who replied and those who need reminding. I sent a form to 100+ people and now find the list has diminished to 85. I no longer need a response from certain ...
0
votes
1answer
30 views

Are Google Forms meant to be “writable” AND the results also “readable” from a website

Overall, I'm looking to create a website where the user needs to pass a little quiz to see each additional level of content (and ought never have to quiz again for each higher level). He/she will see ...
0
votes
1answer
431 views

Create triggers on recently programmatically copied Google Forms

I have this main Form that uses its responses to create several other Forms after it's been submitted, but I need that these Forms that were recently created to send emails on their submissions ...
4
votes
2answers
1k views

How to update VLOOKUP results in Google Sheets to most recent input from Google form?

I am trying to create a formula that pulls responses from a Google Form and organizes them into rows correlating with a client's name. The name is entered manually in and also appears in a drop-down ...
1
vote
1answer
43 views

Google Form to Web Page

Would like to be able to gather data using a Google Form and then display that data on a web page with a unique URL to that data. We would take that URL and then paste it in a contact record in our ...
1
vote
0answers
580 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
votes
1answer
374 views

Google Apps Script for converting military Timestamp into 12-Hr in Forms submissions?

Has anyone created a script to use in Google Forms/Sheets to convert or display the military time to 12-hour instead once the form has been submitted by a user?
0
votes
1answer
628 views

Assigning responses to different tabs based on the month on timestamp

I am collecting responses from a form and would like to separate them into different tabs based on the month of the timestamp on the response. Kinda lost on using the date/ month function in the query....
2
votes
2answers
2k views

Review answers before submitting the Google Form

I need to echo the answers before the form is submitted so the user can check them, but I couldn't find any way of doing it through a script or app. How can I do it?
0
votes
1answer
1k views

How can I make a short answer response into a question?

I want to survey some beliefs of people. I am asking them to enter some beliefs, and then rate the percent at which they believe it. Later in the form, I plan to test how much they believe these ...
0
votes
1answer
462 views

Dynamic description in Google Forms?

I'm trying to set up a form that can be reused monthly. Questions will be the same from month to month, but with different focus. For instance, a question is named "Marketing". In October I want the ...
1
vote
1answer
133 views

Google Docs form attachments

I have created a Google Docs form where respondents can upload attachments. I gave edit privileges to other colleagues but every time they go and check form responses they need my approval to open the ...
0
votes
1answer
988 views

How to create a question in Google Forms that allows two sub questions?

I have a question like this How can I create a question that contains two sub questions in Google Forms? The person answering each question must complete two sub questions in each question.Since each ...
2
votes
1answer
3k views

Google Form can be edited, or not viewed at all - where is the view only option?

I am trying to create a Google Form. I am unfamiliar with Google Forms, but I am familiar with Google Sheets and Docs. I'm having a problem with the form, however. When I go to the Sharing Settings ...
0
votes
1answer
200 views

How to set the Title of Form in a popup of Google Spreadsheets as a link?

I have changed the sheet keys below for confidentiality. How to I set the Title of Form in a Popup of Google Spreadsheets as a LINK. What which was the Popup that created by me? Attempt 1 :      THE ...
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 ...
2
votes
1answer
305 views

What script / function would allow me to subtract a value from a unique account

I have an item shop and bank account set up for my students in class using Sheets. Currently students purchase their items via Google Forms and it logs their order in a Sheet. Normally, I would find ...
0
votes
0answers
3k views

How to use a table or grid in a Google Form

Has there been any movement in the ability to insert a table in Google Forms? I am trying to use one of the Google apps to receive rosters with 6 columns and 20 rows. I'm feeling like a table in a ...
0
votes
1answer
118 views

How can I embed an HTML5 canvas in Google Forms?

I am trying to create a drawing response in Google Forms. I am looking to create an add-on using Google Script to make this happen. I am thinking that I will have to use HTML5 canvas, but I'm not ...
1
vote
1answer
2k views

Having Rich Text in Google Forms

In my Google Form, I have a question whose answer will be free text. But I want user to be able to format the text if needed, especially add bullets and numbering. Is there a way to do it?
0
votes
1answer
4k views

How to split data across multiple rows when submitting from Google Form

I have a google form that acts as an event registration form. I would like to add the ability for multiple people to be registered on the same response submission but then have a report with only the ...
3
votes
1answer
5k views

Is it possible to poll for a schedule?

I want to offer a form that asks people about their availability. Below is what I did using the Multiple Choice Grid, but it doesn't allow respondents to check more than one item per row (like saying "...
0
votes
2answers
2k views

Group file responses from Google Forms into individual folders per submission

For a given sample form My Form and a file TheFile.pdf, file uploads on Google Forms are uploaded like this: My Form (File Responses) > Question 1 to upload file (File Responses) > TheFile.pdf Is it ...
0
votes
1answer
134 views

Can one Google Form store a constant to be called and resubmitted in another?

Long story short, I have two forms for a timed quiz, the intro form, which gathers user ID information and when submitted gives a link to the quiz itself. I use the relative timestamp between the two ...
1
vote
1answer
434 views

Is it possible to embed a Google Form into a Gmail signature?

I'm trying to figure out how or if it's possible to embed a Google Form (a customer satisfaction survey) into my employees email signatures so that it's automatically there when they compose an email. ...
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 ...
0
votes
1answer
612 views

Arrayformula+VLOOKUP find value of non-empty reference (callback/recursion problem)

Similar to An arrayformula to find the previous non-empty cell in another column. I have two worksheets like this: "" = Blank cell () = Sheet Name Worksheet One (Form Responses 4) is the input ...
2
votes
1answer
2k views

Validate age (>18) Google Forms?

I working on this form that has to be filled only by those over 18 years old. I was wondering if is possible to ask for the date of birth or the age in the first question and if is over 18 then the ...
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 ...
1
vote
1answer
697 views

Can you make a Google Form fill the whole screen?

i.e. make it landscape and remove the grey bars down either vertical slide?
0
votes
2answers
719 views

Google Sheets/Forms Script Due Date Reminder email Sends Wrong Response Edit Link

The system I set up does the following: a user submits a form a confirmation email is sent with a link to edit the response (so far so good) in the form, there is a 'due date' question a trigger ...
1
vote
1answer
867 views

Two yes-no questions, if both anwers are yes go to section 2 and 3, will skip section 2

I'll make a survey with Google Forms and add two yes-no questions. If both answers are "yes", they must be navigated to sections 2 and 3 of my survey. Below you could find a scheme: ------------------...
1
vote
2answers
1k views

How to write a script/formula for Google Form Responses to send submitted form to different emails based on a response?

I have a registration form that we are using for my company. We have 6 locations. I want to have the registration form that is filled out on Google forms to go to specific emails based on their answer ...
0
votes
1answer
6k views

Creating Google Forms from Google Spreadsheet

It is possible to use the FormCreator app to create Google Forms using Google Spreadsheet. My question: how did app manage to achieve that?
3
votes
1answer
623 views

How do I generate unique identifiers for responses from multiple forms, linked to a single Google spreadsheet?

I have linked multiple Google forms to a single Google spreadsheet (each one to a new tab in the sheet) and I now want each response be assigned a unique identifier when it is received. I've tried ...
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 ...
0
votes
1answer
568 views

Set field's names in Google Forms for results analysis [closed]

I'm creating a Google Form with a csv output. How can I set the field names so that afterwards I can have a csv with computer friendly, unique header names? Since I suppose this feature doesn't come ...
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
2answers
780 views

Collecting the same email address in a Google Form

Hopefully this isn't confusing. I'm wondering if there's a way of using a preset email address instead of collecting users email addresses in a form. Essentially, I'm looking for all the form ...
0
votes
0answers
539 views

Edit email address in Google Form

Here's the steps I took: Made a quiz in Google Forms. Enabled email address collection. Sent out the quiz to twenty-five email addresses. Stopped accepting responses. Released the scores. However, ...
0
votes
1answer
1k views

Google form reference number

Once clicking on Submit - can each person be given a reference number? Refernce number must be included in the spreadsheet. Each person needs to make payment and we need them to use their reference ...
1
vote
1answer
186 views

Google Form to a Spread Sheet

I want to create a Google Form that a teacher can fill out a Discipline Form when sending a student to the office. That form will them notify the principal that a new form was sent to them and they ...
1
vote
1answer
4k views

Moving Google Form into Google Docs

My daughter has a survey in Google Form and wants to put the form as an appendix in her Google Doc. Is there any way to produce a "Word" version of the form--with the questions and check boxes as one ...
0
votes
1answer
2k views

Trailing zeros in Google Spreadsheet automatically removed from form submission

When I submit a Google form field with a value of 0.0 or 1.0, the 0 after the decimal is omitted in the spreadsheet results. When I submit number other than trailing zero, e.g., 1.5 , it posts fine as ...
2
votes
1answer
577 views

How to insert blank fields while inserting answers from Google Sheet to Form

I have set up a script to insert existing answers into my Google Form from a Google Sheet (by adapting the code from this answer). I inserted it into the Forms Scripts and it works when all fields in ...
1
vote
2answers
16k views

Edited Google Form while users were responding - how to recover initial responses?

I have utilized Google Forms to create a mid-term exam for my students. However, after they started taking the quiz, I went in to edit and simply added a section after the first question and now, ...
0
votes
1answer
126 views

Generating various email responses based on results from one Google Forms

I have a google form that has multiple sections and a different set of questions depending on the answer to the first multiple choices. I want to be able to send an email and use a different body ...
2
votes
1answer
2k views

How to set input type = “tel” to the answer input field?

In my Google Form I've got multiple text questions with answers with data validatation set to numbers only. Unfortunately when I enter the answers using the mobile browser the keyboard shown is full, ...
1
vote
1answer
2k views

Using manually entered columns along with data input through Google Forms

I have a simple spreadsheet with a date in column A, an event description in column B, a number (of hours worked) in column D, a calculated number (hours worked * hourly wage) in column E, and some ...
-1
votes
1answer
412 views

Google Forms hidding options on mobile devices

How do I prevent multiple choice grid options being hidden like in the image below? In this case the 4th option is hidden and the horizontal scrollbar isn't shown, what might drive users think ...