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
-1
votes
1answer
38 views

Is there a way to add a document to a Google Form so that end users can access it to answer questions?

Is there a way to add a document to a Google Form so that end users can access it to answer questions within the survey?
0
votes
1answer
37 views

Brainstorm Phase - Daily Turnover: Submit and retrieve using Google Sheets?

I'm working on moving from an awful Excel document to a Google Sheet where employees can type in notes on a "Form" and have it record the data as a "record". ____________ When the user opens the ...
0
votes
1answer
79 views

Not able to send my Google Forms anymore because of sections

I was able to send an answer of a Google Form yesterday. I modified a bit the form, adding more questions and making some of them compulsory and I'm no more able to send the answers with the blue ...
1
vote
0answers
483 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 ...
0
votes
2answers
669 views

See Google Form results when not the owner

I'd like to know if there was any way of seeing the results of a Google Form if you are not the owner. This would be important as I need to find out the results.
1
vote
2answers
3k views

Prefill a Google Form link using data from spreadsheet with text masking

I've been struggling with this for a few weeks and have gone as far as I can with my limited knowledge of formulas (and my totally absent knowledge of scripts). I'm trying to create a prefilled link ...
0
votes
0answers
999 views

Submit button not working inside Google Forms popup in Google Spreadsheets

I made a button inside my spreadsheet, if I click it, a pop-up appears inside the spreadsheet (as an overlay), inside the pop up my specific google Forms form is displayed (IFRAME). If I fill out the ...
1
vote
1answer
8k views

Conditional branching in Google Forms (checkbox)

I'm creating a google form and I've stumbled across this issue: I have a checkbox with options, say: A, B and C; so that it's possible for a respondent to choose more than 1 answer. And I have the ...
1
vote
1answer
567 views

Regular expression in Google Form crashes browser tab

I'm using a free text field in a Google Form. Users should be able to enter the name of a product followed by its price, then start a next line for the next product. To validate their entry I want to ...
0
votes
1answer
699 views

Display updated data from a Google Form

I have a Google Form where I want to display data from a linked spreadsheet. Here's the process: student submits FormA teacher enters a 'passcode' (via section with data validation) to provide ...
2
votes
1answer
799 views

How to edit fixed link text in Google Forms

Does anybody know if its possible to edit the link text in the confirmation form of a Google Form? Having enabled the summary of responses, I have the following link text which is set by the form: '...
1
vote
1answer
787 views

Share Google Drive Folder with submitters of Google Form

I have a Google Form that is used as a sign up form. This form has a question requesting emails. It uses the email validation. I have a Google Drive folder that I want everyone who signs up to be able ...
0
votes
2answers
711 views

Forms, multiple selects leads to sub-questions for each selection

Can this kind of form be made with Google forms? Problem: First page: user checks few boxes from the menu. Second page: for each of the first page selects - few options are given. Example, user ...
2
votes
1answer
52 views

Sending formulas with Google Forms

I'm trying to give a formula using the equal sign, when submitting a Short answer in a Google Form. If I'm writing =6+3 into the form and then submit it, I get the string '=6+3 in the Google Sheet ...
2
votes
1answer
843 views

Google Sheets can not use Google form data in formulas [duplicate]

