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
2answers
7 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?...
0
votes
3answers
395 views

Remove duplicate items from array?

What would be the best way to remove duplicate items from cells in rows? For instance... Category 1 | Item 1 | Item 2 | Item 2 | Item 3 Category 2 | Item 3 | Item 1 | Item 2 | Item 3 ...
1
vote
1answer
536 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
votes
0answers
16 views

Project reference number generator online

I have a construction business and a team of contractors. We are constantly having an issue where the contractors are unsure of what project reference number to assign their projects so as to maintain ...
0
votes
1answer
231 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.
0
votes
1answer
6 views

What happens when multiple people edit a multi-page form?

Imagine I have a multi page Google form and the "edit after submit" option is enabled. Imagine we have a 3 page form with the following text questions: Q1 Q2 Q3 The form is submitted with blank ...
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
65 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.
0
votes
1answer
19 views

Active Survey Modification

I have a live survey via Google Forms. I want to edit one of the multiple choice questions. What will happen to the existing data? Will I lose the previous answers? Is it safe to modify one of the ...
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 ...
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 ...
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 ...
0
votes
1answer
32 views

Import Form data into a sheet

I am trying to accomplish something that may not be possible. My work rents equipment to multiple companies and my boss wants me to setup a "database" of rental equipment and where its located and any ...
0
votes
1answer
3k views

Submit another response missing from Google Form

If I create a new Google Form, and leave the "Limit to 1 response" option unchecked: At the end of the form, the user will see a "Submit another response" link: However, I have an existing Google ...
0
votes
1answer
510 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 ...
0
votes
1answer
10 views

in a Google Form, can I change or remove a question safely after receiving responses/Submissions?

After I create my Google Form and start to receive submissions, can I change or remove a question or will it break the data? I know it's very picky with having to re-link the spreadsheet if I link ...
0
votes
1answer
16 views

Don't allow same answer in Google Form

So I have a problem where I want to use google form for data collection for few different teams. At google form the first question is to type in the item number (6 symbols) and there is no duplicates ...
0
votes
2answers
14 views

Will working with an active Google Form responses sheet mess anything up?

I'd like to sort rows and remove duplicates while the form is live and the responses sheet is receiving incoming responses. Will my working on the sheet while a response is coming in cause any ...
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
votes
1answer
40 views

auto-fill for new values in google spreadsheets

I have a google spreadsheet that connected to the google form, this form has the name, family name, email address and... questions. I want my spreadsheet takes name and family name and combine them ...
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 ...
0
votes
0answers
10 views

How can I get multiple choice question id form Google Form

I want to pass Google Form value to my HTML form. In my HTML form I created multiple choices questions as well as I created the same question in the Google Form now I want to pass those input values ...
0
votes
1answer
20 views

Update giveaway quantities in Google forms

I am in charge of giving away a number of T-shirts which come in different sizes and colors, but they are limited in quantity. I wanted to create a Google Form for giving the T-shirts away, but I do ...
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, ...
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
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 ...
2
votes
2answers
4k views

How to automatically wrap text to new responses from a form in a Google Spreadsheet?

I had a working Google Spreadsheet where when new responses were filled in on the form, they would automatically get textwrapped on the Form Responses sheet. Now recently I had to remake this ...
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?
0
votes
1answer
42 views

How to recall the previous info submitted and change some fields only for the next submit

In my google form to register for an event, users may need to register a few times for the different members of their group (e.g. family members) but some of the information is the same e.g. address, ...
0
votes
1answer
35 views

Look up a list embedded in a Google Sheets from a Google Forms, and add attributes to the corresponding row?

I'm running an event for a large number of children and need a way to let them register quickly as they come in, to the event. We're expecting about 400 kids who have pre-enrolled and we will have a ...
1
vote
1answer
272 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?
6
votes
1answer
7k views

How to add a multiple choice question requiring a single selection?

I am creating a Google Form for company's internal survey. Currently there are seven question types: Text Paragraph text Multiple choice Checkboxes Choose from a list Scale Grid I am looking to ...
1
vote
3answers
2k views

Google forms script to delete responses counter

I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated. My copy sheet function, and delete ...
0
votes
1answer
161 views

How to select existing sheet to be populated by a Google form?

I have a team working in pan India with 6 Team leaders. I have created a Google form to collect the everyday status report. Now the question is: How can I assign a particular sheet[already created in ...
10
votes
3answers
10k views

How can I stop Google Sheets formatting a Forms response as a date?

I have a Google Forms with a question that contains a drop-down box with the following values: - Fewer than 10 - 11-25 - 26-50 - More than 50 If the user selects 11-25, Google Sheets renders the ...
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 ...
2
votes
1answer
22 views

Using IF statements to apply an email address depending on teacher name

I am attempting to create a sign in sheet for students when they are sent to a "calming" room. The idea is that when they reach the room, they enter their name and select their teacher's name from a ...
-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.
1
vote
1answer
13 views

Conditional required questions

I am building a google form with several multiple-choice questions, I want to add a comment field below every question and make this comment required if the answer of the multiple-choice question is 3,...
0
votes
1answer
18 views

Copy Google form and linked sheet preserving existing formulas and formatting?

I am required to copy an existing Google Form, however, the linked results sheet has deep formatting and formula. Apparently, the new form requires a new sheet to be linked to form results. How can ...
2
votes
1answer
523 views

How can I get my set values and formulas to populate to a row of values received from a Google Form?

When I receive submissions from a form I am trying to find a way to include my formulas and set values in the same row as the information submitted by form. My form is only collecting 14 values but my ...
0
votes
0answers
26 views

Google Form field ID

I want to link a Google Sheets sheet with a form and pre-populate some of the data from the sheet into the form using this formula: =HYPERLINK("form URL entry.ID="&A1&"&entry.ID,"Link") ...
-1
votes
1answer
63 views

Google Forms to Google Sheets [closed]

Can someone help with this? In a Google Form I have a question in the form of a checkboxes choose where multiple answers can be selected. In sheets it putting them all into 1 cell, is there a way to ...
0
votes
1answer
462 views

Google Form File Upload - Change file name to match form value

I have a Google Form for contact information. The form asks for Given Name (col A), Family Name (col B) and a File Upload restricted to images only (col D). I have a formula which displays the Full ...
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 ...
0
votes
1answer
49 views

Need to trigger form submit when data is already populated in Google Sheet from another source

We have tried many thing to do a job basically we have a Google Sheet to collect information from Google Form once the form is submitted the data get inserted into the sheet and document studio start ...
0
votes
1answer
176 views

How to disable new row when Google Form collects responses for Google Sheet?

When Google Forms collects responses, it creates an entirely new row in the Google Sheet which I don't want to happen because I am using a VLOOKUP for another sheet and it's not grabbing the data I ...
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 ...
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 ...
0
votes
1answer
378 views

Add file submitted to specific folder based on answer in google forms

I'm trying to create different subfolders for uploaded files based on the multiple choice question i have in one of my google forms. The form is for certain locations, so based on the location that ...