2022 Developer Survey is open! Take survey.

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
0 votes
0 answers
21 views

Collecting crowd-sourced data in tabular or spreadsheet format

I'm involved in a citizen-science project, polling recreational anglers about their fishing locations on the ocean (lat-lon), various characteristics at each location (depth, what species they catch, ...
user avatar
0 votes
1 answer
13 views

Where can we see Google Forms we submit?

Is it possible to view the information or confirm we sent in Google Forms? Assuming the form itself did not have the checkbox that said send me my answers.
user avatar
0 votes
1 answer
36 views

RegEx on Google Forms: How to make Case Insensitive work?

I have been wondering, how to use case insensitive regular expression for a response validation in a form where there are different possible answers? I have tried: (name1|name2|name3) and it really ...
user avatar
  • 45
0 votes
0 answers
26 views

Why can I not upload any document to Google Form?

When I try to upload pdf or MS word etc. to Google Form by clicking the upload file button, it shows only a white page as in picture but it does not show further options to select the document. Please ...
user avatar
  • 1
0 votes
1 answer
19 views

Formula for Daily Cash Balance Sheet

I have created a Google Form for cashiers to balance out their cash drawers at the end of each day. Currently I have the form set so that they only have to count the amount of each coin/bill and not ...
user avatar
0 votes
0 answers
18 views

Is it possible to generate response url of google forms without editing permissions?

I know, that there is a getEditResponseUrl() function, but it generates URL with editing permission. Is there any way to have this URL without editing permission, just response?
user avatar
0 votes
1 answer
22 views

Google Forms corresponding to a pre-set date on Sheets instead of being added consecutively

Is it possible to have Google Form data inputs being added not one after the other but corresponding with the Date that is pre-filled on the response form? Here you can see how the data is currently ...
user avatar
  • 1
0 votes
1 answer
28 views

#REF!, How to Grab the first response of form and ignore the duplicate in google sheets

I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...
user avatar
0 votes
0 answers
43 views

Import Data to Google Form

I have a Google Form that is going to ask users a number of questions about a certain service they can choose from a drop down question. Is it possible to import data from a linked Google Sheet into ...
user avatar
  • 101
0 votes
0 answers
17 views

Google Form which uses a pre built sign in

Been reading a lot about Google Forms which need a Gmail account to fill in. I'm having another Gmail account only for sharing pictures with club members. Is there a way to create a form to upload ...
user avatar
1 vote
1 answer
210 views

How do I find where the Google Form is saved?

I've started a contract at a small company to update all their google forms. The forms were set up 5 years ago by the last contractor. Unfortunately this means none knows where the forms are saved on ...
user avatar
  • 11
0 votes
1 answer
94 views

Merge multiple columns in Google Sheets from questions in Google Forms if all questions are the same

I have a Google Form where I ask for the specific college someone is studying in (i.e. college of engineering, college of business, etc.) and then send them to a specific question where they select an ...
user avatar
0 votes
0 answers
18 views

Creating questions based on answers without multiple sections in Google Forms

I'm trying to ask specific questions based on previous answers using Google Forms. I'm aware that this is possible by creating multiple sections and directing users to specific sections according to ...
user avatar
0 votes
0 answers
22 views

Auto populate comment

Is there a way to have google sheets auto populate a comment based on specific entries in a cell? I am trying to have google sheets auto populate a google form response if certain content is entered ...
user avatar
0 votes
1 answer
153 views

How to format a google sheet that's capturing google form data?

I have a google form which I linked to a google sheet via the "create spreadsheet" button on the form. Is there a way to format the resulting google sheet for current and future form ...
user avatar
0 votes
1 answer
15 views

Google forms to google sheets to google doc - How to set date to display dd-mmm-yy in sheets and doc?

I'm fairly new to coding, and am trying to get my head around a problem for some work admin. I´m hoping there's a quick and simple fix to this. So as the title says, we enter info on a google form and ...
user avatar
1 vote
0 answers
11 views

How to build an online quiz that shows a running total of points and allows for partial scores? [closed]

I'm trying to build a simple website that will help people determine if they are eligible for a particular government program. Eligibility is determined by points in various categories (age, ...
user avatar
  • 11
0 votes
1 answer
13 views

