People who code: we want your input. Take the 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
1answer
70 views

How to use Lookup formula for new rows in Google Sheets submitted via Google Form?

I am using the following Lookup formula in a Google Sheet: =LOOKUP(F2, AreaCodes) I need that formula to be triggered when new rows are added via a Google Form. I'm guessing the solution has ...
0
votes
0answers
65 views

How can I SUMIF a row, but have the formula automatically applied to all new rows below it in Google Sheets?

I've made an inventory tracking spreadsheet that gets raw data from Google Forms. Forms inputs data into Sheets in a less than ideal way, but there's nothing I can do about that, so I'm stuck post-...
0
votes
1answer
506 views

Form that only allow for one person to choose each option [closed]

I need to create a form where people can select one of the options made available, and, once they do, that option becomes unavailable to anyone signing in afterwards. (Or where I can define the amount ...
1
vote
1answer
100 views

Can I set a limit of 2 entries on Google Forms?

I use Google Forms in my classroom to administer certain quizzes, however, I allow my students two attempts on these. I have noticed that I am unable to see how may actual attempts have been made and ...
2
votes
2answers
12k views

I lost my response in Google Form after accidentally deleted the questions

I created a google form this afternoon and there were lots of response that I received. And then I accidentally deleted all of the questions and I thought I can simply edited it back. when I edited it ...
-1
votes
1answer
1k views

Get email address in from Google Forms in script

I'm creating a Google Form where guests can log in and an email will be automatically be sent to the person that submits their form. They are not required to log into Google as this will be running on ...
0
votes
1answer
1k views

Add dynamic questions in Google forms

I am using google forms to punch orders in my Google Sheets. Although I am facing a challenge as the number of products is variable. For example Question 1: Item Name Question 2: Quantity I ...
1
vote
2answers
916 views

Embed just the google forms analytics page

I made a test google form and I have embedded it successfully... How do I embed just the stats/ analytics page? The page that allows people to see a pie chart of the collective survey results... link:...
1
vote
1answer
65 views

How can I populate and submit a Google form using info from Google Sheets?

I'm new to Google script editor and not sure how to go about this. I have a group of people filling out referrals through the Google Form "A", and I would like to use the output of these forms to ...
0
votes
1answer
101 views

applying a formula to the data from google forms

I have a google spreadsheet which is connected to a google forms I wanted one formula to be automatically copied to the new lines(Column R) when google form response is submitted the spread sheet: ...
-1
votes
1answer
546 views

Google form where all answer options calculate to 100%?

Put the % of how much you spend of your salary in the following categories: [Airtravel, Rail transport, Taxi, Personal car, Uber ...., Other] I want to format the question in Google Forms such that: ...
3
votes
3answers
3k views

Google Forms quiz submit ONLY when ALL correct

I would like to use Google Forms to create a simple 5 question multiple choice quiz. When the user has selected their answers and clicked Submit I would like to display immediate feedback on the same ...
0
votes
1answer
5k views

How can I get data from Google Sheets to a Google Forms dropdown list?

I have some data in a Google Sheets file. I want to get a Google Forms dropdown list to be updated automatically from that list. Is it possible?
0
votes
2answers
2k views

How can i add search bar above dropdown menu on Google Forms?

There are around 550+ items on the dropdown list, is it possible to filter them out?
4
votes
4answers
777 views

How to prevent Google Sheets from reformating input from Google Forms?

I need to create Google Form where users can submit different data. Problem is that some of them use comma and others use dots as decimal separator and my Form should handle them both. Problem is, it ...
0
votes
1answer
233 views

Google Apps Script send attachment on cell value

First of all I am a complete beginner in coding. So I am trying to build a form, that once it is submitted, will send a different gdrive file as excel sheet based on a key word in the form. So far I ...
0
votes
1answer
49 views

How to save question before going back to the same question in Google Forms?

I need to make a questionnaire. The idea of the questionnaire is that it asks the user first two different questions (name and country) and after the two questions it asks that if the user wants to ...
0
votes
1answer
32 views

Send a Google Forms notification to two differenz email addresses based on

How can I send an automatic email notification to two different email addresses depending on whether a woman or a man has filled in the form? Please can someone help me with a script to check this ...
0
votes
1answer
2k views

How to Redirect to another Website upon Google Form Submission?

I have a Google Form which is backed by a Google Apps Script with an onFormSubmit function, which fires when the Form is submitted. The next thing I want to do is, after the Form data processing is ...
0
votes
1answer
40 views

Google Sheets formula

I'm using Google Sheets make a spreadsheet with the name in column a, the company in column b and in column f, I need their email. I have 3 companies, and they have slightly different email formats. ...
1
vote
1answer
37 views

How to display of results in Google Forms after deleting some response?

I have collected some data using Google Form that are visualized by Google Form in histogram and pie chart. Now I want to circulate URL of same Google Form. But I want it should show the visualization ...
2
votes
1answer
897 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
52 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?...
1
vote
1answer
19 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 ...
0
votes
1answer
3k 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 ...
-1
votes
1answer
297 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
56 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 ...
2
votes
1answer
532 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
60 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
69 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
0answers
99 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 ...
2
votes
1answer
45 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
vote
1answer
442 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,...
1
vote
1answer
453 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 ...
0
votes
2answers
255 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 ...
1
vote
2answers
742 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 ...
1
vote
1answer
7k 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 ...
0
votes
1answer
222 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 ...
1
vote
1answer
998 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 != ''"...
0
votes
1answer
30 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 ...
2
votes
2answers
4k 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 ...
0
votes
1answer
86 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?
1
vote
1answer
36 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?
-1
votes
1answer
101 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 ...
4
votes
2answers
145 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 ...
1
vote
1answer
68 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 ...
2
votes
2answers
1k 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 ...
1
vote
1answer
601 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 ...
1
vote
1answer
338 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, ...

1 2
3
4 5
12