I have a Google Spreadsheet with two sheets. The first uses formulas to manipulate the second sheet row by row, and the second is fed by a Google form. My first sheet has formulas as such: A2: int('...
1
vote
2answers
83 views

Does Google Forms have two versions: consumer (@gmail.com) and Google Apps for Work versions?

I have to build Google Form integrations to migrate data from a form and make changes to email, calendar, contacts, sheet and drive (all Google apps). I am getting results for Google Apps for Work ...
2
votes
1answer
270 views

Google Forms submitting to Google Sheets - Creating a “Dashboard”

I currently have a task request Google Forms submitting tasks into a Google Sheets. I'd like to use that sheet as a database for a 'Front End' that allows me to select a status for a project (this ...
5
votes
2answers
30k views

Can Google Forms send emails automatically?

I used Google Forms to create a form for people to register for an event, by entering their name and email address. I would like to set it up so that when a person enters his name and email, the ...
-1
votes
1answer
237 views

Is there a way to have respondents attach a file to a form response? [duplicate]

I need to have a form with the normal questions, in addition to having respondents attach or download a file. Is this possible?
1
vote
1answer
36 views

Is it possible to add an image at the side of a form component?

I'm trying to add an images to the left of each of my form components (multiple choice, linear scale, etc). Basically I want an image to serve as an icon for each form component. Adding an image like ...
2
votes
1answer
880 views

Change the color of a Google Form response when printing

The text color of a Google Form response is very pale when I try to print an individual response. (See the word John Doughnut in the second picture) How can I darken it or change its color?
2
votes
1answer
6k views

Is it possible to show dynamic information in a Google Form based on a previous response?

I set up a form to specify the location of household appliances in a residence. The form is based on a unique code assigned to each household. (it's working properly) To avoid entry errors, I would ...
1
vote
1answer
4k views

How to set up meetings/appointments through time slots using Google Forms

I am creating a form response, using Google forms. The module should be posted on my (Google) website and should be used by people to set meetings with me. I provide some options regarding the ...
2
votes
1answer
1k views

Copy submitted form data to new automatically generated Google sheet

I have created a new sheet for every new name entered in the form using the following code. function formSheet(e) { var sheetName = e.namedValues['Name'][0]; SpreadsheetApp.getActiveSpreadsheet()....
4
votes
1answer
6k views

Auto-create and name new sheet in Google sheets from names being filled from a Google form

How can I automatically create and name new sheets in a Google Spreadsheet from a list of names which are being input in the sheet from a Google Form? I would like each new sheet to be created when a ...
2
votes
1answer
468 views

Is there a way to get the summary section from a form into a Google Doc

I've got a survey using Google Forms and it has useful graphs in it's summary section (under responses). How can I get these graphs into a Google Doc? I tried downloading the CSV file and recreating ...
0
votes
1answer
521 views

Is there a script to draw a list of variables from a table to Google Forms?

I would like to have a field in Google Forms that allows the user to select a value from a "List" of values. The options in the list being drawn from a list in the sheet itself. This allows me to add ...
2
votes
1answer
884 views

Sending emails onSubmit using Google Apps Script Web Forms

Is it possible to send emails onSubmit() with Google Apps Script Custom Web Forms just like we can do using mailApp with Google Forms? I am currently transferring google forms code into html forms ...
1
vote
1answer
8k views

How do I add a field in Google Forms to show the sum of multiple fields (that are numbers)

Say for instance I want the user to input into 4 fields the meters they will dig up in different areas. On the form itself I would like to have a number at the bottom displaying the sum of 3 of said ...
3
votes
3answers
12k views

Show unique ID on the form (before submitting)

I need an anonymous form (no names, emails etc) that shows unique ID so that if a person decided to reveal that ID to me I will be able to find his/her answers in the spreadsheet. The ID can show on ...
3
votes
1answer
1k views

How to change position of column form responding sheet after add form item

I can add an item to a Google form and to change its position in the form by Google apps script. The corresponding column in the responding sheet is always the last column. I can manually move that ...
1
vote
1answer
2k views

Completing survey on Google Forms without a Google account

I have created a survey using Google Forms and need to send to University staff. How can I restrict to only one response per person without survey group having a Google account?
3
votes
1answer
356 views

Import only those cells from a spreadsheet that have certain conditional formatting

I have created a Google Form which links to a spreadsheet. There is an option which asks for the person's name. For the answers in the sheet, I've created conditional formatting to highlight the ...
2
votes
1answer
31k views

How do Google Forms handle the “Other” field in Multiple choice/Checkboxes/Drop-down questions?

We use the "Other" option on our multiple choice questions but get inconsistent results recorded for the field on both the form "Responses" tab and the connected spreadsheet as well. There seems to ...
1
vote
1answer
375 views

Scroll up to the success message once the embedded Google form is submitted

How to scroll up to the success message once the embedded Google form is submitted, so that the user sees the message? I have a height of about 2000px and when it's done the submitted message is out ...
6
votes
1answer
4k views

How to create a question in Google Forms that allows two distinct answers?

I have a question like this (it's a DISC test, if this matters): 1. From the following list, which option is 100% you and which option is 0% you? a. tall b. fat c. happy d. unemployed How can I make ...
4
votes
1answer
9k views

How to increase Google Forms content width?

I have a google form for which I have some grid questions, using long labels. This implies that some of the questions are shown with scroll bars I do not want. is there a way to configure my form to ...
-1
votes
1answer
2k views

Is it possible to show answer based on results in Google Forms?

I want to make a troubleshooting tool where the customer could answer the questions and in the end get the suggestion on how the problem could be solved. The questions are dependent. So if you choose ...
1
vote
2answers
631 views

Force Google login page to appear when accessing a Google Form?

I'm trying to create a Google Form that is locked to a specific Google Apps domain, however I'm running into the issue where if I send out the link to the form to my users and they are logged in to ...
7
votes
1answer
24k views

Apply custom CSS styles to Google Forms

Google forms are presented for the user to embed in his/her website as an iframe, which means they can't be styled by the website's own CSS. How can a Google Form be inserted into a website with a ...
2
votes
1answer
44 views

I created a copy (B) of a Google Spreadsheet (A). Now the Google Form that used to feed A is feeding B

Is there any way to change the settings of the Google Form so that it again feeds into the same worksheet of the same Google Spreadsheet (A) that it used to feed before I created the copy B? The only ...
1
vote
2answers
1k views

“Select Users from organization” field with Google Forms?

I have a Google form that allows users to send a co-worker a digital greeting card but they have to manually enter the email address of the person they are sending it to. The issue is sometimes they ...
2
votes
1answer
1k views

Google forms hierarchical multiple choice questions [duplicate]

Supposing I have 2 multiple-choice questions concerning: Country students are from: ..... (choices include USA, UK, China ....) States where they are from: then if they selected USA in the first ...
0
votes
2answers
68 views

Auto entering functions in sheets managed by forms

I want to fill a single column of my sheet with a function, the sheet is being managed by forms. So, whenever a new entry is added it adds a new row and that row will not have the function that I want,...
1
vote
2answers
2k views

Google Forms Flow not working as expected

I have a Google Form with 4 sections and it is setup like this: Section 1 - One multiple choice question Yes (Go to section 2) No (Go to section 3) Section 2 - A few questions After finished go to ...
0
votes
0answers
953 views

Script to create an edit response URL in Google Sheet sometimes fails

I have been using the "FormMule" addon to create "Form Edit URL" apart from mail merge. However, the triggers for the addon seemed to have stopped working. I found this post answered by Rubén: Show ...
0
votes
0answers
299 views

Google form that shows calculated quantity

I need to create a Google form with following properties: It should automatically take today's date as input. For many inputs there is point associated with it. The total score is sum of all points. ...
2
votes
1answer
611 views

Can I add two calculated fields to a Google Spreadsheet based on a Google Form?

I am new to Google Scripts and am hoping for some guidance on improving a manual process I complete in Google Sheets. To analyse the data I receive on a Google Form I run, I manually add-in (or copy ...
3
votes
1answer
1k views

Creating conditional sub-questions in Google Forms

I have an initial (round 1) question, which asks user to select options (checkboxes) that applies to him/her. There are total 5 checkbox options (#1, #2, #3, #4, #5). Out of the 5 options, let's ...
-1
votes
1answer
589 views

How can I make a minimal, unstyled HTML form which works with Google Forms?

I want to embed a Google Form in my website, but make it unstyled, etc., so it looks neat and can be placed in widget form.