Can I edit choices without affecting the already submitted responses?

So I have made a form for a project. I got some responses, but now I want to translate the whole form into English. The problem is that if I try to edit the choices, the responses stay the same, in ...
user avatar
  • 1
1 vote
2 answers
415 views

Hide Respondent's Email Address in Google Form

When someone responds to my Google Form, it displays their email address at the top of the form. I've disabled the option Disable autosave for all respondents in the form settings but the message ...
user avatar
  • 1,918
0 votes
1 answer
71 views

Google form save responses in multiple files based on condition on submit

I have this problem: A Google Form that saves data into one file (spreadsheet) Multiple users (admins) that access this file (all of them can see all rows) Let's say first column is called Department ...
user avatar
  • 103
0 votes
1 answer
29 views

Google Sheets - Multiple if statements with and function

I am trying to build a check in/ check out tracker for my team using google forms and google sheets. The idea is that once Someone submits their response through google form, it comes to google sheet. ...
user avatar
  • 3
0 votes
0 answers
23 views

i want a free online tool to collect signatures

i want a free online tool to collect data with signatures from my colleagues ( about 200 - 300 ) in a pdf or word My Needs: Online tool to collect signatures simultaneously not in queue or stack ...
user avatar
1 vote
0 answers
248 views

How to retrieve Google Form and its 240 responses that have disappeared

Please help me retrieve my Google Form and its 240 responses have disappeared. Those 240 responses have been collected over 2 years as part of my thesis survey. I could access the form and responses ...
user avatar
0 votes
1 answer
16 views

Importing multiple user responses on a Form to a single row on a Sheet

I have a Google Form containing three linear scale questions. The form collects emails and then a value between 1 and 3 for each question. I need the people who respond to the form to do so biweekly....
user avatar
1 vote
1 answer
11 views

Unpopulate Google Form by default

I made a survey in Google Forms. It consists of several multiple-choice questions. When I preview the form or use the link I would send to participants, some of the answers are already populated/...
user avatar
  • 113
0 votes
0 answers
18 views

I duplicate a form in Google Form. Why does modifying the new copy overwrite the old one?

I know that there are a button in Google Form to copy questions from other form. I just want to know that when I copy a form and paste it to another place within the Drive, modifying the new one will ...
user avatar
  • 740
0 votes
1 answer
28 views

Auto deleting columns when the field is blank

I have created a form that have multiple sections, skipping sections based upon an answer. I have then linked a Google Sheet to this Google Form to collect responses. These responses are auto filtered ...
user avatar
  • 1
0 votes
1 answer
246 views

App script sheets to update google form dropdown

I'm trying to create a registration form that can be imbedded into our club website for users to sign up to our sessions with. I need the form to be updated via the back end database which i'll add ...
user avatar
1 vote
1 answer
73 views

