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
1 answer
1k views

Importing data into Google Form response sheet with date, list, grid

I have a normal Google Form that is filling answers into a response spreadsheet but I want to import pre-existing data stored on another Google Sheet (100 entries) that match the Google Form responses ...
Taylor Lewis's user avatar
3 votes
1 answer
2k views

How to check if the values of two cells exist in two columns of another sheet

I am trying to make a class attendance system where the student checks in by submitting her name into google forms. The final result will be displayed in Google sheets by marking a check box after ...
Robin J's user avatar
  • 33
2 votes
1 answer
91 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?...
Kim 's user avatar
  • 21
1 vote
1 answer
32 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 ...
Senseful's user avatar
  • 31k
0 votes
1 answer
9k 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 ...
Mike M's user avatar
  • 111
-1 votes
1 answer
1k 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 ...
Algimantas's user avatar
0 votes
2 answers
128 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 ...
larry909's user avatar
  • 133
0 votes
1 answer
95 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 ...
charlie4's user avatar
0 votes
1 answer
102 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 ...
babak abdzadeh's user avatar
1 vote
0 answers
222 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 ...
Vrizz's user avatar
  • 11
2 votes
1 answer
57 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 ...
Kyle Mont Blanc's user avatar
1 vote
1 answer
1k 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,...
user228402's user avatar
2 votes
1 answer
954 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 ...
TimD's user avatar
  • 21
0 votes
2 answers
675 views

Chronological ordering of checkbox in Google Forms

I have a checkbox in my Google Form, which sends the user selections in the form in an ascending order list: But I want to grab the list in the order of selection, for example if the user clicks in ...
Daniel's user avatar
  • 101
1 vote
2 answers
1k views

Issues with Google Script on collecting Form responses and moving to another sheet

I have been trying to piece together some code for a task at work using Google Sheets and I am having some issues with what I can find versus my current knowledge level. I am trying to create a script ...
John Thompson's user avatar
1 vote
1 answer
9k views

Send a Google Forms response to specific email address based on form response

I need to send Google Forms responses to specific clinicians at my practice depending on whether they have been selected on a drop-down menu in the form. At the moment, Google Forms sends an email to ...
sophie23's user avatar
0 votes
1 answer
319 views

Google Side bar & editing form responses [closed]

I have some code which captures the URL of the edit response, so you can click it, and amend the record if needed. It pops out and opens in a new window. I wondered if it was possible to open it ...
Ceebee86's user avatar
  • 135
1 vote
1 answer
2k views

Skip arrayformula if the result of that formula is blank

I have an array formula that looks like this: =ArrayFormula(IF(COUNTIF(B2:B, QUERY('Form Responses'!B2:G, "select G where B != ''"))=0, IFERROR(QUERY('Form Responses'!B2:G, "select B, G where B != ''"...
Niels Kersic's user avatar
0 votes
1 answer
38 views

Submit response but not submit?

I have a form for timesheet, that each row is a different job description, job number, hours booked to job etc. I have it so when you submit, it fills in the response sheet in order from top to ...
Peteh's user avatar
  • 49
3 votes
2 answers
5k 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 ...
Jamil's user avatar
  • 31
0 votes
1 answer
188 views

Google Form Abandonment

If someone abandons a Google Form survey before submitting, can I still see their responses up until the point where they dropped off?
Dustin's user avatar
  • 1
1 vote
1 answer
52 views

Split data of a row in multiple rows

I've got some problem with data coming from a Google form. The result are: A|A|A|A|B|B|B|B|C|C|C|C| What I want to get is: A|A|A|A| B|B|B|B| C|C|C|C| Is there a way to get a similar result?
Fav's user avatar
  • 11
-1 votes
1 answer
640 views

How to display a text after a choice is selected in google form?

So I have my drop down connected to spreadsheet. There are two column which is ID and Name. In my google form, I want the user to select the ID but not the name. The name should be shown according to ...
pks's user avatar
  • 1
5 votes
2 answers
1k views

Is it possible to edit the column a Google Form response saves to?

I have a client who uses a Google Form to save data to a Google Sheet. They deleted and recreated one question, and the responses to that question are now being stored in a new column. This messes up ...
Catherine Pearce's user avatar
2 votes
1 answer
552 views

Google Form response is modifying a cell on another row of linked sheet

I have a sheet that is recording form responses on a linked Google sheet. The issue is that sometimes the form will modify a cell on the row above in addition to the row that is being inserted (see ...
javis_mcqueen's user avatar
2 votes
2 answers
2k views

Change default values when Google Forms autofills a Google Sheets

There's a Google form that's linked with a Google sheet: whenever a response is posted to the forme, a new line is added to the sheet (here's a quick tutorial just in case). Is it possible to have ...
PPC's user avatar
  • 267
1 vote
0 answers
1k 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 ...
Timmy Fox's user avatar
1 vote
1 answer
709 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, ...
Tan Chin Chin's user avatar
0 votes
1 answer
2k views

None of the above checkbox in Google Forms

I would like to create a multiple choice checkbox question in Google Forms with a 'None of the above' option and validate that if that option is selected, none of the other options are selected. For ...
MymsMan's user avatar
1 vote
1 answer
2k 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 ...
Meow's user avatar
  • 111
3 votes
2 answers
29k views

How to allow file upload without login in Google Forms?

I would like to create a Google form for submission of abstracts. Participants should have the option to add images, Excel files, or PDF. However, as soon as I add the File upload field in Forms, one ...
n1000's user avatar
  • 209
0 votes
1 answer
1k views

Can I have a Google form that allows users to upload documents but does not require a Google account?

I have a Google form that is requiring users (survey takers) to have a Google account to access the form. This form includes sections that require the user to upload files before they can submit. We ...
Taniko Martinez's user avatar
1 vote
1 answer
206 views

How do I get responses in Google Forms to automatically be updated when updating the spreadsheet?

I'm in a situation, where I have been given a source of information, with all sorts of people. And with that, I wish to insert all this inside of Google Forms, in the response section. And so I was ...
M. Andersen's user avatar
2 votes
2 answers
3k views

Why doesn't google forms recognize responses manually added to the responses sheet

I'm trying to see if I can add responses to a sheet manually through a proprietary application but whatever response I add to the sheets document is pushed down and isn't recorded on the responses ...
Deeswoc's user avatar
  • 31
4 votes
1 answer
9k 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.
FrankieJLyons's user avatar
1 vote
1 answer
202 views

Google Forms addressed only certain people

I would like to create a survey on Google Forms, addressed only and for certain and specific people. the user must enter the name, surname and other data. if this information does not match those in ...
nicovon's user avatar
  • 13
3 votes
2 answers
3k views

Send a google form result to an email

I need help with the google form. The problem is this: I want to receive an email with its results for every user who completes the form. For example, if you had a form that required email, name and ...
skekko's user avatar
  • 33
0 votes
1 answer
173 views

Repeatable questions

I'm trying to create a daily personnel report. Each manager needs to report who their personnel are, whether they are Present, Sick, On Leave, etc, and where they are. I then plan on having a set of ...
AzureSkye's user avatar
1 vote
3 answers
4k views

Google Forms Duplicating answers to Google Sheets

I have a google form to capture order information, When the user captured all order information, it pushes to a google sheet so we can keep an order history of who ordered what, when and how much. ...
user218381's user avatar
3 votes
3 answers
46k 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 ...
Pradip Thapa's user avatar
-1 votes
1 answer
39 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 ...
Skeleton Bow's user avatar
1 vote
2 answers
665 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 ...
Robert's user avatar
  • 11
0 votes
1 answer
321 views

Re-using a google form sent data, avoiding entering all data

I am building a Google form to manage summer camp subscriptions. Each request must enclose parents and child data. The problem is, if a family wants to subscribe more than one child, the process must ...
Riccardo's user avatar
  • 589
0 votes
1 answer
497 views

Data cleaning in Google forms

I've recently conducted a survey using Google Forms. The graphs and charts in the summary section are enough for me. However, I want to clean 10% of data (change ambiguous answers). Is there an easy ...
Drake Tran's user avatar
1 vote
2 answers
29 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 ...
kuleje's user avatar
  • 5
0 votes
1 answer
262 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 ...
Hannah Tai's user avatar
0 votes
2 answers
454 views

Prevent shifting of rows in auto-updating sheet

I am struggling with an automatically updating spreadsheet that is connected to a Google Form. Whenever there is a new accomplished answer in the Form it is adding a row in the spreadsheet, resulting ...
Leonhard Keßler's user avatar
3 votes
1 answer
3k 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?
zuzana's user avatar
  • 31
1 vote
1 answer
1k 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 ...
Sai K's user avatar
  • 11
2 votes
4 answers
40k views

Is it possible to recover deleted responses from Google Forms?

Here is the context of this question. We used Google Forms for an election of 6 people. I want to know if it is possible to delete individual responses and then recover all responses (deleted and not ...
user215264's user avatar

1 2 3
4
5
12