Separating multiple section inputs into multiple lines of data (I can't get it to work even with the other threat help that is there already)

Hello Google Masterminds, I come to you since I have followed almost every single youtube video and every single thread here and I been working with this freaking form for the past 3 weeks and have ...
user avatar
0 votes
0 answers
41 views

How to show Google Forms linear scale labels in results page?

Apparently, linear scale labels in Google Forms results are hidden, vanishing readability. Is there any trick to show labels in results, which would be useless without a label?
user avatar
  • 479
0 votes
0 answers
11 views

How to create option to add another registration on Google Forms

I'm trying to make a basketball competition registration form. So you can register as a team or individual (multiple choice) If you register as an individual, your brought to another section for your ...
user avatar
  • 1
0 votes
1 answer
2k views

Use comma as decimal separator in form based on Google Sheets?

I have seen this question but my question is different. My sheet uses comma as decimal separator but when I publish it as a form, dot is used as the decimal separator. How do I change decimal ...
user avatar
  • 541
0 votes
1 answer
1k views

Google Forms: Disable the "back" option on a multi-section quiz?

I would like to create a quiz whereby respondents watch video and answer questions about it. It is important that the respondents only watch the video once. In order to do this, I have split the form ...
user avatar
0 votes
3 answers
477 views

Add a new row each time a new response is added to the Google Form

I have a Google Sheet linked to a Google Form. In the second page I added a formula to clean up the data, since one of the questions allows to chose multiple options and it results in a column with ...
user avatar
0 votes
0 answers
13 views

Google Forms multiple choice quiz ( mathematical equation in feedback section)

Is there a way for me to put mathematical equation in the feedback(Answer key) of a multiple choice Google Form. Side not, can I change the score from appearing on the top left corner.
user avatar
0 votes
2 answers
43 views

Get two different type of answers to an answer

How can I get Google Forms to allow me to have two different type of answers to one question? Answers are to be related between them so when working results, I can get the grades of each group member. ...
user avatar
0 votes
1 answer
168 views

Requiring an exact number of checkboxes ticked based on previous multiple choice response in Google Forms

I have a multiple checkbox question that needs to have exactly the same number of ticked checkboxes as given in a multiple choice question. So if a user chooses the option 2 in the multiple choice ...
user avatar
-1 votes
1 answer
649 views

How to add 1 question in Google Forms which takes multiple inputs from the user and stores in a single column in Google sheets

I am struggling to create a custom question in Google forms which can ask the user for Multiple inputs or Short texts. For example If I ask a question to a shopkeeper: "Name all the vegetables ...
user avatar
0 votes
1 answer
159 views

Shuffling questions in only one section of a Google Form

I am creating this Google Form with two sections. One takes the student information; Reg. No., Name, Class etc., and the other section contains the subject-related questions which I need to have ...
user avatar
  • 101
0 votes
2 answers
50 views

Multiple choice response in rows without repeating other entries

We have a multiple choice question in our Google Form. We use some other spreadsheets to re-organize questions from the Google Form response sheets. What we need is having multiple choice responses ...
user avatar
0 votes
1 answer
40 views

How to give access of Response sheet linked with Google Form to only those who filled form?

Let's say I'm collecting Name and Email (using Collect Emails setting), I wish to allow view-access to the Google Sheets Response Sheet linked to that form with only those who put their email id. ...
user avatar
-1 votes
1 answer
21 views

Updating a cell when a new form is submitted

I am trying to pull scores from one google sheet to another, and I want this information to update when a new form is submitted by the same person. Score page Summary Page Link to sheets Link to ...
user avatar
  • 15
1 vote
1 answer
1k views

How can I merge responses of two Google Form identical to each other but in two different languages

I want to combine the responses of two of my Google Forms that are identical to each other but in two different languages. How can I combine the responses to get the summary of both sets of responses?
user avatar
-1 votes
1 answer
2k views

How to create a sort function that would automatically sort new incoming data [duplicate]

I linked a form to google spreadsheets, so now all the responses on that form are linked, and they automatically are added as plain data in the spreadsheet. One of the columns is date-data, on column ...
user avatar
0 votes
1 answer
284 views

When uploading a file on Google Forms, I would like the file uploads to go into a custom folder based on the form response (their name)

Ex. someone submitting the form with a file upload and on form submit it creates a custom folder based on their form response (their name) on Google Drive with their submission in it. Using this ...
user avatar
2 votes
1 answer
138 views

How to convert text to a number in Google sheets

I've built a form that dumps data to a Google spreadsheet and that data, studio reads it... and turns that into a dashboard.. only problem is the text doesn't convert very well for building a dash ...
user avatar
0 votes
1 answer
394 views

Google Apps Script MailApp Not Sending Email To Script Owner

I've set up a script to take information from a Google Form and email that information to multiple people using Google Apps Script. What it does not do, however, is email the owner of the script. I'...
user avatar
0 votes
1 answer
32 views

Google Sheets Google Forms updates

I have created a Google Form for which collects data from a user. Once the use submits the form I have scripts that copy the data to several other Google sheets and then send an email to the ...
user avatar
-1 votes
1 answer
63 views

Autofill Google Form for Sent Emails

Problem: I need to keep a comms log for emails sent by my teams to other teams. We are running a multiyear project that has over 150 customers. We often escalate and get responses from directors ...
user avatar
0 votes
2 answers
423 views

Arrange Google Form Checkbox Responses into a List

I am collecting scholarship recipients in a Google form. The recipients names are in a checkbox format, as some donors give to multiple students. I need to separate out the names into additional rows, ...
user avatar
  • 1

1
2 3 4 5
12